A partial computer output from a regression analysis using Excel’s Regression tool follows.

 

 

a. Based on the given information above, complete the missing values (1) to (11). [5.5 pts]

Hint: It may not be necessary to follow the order to complete the table.

 

(1)   Write down the formula or concept calculating cell (1) and complete the calculation:

__________________________________________________________________________________________________________________________________________________________________________

(2)   Write down the formula or concept calculating cell (2) and complete the calculation:

__________________________________________________________________________________________________________________________________________________________________________

(3)   Write down the formula or concept calculating cell (3) and complete the calculation:

__________________________________________________________________________________________________________________________________________________________________________

 

(4)   Write down the formula or concept calculating cell (4) and complete the calculation:

__________________________________________________________________________________________________________________________________________________________________________

(5)   Write down the formula or concept calculating cell (5) and complete the calculation:

__________________________________________________________________________________________________________________________________________________________________________

(6)   Write down the formula or concept calculating cell (6) and complete the calculation:

__________________________________________________________________________________________________________________________________________________________________________

(7)   Write down the formula or concept calculating cell (7) and complete the calculation:

__________________________________________________________________________________________________________________________________________________________________________

(8)   Write down the formula or concept calculating cell (8) and complete the calculation:

__________________________________________________________________________________________________________________________________________________________________________

(9)   Write down the formula or concept calculating cell (9) and complete the calculation:

__________________________________________________________________________________________________________________________________________________________________________

(10)  Write down the formula or concept calculating cell (10) and complete the calculation:

__________________________________________________________________________________________________________________________________________________________________________

(11)  Write down the formula or concept calculating cell (11) and complete the calculation:

__________________________________________________________________________________________________________________________________________________________________________

 

 

b. Use α = .05. Test for overall significance.

(1) Formulate the null and alternative hypotheses for this test (fill in the blanks below).

H₀ = ____________

H_a = ____________

(2) What is the p-value for the overall significance test? (If you use Excel, provide the function you use)

_______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

(3) Use α = 0.05.  Do you reject or not reject H₀? What is your conclusion?

(3.1) Write down the rejection rule: ________________________________________________________

(3.2) Write down your decision: __________________________________________________________

(3.3) Interpret your result: _______________________________________________________________

_______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

c. Use α = .05. Test for individual significance.

(1) Formulate the null and alternative hypotheses for this test (fill in the blanks below).

H₀ = ____________

H_a = ____________

(2) What is the p-value of the test? (If you use Excel, provide the function you use)

_____________________________________________________________________________________

_______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

(3) Use α = 0.05.  Do you reject or not reject H₀? What is your conclusion?

(3.1) Write down the rejection rule: ________________________________________________________

(3.2) Write down your decision: __________________________________________________________

(3.3) Interpret your result: _______________________________________________________________

_______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

d. Based on the results in part (c), will you include both variables x₁ and x₂ in the regression model? Why or why not?

_______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

_____________________________________________________________________________________

 

 

 

AccountingQueen

(3)

Status NEW Posted 13 Aug 2017 05:08 PM My Price 10.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l

Not Rated(0)

• Buy Answer