data
x | y |
14 | 16 |
16 | 36 |
37 | 82 |
20 | 32 |
46 | 76 |
30 | 31 |
33 | 43 |
result of regression in excel
SUMMARY OUTPUT | |||||
Regression Statistics | |||||
Multiple R | 0.844471444 | ||||
R Square | 0.713132019 | ||||
Adjusted R Square | 0.655758423 | ||||
Standard Error | 14.41324376 | ||||
Observations | 7 | ||||
ANOVA | |||||
df | SS | MS | F | Significance F | |
Regression | 1 | 2582.149165 | 2582.149165 | 12.42962035 | 0.01681901 |
Residual | 5 | 1038.707978 | 207.7415956 | ||
Total | 6 | 3620.857143 | |||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | |
Intercept | -4.007500852 | 14.96770779 | -0.267743125 | 0.799590936 | -42.48321862 |
x | 1.755369928 | 0.497897244 | 3.525566671 | 0.01681901 | 0.475484317 |
a)
b0 = -4.01
b1 = 1.76
y^ = -4.01 + 1.76* x
b)
SSE | 1038.7 |
SST | 3620.9 |
SSR | 2582.1 |
MSE | 207.7 |
c)
r^2 = 0.713
he Federal Tr as compared to lmot all U.S. light-rail systems usc electric cars that run...
Almost all U.S. light-rail systems use electric cars that run on tracks built at street level. The Federal Transit Administration claims light-rail is one of the safest modes of travel, with an accident rate of .99 accidents per million passenger miles as compared to 2.29 for buses. The following data show the miles of track and the weekday ridership in thousands of passengers for six light-rail systems. City Miles of Track Ridership (1000s) Cleveland 15 13 Denver 17 33 Portland...