Demand Estimation

DEMANDESTIMATION:SoftDrinks

Demand canbeestimated with experimentaldata, time-seriesdata,orcross-section data.In thiscase, cross-section data appearin the Excelfile.Softdrinkconsumptionincanspercapitaperyearisrelatedtosix-packprice,incomepercapita,andmeantemperature acrossthe48 contiguousstatesin the UnitedStates.

QUESTIONS

1.      Giventhedata, pleaseconstructamultiplelinearregression program byMSExcel.

2.      Interpreteachcoefficient ofindependentvariableinthesoftdrinkdemandestimatedfunctioninquestion1.

3.      Givenyouranswerinquestion1,pleasecommentonwhethertheregressionestimatedfunctionis agoodfitor not.Whatistheinterpretation ofcoefficientofdetermination (R-square)? Mayweusetheestimatedfunctionto predict forthefuturedemand?Explainwhy.

4.      How manycans/capita/yearonsoftdrink should befora stateinwhich6-packprice=$1.95, Income/Capita=$23,500,andMeanTemp= 68°F?

5.      Nowomitthe priceandtemperaturefromthe regressionequation.Shouldamarketing planforsoftdrinksbe designedthatrelocatesmostcanneddrink machinesintolow-incomeneighborhoods?Whyorwhy not?