Estimated function to predict for the future demand

Reference no: EM13995953

1. Given the data, please construct a multiple linear regression program by MS Excel.

2. Interpret each coefficient of independent variable in the soft drink demand estimated function in question 1.

3. Given your answer in question 1, please comment on whether the regression estimated function is a good fit or not. What is the interpretation of coefficient of determination (R-square)? May we use the estimated function to predict for the future demand? Explain why.

4. How many cans/capita/year on soft drink should be for a state in which 6-pack price=$1.95, Income/Capita=$23,500, and Mean Temp= 68°F?

5. Now omit the price and temperature from the regression equation. Should a marketing plan for soft drinks be designed that relocates most canned drink machines into low-income neighborhoods? Why or why not?

Attachment:- 1483559_2_Copy-of-ECON-3305-Case-1-Data.xls

Reference no: EM13995953

Questions Cloud

What force does heart exert to accomplish the pressure : The left side of the heart creates a pressure of 120 mm Hg by exerting a force directly on the blood over an effective area of. What force does it exert to accomplish this?

Goals of economic policymakers is generally : Which of the following goals of economic policymakers is generally false? They try to keep unemployment low to avoid leaving productive resources idle. They find low inflation desirable because it helps to keep unemployment under control. They want t..

What is the net torque about the axle : The 22-cm-diameter disk in the figure below can rotate on an axle through its center. What is the net torque about the axle if F = 20 N?

About an increase in aggregate demand : Which of the following statements about an increase in aggregate demand is false? An increase in aggregate demand can be caused by a decrease in other countries’ interest rates. An increase in aggregate demand will result in no change in the price le..

Estimated function to predict for the future demand : Now omit the price and temperature from the regression equation. Should a marketing plan for soft drinks be designed that relocates most canned drink machines into low-income neighborhoods? Why or why not?

Consumption of both types of goods relative to cash transfer : When I explain to my friends that we can help poor people more if we just give them cash transfers, they complain that the poor people will spend the money on things that are bad for them. Assume there are two types of goods—“good-for-you” goods and ..

Determine fees paid to this firm by type of service provided : What kind of evidence the auditors found that indicated the company did not follow Generally Accepted Accounting Principles (GAAP).

Elasticity-time-calculate the elasticity implied : Elasticity-time! Calculate the elasticity implied by the information given (own-price, cross-price, or income), interpret the elasticity (“For a one percentage point change in…”), and tell me what the elasticity implies about the good or goods.

Two goods-fancy dates and casual dates : Suppose there are two goods: fancy dates and casual dates. Ignoring the specific numbers above, draw the utility maximization problem for a person choosing a combination of the two goods. Think both about what your budget constraint should look like ..

User Account

All Pages