Demand Estimation

DEMANDESTIMATION:SoftDrinks

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

 1.      Giventhedata, pleaseconstructamultiplelinearregression program byMSExcel.

 2.      Interpreteachcoefficientofindependentvariableinthesoftdrinkdemandestimatedfunctioninquestion1.

 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.Shouldamarketingplanforsoftdrinksbe designedthatrelocatesmostcanneddrink machinesintolow-incomeneighborhoods?Whyorwhy not?