The assignment and data needed are both attached 🙂
Name #1 ______________________________ UBIT #1 _____________________________
MGE 302 Assignment #3- Due Monday, Oct. 17 @ 8:00 AM
Submit your assignment as a single page, showing all work that you would like to be graded on the
answer sheet provided below. Remember, only this answer sheet page should be uploaded.
a. b. c. d. 2.
a.(circle/mark answer A B C D b.(circle/mark answer) A B C D c.(circle/mark answer) A B C D 1 2 3 4 3.
a. b.(circle/mark answer)
c. 5 1. The data for this question can be found in HW3Data.xls on UBLearns.
A sociology graduate student wants to model a city's death rate using the following equation:
Deathrate = a + b(DoctorAvail) + c(HospitalAvail) + d(Income) + e(Population) Using the data in the RawData tab of file HW2Data.xls, estimate a multivariate linear regression
of the model described above.
a. What is the equation of the sample regression line? b. Interpret the p-values for the parameter estimates. Which variables are statistically
significant? Explain how you determined your answer. c. Explain in words the interpretation of the coefficient for annual per capita income. If per
capita income increases by $1,000/year, what happens to city's death rate? d. Estimate the death rate per 1,000 residents for a city that has 85 doctor availability per
100,000 residents, 198 hospital availability per 100,000 residents, an annual per captia
income of $9,000 and a population density of 130 residents per square mile. 2. The linear regression equation, Y = a + bX, was estimated. The following computer printout was
7.076 PVALUE ON F
0.0171 a. Given the above information, the parameter estimate of b indicates
A. X increases by 8.03 units when Y increases by one unit.
B. X decreases by 21.36 units when Y increases by one unit.
C. Y decreases by 2.66 units when X increases by one unit.
D. a 10-unit decrease in X results in a 213.6 unit increase in Y. b. Given the above information, if X equals 20, what is the predicted value of Y?
D. 411.72 c. Given the above information, which of the following statements is correct at the 1% level of
significance? 3. a^ and A. Both B. Neither b^ are statistically significant. a^ nor b^ is statistically significant. C. a^ is statistically significant, but b^ is not. D. b^ is statistically significant, but a^ is not. 3. A forecaster used the regression equation Qt a bt c1 D1 c2 D2 c3 D3
and quarterly sales data for Q1 1993 through Q4 2008 (t = 1, …, 64) for an appliance
manufacturer to obtain the results shown below. Q is quarterly sales, and
D1 , D2
dummy variables for quarters I, II, and III.
DEPENDENT VARIABLE: QT RSQUARE FRATIO PVALUE ON F OBSERVATIONS: 64 0.8768 107.982 0.0001 PARAMETER STANDARD VARIABLE ESTIMATE ERROR TRATIO PVALUE INTERCEPT 30.0 12.8 2.34 0.0224 T 1.5 0.70 2.14 0.0362 D1 10.0 3.0 3.33 0.0015 D2 25.0 7.2 3.47 0.0010 D3 40.0 15.8 2.53 0.0140 a. Is there an upward or downward trend in sales over time? Is this trend statistically
significant? Justify your answer using regression statistics. b. In any given year, which ranking of quarterly sales tends to be true (mark the # of
your choice on the answer sheet): 1.
5. QI > QII > QIII > QIV
QI > QII > QIV > QIII
QII > QIII > QIV > QI
QIII > QII > QI > QIV
QIII > QIV > QII > QI c. Calculate the estimated sales forecasts for the 1 st, 2nd, 3rd and 4th quarter of 2009.