🏷️ LIMITED TIME OFFER: GET 20% OFF GRADE+ YEARLY SUBSCRIPTION β†’
Log in
Economics
1
answer
0
watching
300
views
2 Jun 2019

Demand 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 drink consumption in cans per capita per year is related to six-pack price, income per capita, and mean temperature across the 48 contiguous states in the United States.

QUESTIONS

1. Given the data, please construct the demand estimation for soft drink consumption in the United States by

(1) a multiple-linear regression equation and (2) a log-linear (exponential) regression equation

2. Given the log-linear equation, please provide the price elasticity of demand and income elasticity. Comment on whether the demand is elastic or inelastic and whether soft drink is a necessity, normal good or luxury good.

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 66
Arizona 150 1.99 15.3 62
Arkansas 237 1.93 9.9 63
California 135 2.59 22.5 56
Colorado 121 2.29 17.1 52
Connecticut 118 2.49 24.3 50
Delaware 217 1.99 25.2 52
Florida 242 2.29 16.2 72
Georgia 295 1.89 12.6 64
Idaho 85 2.39 14.4 46
Illinois 114 2.35 21.6 52
Indiana 184 2.19 18 52
Iowa 104 2.21 14.4 50
Kansas 143 2.17 15.3 56
Kentucky 230 2.05 11.7 56
Louisiana 269 1.97 13.5 69
Maine 111 2.19 14.4 41
Maryland 217 2.11 18.9 54
Massachusetts 114 2.29 19.8 47
Michigan 108 2.25 18.9 47
Minnesota 108 2.31 16.2 41
Mississippi 248 1.98 9 65
Missouri 203 1.94 17.1 57
Montana 77 2.31 17.1 44
Nebraska 97 2.28 14.4 49
Nevada 166 2.19 21.6 48
New Hampshire 177 2.27 16.2 35
New Jersey 143 2.31 21.6 54
New Mexico 157 2.17 13.5 56
New York 111 2.43 22.5 48
North Carolina 330 1.89 11.7 59
North Dakota 63 2.33 12.6 39
Ohio 165 2.21 19.8 51
Oklahoma 184 2.19 14.4 82
Oregon 68 2.25 17.1 51
Pennsylvania 121 2.31 18 50
Rhode Island 138 2.23 18 50
South Carolina 237 1.93 10.8 65
South Dakota 95 2.34 11.7 45
Tennessee 236 2.19 11.7 60
Texas 222 2.08 15.3 69
Utah 100 2.37 14.4 50
Vermont 64 2.36 14.4 44
Virginia 270 2.04 14.4 58
Washington 77 2.19 18 49
West Virginia 144 2.11 13.5 55
Wisconsin 97 2.38 17.1 46
Wyoming 102 2.31 17.1 46

Watch
1
answer
0
watching
300
views

For unlimited access to Homework Help, a Homework+ subscription is required.

Elin Hessel
Elin HesselLv2
3 Jun 2019

Unlock all answers

Get 1 free homework help answer.
Already have an account? Log in
Share

Related textbook solutions

Principles of Economics
2nd Edition, 2017
Openstax
ISBN: 9781947172364
Principles of Macroeconomics
2 Edition,
Openstax
ISBN: 9781947172388
Principles of Microeconomics
2 Edition,
Openstax
ISBN: 9781947172340

Related questions

*PLEASE DO NOT COPY AND PASTE FROM PREVIOUS QUESTION*

(This question was asked before, but has different variables, espically number 4. Thanks again!)

Thank you for taking your time and looking at my questions. I need help, obviously. :/

DEMAND ESTIMATION: Soft Drinks

Demand 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 drink consumption in cans per capita per year is related to six-pack price, income per capita, and mean temperature across the 48 contiguous states in the United States.

QUESTIONS
1. Given the data, please construct a multiple linear regression program by MS Excel. (20%)

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

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. (20%)

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

The Demand for soft drink (in cans per capita per year) is estimated as Log Q = a + b log P+ c log I + d log T

where Q = Soft drink consumption in cans per capita per year

P = 6-pack price

I = Income Per capita

T = Mean temperature across the 48 contiguous states in the United States
Soft Drink Demand Data:
cans/capita/yr 6 pack price income/capita mean temp
Q P I T
Alabama 200 2.19 13 66
Arizona 150 1.99 17 62
Arkansas 237 1.93 11 63
California 135 2.59 25 56
Colorado 121 2.29 19 52
Connecticut 118 2.49 27 50
Delaware 217 1.99 28 52
Florida 242 2.29 18 72
Georgia 295 1.89 14 64
Idaho 85 2.39 16 46
Illinois 114 2.35 24 52
Indiana 184 2.19 20 52
Iowa 104 2.21 16 50
Kansas 143 2.17 17 56
Kentucky 230 2.05 13 56
Louisiana 269 1.97 15 69
Maine 111 2.19 16 41
Maryland 217 2.11 21 54
Massachusetts 114 2.29 22 47
Michigan 108 2.25 21 47
Minnesota 108 2.31 18 41
Mississippi 248 1.98 10 65
Missouri 203 1.94 19 57
Montana 77 2.31 19 44
Nebraska 97 2.28 16 49
Nevada 166 2.19 24 48
New Hampshire 177 2.27 18 35
New Jersey 143 2.31 24 54
New Mexico 157 2.17 15 56
New York 111 2.43 25 48
North Carolina 330 1.89 13 59
North Dakota 63 2.33 14 39
Ohio 165 2.21 22 51
Oklahoma 184 2.19 16 82
Oregon 68 2.25 19 51
Pennsylvania 121 2.31 20 50
Rhode Island 138 2.23 20 50
South Carolina 237 1.93 12 65
South Dakota 95 2.34 13 45
Tennessee 236 2.19 13 60
Texas 222 2.08 17 69
Utah 100 2.37 16 50
Vermont 64 2.36 16 44
Virginia 270 2.04 16 58
Washington 77 2.19 20 49
West Virginia 144 2.11 15 55
Wisconsin 97 2.38 19 46
Wyoming 102 2.31 19 46

( Data in Excel have been saved in the folder of Exam I on weekly study materials

In order to receive full points, you need to show me in details how to get your answers. )

1) What is regression equation using multiple linear regression model?

How would you interpret the coefficients of each independent variable in the model? (5 points)

2) What is price elasticity of demand ? How would you interpret it? (5 points)

3) The approximate percentage increase or decrease in demand if 6-pack price percentage increases by 3%.

****MUST SHOW ALL WORK

Suppose one of your colleagues suggests a marketing plan for soft drinks which relocates most canned drink vending machines into low-income neighborhoods. 1. Based on your analyses so far, would you agree to her suggestion? Why or why not? What the descriptive analysis indicates and what the regression analysis suggests might differ from each other. And I donҀ™t suppose there is a clear-cut yes/no type answer to this question. Rather I will focus on your reasoning and persuasive writing skills here.

cans/capita/yr 6 pack price income/capita mean temp
Alabama 200 2.19 13 66
Arizona 150 1.99 17 62
Arkansas 237 1.93 11 63
California 135 2.59 25 56
Colorado 121 2.29 19 52
Connecticut 118 2.49 27 50
Delaware 217 1.99 28 52
Florida 242 2.29 18 72
Georgia 295 1.89 14 64
Idaho 85 2.39 16 46
Illinois 114 2.35 24 52
Indiana 184 2.19 20 52
Iowa 104 2.21 16 50
Kansas 143 2.17 17 56
Kentucky 230 2.05 13 56
Louisiana 269 1.97 15 69
Maine 111 2.19 16 41
Maryland 217 2.11 21 54
Massachusetts 114 2.29 22 47
Michigan 108 2.25 21 47
Minnesota 108 2.31 18 41
Mississippi 248 1.98 10 65
Missouri 203 1.94 19 57
Montana 77 2.31 19 44
Nebraska 97 2.28 16 49
Nevada 166 2.19 24 48
New Hampshire 177 2.27 18 35
New Jersey 143 2.31 24 54
New Mexico 157 2.17 15 56
New York 111 2.43 25 48
North Carolina 330 1.89 13 59
North Dakota 63 2.33 14 39
Ohio 165 2.21 22 51
Oklahoma 184 2.19 16 82
Oregon 68 2.25 19 51
Pennsylvania 121 2.31 20 50
Rhode Island 138 2.23 20 50
South Carolina 237 1.93 12 65
South Dakota 95 2.34 13 45
Tennessee 236 2.19 13 60
Texas 222 2.08 17 69
Utah 100 2.37 16 50
Vermont 64 2.36 16 44
Virginia 270 2.04 16 58
Washington 77 2.19 20 49
West Virginia 144 2.11 15 55
Wisconsin 97 2.38 19 46
Wyoming 102 2.31 19 46

Related Documents

ECO220Y1
Final Exam
Study Guide
ECO220Y1 Midterm: ECO220Y1Y UTSG Term Test 220 4 APR13 FORM A Solution less paper
turquoisegnu128
ECO220Y1
Final Exam
Study Guide
ECO220Y1 Midterm: ECO220Y1Y UTSG Term Test 220 4 APR13 FORM A
turquoisegnu128

Weekly leaderboard

Home
Homework Help 3,900,000
Economics 400,000
Start filling in the gaps now
Log in