Posted: February 6th, 2021

The exercise involving data in this and subsequent sections were

The exercise involving data in this and subsequent sections were designed to be solved using Excel.
The following estimated regression equation is based on 10 observations was presented.
ŷ = 29.1270 + .5906×1 + .4980×2
Here SST = 6724.125, SSR = 6216.375, Sb1 = .0813, and Sb2 = .0567.

a.  Compute MSR and MSE (to 3 decimals).

MSR
MSE

b.  Compute F and perform the appropriate F test. Use α = .05.
 (to 2 decimals)

c.  Perform a t test for the significance of β1. Use α = .05.
t test statistic =  (to 2 decimals)

What is the p-value?
– Select your answer -less than .01between .01 and .02between .02 and .05between .05 and .10between .10 and .20between .20 and .40greater than .40Item 5

What is your conclusion?
– Select your answer -SignificantNot significantItem 6

d.  Perform a t test for the significance of β2. Use α = .05.
t test statistic =  (to 2 decimals)

What is the p-value? – Select your answer -less than .01between .01 and .02between .02 and .05between .05 and .10between .10 and .20between .20 and .40greater than .40Item 8

What is your conclusion?
– Select your answer -SignificantNot significant

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00