Following is an incomplete portion of Excel output for regression analysis relat
ID: 3176632 • Letter: F
Question
Following is an incomplete portion of Excel output for regression analysis relating y = maintenance expense (dollars per month) to x = usage (hours per week) of a particular brand of computer terminal:
Anova
df
SS
MS
F
Regression
1
1575.76
Residual
349.14
Total
9
1924.90
Coefficient
Standard Error
t Stat
Intercept
6.1092
0.9361
Usage
0.8951
0.1490
1. What is the standard error (standard deviation) of the estimate of ?
2. What is the margin of error in the 99% confidence interval for the slope 1 of the regression model y = 0 + 1x + ?
3. If you conduct the F test whether x and y are related, then the value of the test statistic is:
4. If you conduct the t test whether x and y are related, then the value of the test statistic is:
5. If you conduct the t test (or F test) whether x and y are related, then the p-value of this test is:
Anova
df
SS
MS
F
Regression
1
1575.76
Residual
349.14
Total
9
1924.90
Coefficient
Standard Error
t Stat
Intercept
6.1092
0.9361
Usage
0.8951
0.1490
Explanation / Answer
Result:
Sqrt(MSE) = Sqrt(43.6425) =6.6062
Df=8, t value =3.355
Margin of error = t*se = 3.355*0.149 =0.499895
3. If you conduct the F test whether x and y are related, then the value of the test statistic is:
F=36.1061
4. If you conduct the t test whether x and y are related, then the value of the test statistic is:
t=6.0074
5. If you conduct the t test (or F test) whether x and y are related, then the p-value of this test is:
P=0.0003
Anova
df
SS
MS
F
Regression
1
1575.76
1575.76
36.1061
Residual
8
349.14
43.6425
Total
9
1924.9
Coefficient
Standard Error
t Stat
Intercept
6.1092
0.9361
Usage
0.8951
0.149
6.0074
Anova
df
SS
MS
F
Regression
1
1575.76
1575.76
36.1061
Residual
8
349.14
43.6425
Total
9
1924.9
Coefficient
Standard Error
t Stat
Intercept
6.1092
0.9361
Usage
0.8951
0.149
6.0074