In: Statistics and Probability
C -- Given the following ANOVA table:
Source |
DF |
SS |
MS |
F |
|||||||||||
Regression |
1 |
1,200.0 |
1,200.00 |
24.00 |
|||||||||||
Error |
12 |
600.0 |
50.00 |
||||||||||||
Total |
13 |
1,800.0 |
|||||||||||||
D -- A consumer buying cooperative tested the effective heating area of 20 different electric space heaters with different wattages. Here are the results.
Heater |
Wattage |
Area |
||
1 |
1,000 |
290 |
||
2 |
750 |
292 |
||
3 |
1,500 |
148 |
||
4 |
1,250 |
246 |
||
5 |
1,250 |
203 |
||
6 |
750 |
85 |
||
7 |
1,250 |
237 |
||
8 |
1,000 |
139 |
||
9 |
1,500 |
64 |
||
10 |
1,000 |
171 |
||
11 |
1,750 |
163 |
||
12 |
1,250 |
175 |
||
13 |
750 |
264 |
||
14 |
1,500 |
50 |
||
15 |
1,750 |
163 |
||
16 |
1,500 |
177 |
||
17 |
1,250 |
118 |
||
18 |
1,750 |
122 |
||
19 |
1,000 |
144 |
||
20 |
1,500 |
103 |
||
H0: ρ ≤ 0; H1: ρ > 0 Reject H0 if t > 2.101
C.
a) the coefficient of determination R2 = SSRegression/SStotal = 1200/1800 = 0.667
b) correlation coefficient = sqrt( R2) = 0.82 ( given it is a direct relationship)
c) standard error of estimate = Sqrt(SSE/N-2) = Sqrt(600/12) = 7.071
D) Excel results
a) Correlation coefficient = -0.4294, there is an indirect relationship .
b) H0: ρ ≤ 0; H1: ρ > 0 Reject H0 if t > 2.101
test statistic t = = -2.015
Fail to reject null hypothesis and conclude that there is no significant evidence that correlation coefficient is greater than zero.
c)
Regression Statistics | |
Multiple R | 0.42935 |
R Square | 0.184341 |
Adjusted R Square | 0.139027 |
Standard Error | 65.27225 |
Observations | 20 |
ANOVA | |||||
df | SS | MS | F | Significance F | |
Regression | 1 | 17331.79 | 17331.79 | 4.068049 | 0.058869 |
Residual | 18 | 76688.41 | 4260.467 | ||
Total | 19 | 94020.2 |
Coefficients | Standard Error | t Stat | P-value | |
Intercept | 283.5205 | 59.24965 | 4.785184 | 0.000148 |
Wattage | -0.09174 | 0.045484 | -2.01694 | 0.058869 |
equation is
Heating Area = 283.521 - 0.092* Wattage
d) RESIDUAL OUTPUT
Observation | Predicted Area | Residuals |
1 | 191.7815 | 98.21851 |
2 | 214.7162 | 77.28376 |
3 | 145.912 | 2.088012 |
4 | 168.8467 | 77.15326 |
5 | 168.8467 | 34.15326 |
6 | 214.7162 | -129.716 |
7 | 168.8467 | 68.15326 |
8 | 191.7815 | -52.7815 |
9 | 145.912 | -81.912 |
10 | 191.7815 | -20.7815 |
11 | 122.9772 | 40.02276 |
12 | 168.8467 | 6.153263 |
13 | 214.7162 | 49.28376 |
14 | 145.912 | -95.912 |
15 | 122.9772 | 40.02276 |
16 | 145.912 | 31.08801 |
17 | 168.8467 | -50.8467 |
18 | 122.9772 | -0.97724 |
19 | 191.7815 | -47.7815 |
20 | 145.912 | -42.912 |
based on the residuals the best buy is heater 18 with 1750 watts because its residual is close to zero.