demand regression project
Project Description:
demand regression project
econ 4570
data: elecdemanddata.xls under demand project data on d2l
1. using the data file above, run a linear regression of
dependent variable: milkwh
explanatory variables: pop, pkwh, pgas, income.
which coefficients (including the constant) are statistically significant at the 10% level or better?
which are not significant?
how much of the variation in the dependent variable is explained by the estimated equation?
is the equation as a whole statistically significant? at what level?
2. run another regression like that in 1 above, but leave out the explanatory variables that were
not significant at the 10% level or better.
are any coefficients not significant at the 10% level?
how did the rsquared change from the regression in 1?
how did the f statistic and its significance level change?
in regression #2, are the signs (+ or ) of the estimated coefficients consistent with economic
theory? explain. (hint: is the demand curve downward sloping? are the related goods
complements or substitutes? does an increase in population increase demand?)
for regression #2, what are the inverse demand equation and the marginal revenue equation
derived from the estimated demand equation? write these out using numbers calculated from
your regression output and the means of the variables listed below.
attach copies of your regression output for 1 and 2 along with your answers.
show your work on all calculations.
you may cooperate or work in groups to run the regressions. groups may turn in one completed
task identifying all students in the group. the regressions may be run in excel or the
statistical package of your choice (minitab, etc.).
means of regression variables
milkwh 25,364
pop 5,756,577
pkwh 9.0
pgas 11.40
income 32,345
econ 4570
data: elecdemanddata.xls under demand project data on d2l
1. using the data file above, run a linear regression of
dependent variable: milkwh
explanatory variables: pop, pkwh, pgas, income.
which coefficients (including the constant) are statistically significant at the 10% level or better?
which are not significant?
how much of the variation in the dependent variable is explained by the estimated equation?
is the equation as a whole statistically significant? at what level?
2. run another regression like that in 1 above, but leave out the explanatory variables that were
not significant at the 10% level or better.
are any coefficients not significant at the 10% level?
how did the rsquared change from the regression in 1?
how did the f statistic and its significance level change?
in regression #2, are the signs (+ or ) of the estimated coefficients consistent with economic
theory? explain. (hint: is the demand curve downward sloping? are the related goods
complements or substitutes? does an increase in population increase demand?)
for regression #2, what are the inverse demand equation and the marginal revenue equation
derived from the estimated demand equation? write these out using numbers calculated from
your regression output and the means of the variables listed below.
attach copies of your regression output for 1 and 2 along with your answers.
show your work on all calculations.
you may cooperate or work in groups to run the regressions. groups may turn in one completed
task identifying all students in the group. the regressions may be run in excel or the
statistical package of your choice (minitab, etc.).
means of regression variables
milkwh 25,364
pop 5,756,577
pkwh 9.0
pgas 11.40
income 32,345
Skills Required:
Project Stats:
Price Type: Fixed
Project Budget:
$0 to $10
Completed
Total Proposals: 4
1 Current viewersl
57 Total views
Project posted by:
Proposals
Proposals
Reputation
Price offered

NEGOTIABLE. Hi? Can we please talk about this work. Thank you.93 Jobs 34 Reviews $100 in 4 Days

Hi...I can complete this in a day and send out a high quality well presented output. P.S.  The dat...more245 Jobs 156 Reviews $30 in 1 Day
 1 Jobs 0 Reviews $50 in 32 Hours

I can use SPSS to complete the work. I will work within your timeline. Please award me. Thanks and r...more4 Jobs 1 Reviews $50 in 1 Day