#### Question Details

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.

1.

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

obtained:

DEPENDENT VARIABLE:

OBSERVATIONS: VARIABLE

INTERCEPT

X Y

18 RSQUARE

0.3066 FRATIO

7.076 PVALUE ON F

0.0171 PARAMETER

ESTIMATE

15.48

21.36 STANDARD

ERROR

5.09

8.03 TRATIO

3.04

2.66 PVALUE

0.0008

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?

A. 186.42

B. 165.69

C. 186.42

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

and are

D1 , D2

D3

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.

2.

3.

4.

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.

**Solution details:**

Answered

QUALITY

Approved

ANSWER RATING

This question was answered on: * Sep 13, 2020 *

* * Solution~00021147792386.docx (25.37 KB)

##### Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .

#### About this Question

STATUSAnswered

QUALITYApproved

DATE ANSWEREDSep 13, 2020

EXPERTTutor

ANSWER RATING

#### GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

- As a reference for in-depth understanding of the subject.
- As a source of ideas / reasoning for your own research (if properly referenced)
- For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).

#### NEW ASSIGNMENT HELP?

### Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions.
New orders are original solutions *and precise to your writing instruction requirements. Place a New Order using the button below.*

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.