CASE: DEMAND ESTIMATION and ELASTICITY: Soft Drinks in the U.SDemand can be estimated with experimental data, time-series data, or cross-section data. In this case, cross-section data appear in the Excel file. Soft drinkconsumption in cans per capita per year is related to six-pack price, income percapita, and mean temperature across the 48 contiguous states in the UnitedStates.Consider variables quantity sold (Cans per capita per year) and price only:A.Write down the (linear) regression model for this case.B. Estimate the demand for softdrinks using Excel. Provide the results here.CInterpret the coefficients of the parameters estimated.DTest the hypothesis: Ho: b = 0 (where b is the slope).FDescribe the overall goodness of fit of the model and the overall explanatory power of the mode.

TABLE 1. SOFT DRINK DEMAND DATA State Cans/Capita/Yr |6-Pack Price ($) Income/Capita ($1,000) Mean Temp. (F) Alabama 200 2.19 11.7 Arizona 150 1.991 15.3 62 Arkansas 237 1.93 9.9 63 California 135 2.59 22.5 56 Colorado 121 2.29 17.1 Connecticut 118 2.49 24.3 Delaware 217 1.99 25.2 Florida 242 2.29 16.2 Georgia 295 1.891 12.6 Idaho 85 2.39 14.4 Illinois 114 2.35 21.6 Indiana 184 2.19 Iowa 104 2.21 14.4 Kansas 143 2.17 15.3 Kentucky 230 2.05 11.7 Louisiana 269 1.97 13.5 Maine 111 2.19 14.4 Maryland 217 2.11 18.9 Massachusetts 114 2.29 19.8 Michigan 108 2.25 18.9 Minnesota 108 2.31 16.2 Mississippi 248 1.98 Missour 203 1.94 17.1 Montana 77 2.31 17.1 Nebraska 97 2.28 14.4 Nevada 166 2.19 21.6 New Hampshire 177 2.27 16.2 New Jersey 143 2.31 21.6 New Mexico 157 2.17 13.5 New York 111 2.43 22.5 North Carolina 330 1.89 11.7 North Dakota 63 2.33 12.6 Ohio 165 2.21 19.8 Oklahoma 184 2.19 14.4 Oregon 68 2.251 Pennsylvania 121 2.31 Rhode Island 138 2.23 18 South Carolina 237 1.93 10.8 South Dakota 95 2.34 11.7 Tennessee 236 2.19 11.7 Texas 222 2.08 15.3 Utah 100 2.37 14.4 Vermont 64 2.36 14.4 Virginia 270 2.04 14.4 Washington 77 2.19 18 West Virginia 144 2.11 13.5 Wisconsin 97 2.381 17.1 Wyoming 102 2.31 17.1