The exercise involving data in this and subsequent sections were designed to be

ID: 3312218 • Letter: T

Question

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. Here SST= 6,694 SSR= 6,188 Sb1= 0.0727 and Sb2= 0.0539

1. Compute MSR and MSE to 3 decimal places.

2. Compute the F statistic to 2 decimal places.

2a. What is the p-value?

3. Compute the t test statistic for the significance of b1(2 decimals)

3a. What is the p-value?

4. Compute the t test statistic for the significance of b2(2 decimals)

4a. What is the p-value?

y = 29.1270 + 0.5906x1 + 0.4980x2

as MS =SS/df

1) MSR =SSR/(k-1) =6188/(3-1)=3094

MSE =(SSE/(N-k)) =(6694-6188)/(10-3)=72.286

2) therefore F statistic =MSR/MSE =42.80

2a) p value for above test statistic and (2,7) degree of freedom =0.0001

3) t test statistic =b1/sb1 =0.5906/0.0727=8.12

3a) pvalue for 7 degree of freedom and above test statistic =0.0001

4) t test statistic =b2/sb2 =0.4980/0.0539=9.24

4a) p value =0.0000

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.