To do regression analysis in Excel first goto data menu and then
DataAnalysis under which you have to select regression.
Now select dependent variable in Y and independent in X.
The dependent variable is hours of sleep and independent
variable is age.
|
Regression Statistics |
|
Multiple R |
0.677634 |
| R
Square |
0.459188 |
|
Adjusted R Square |
0.381929 |
|
Standard Error |
0.580535 |
|
Observations |
9 |
|
ANOVA |
|
|
|
|
|
|
|
df |
SS |
MS |
F |
Significance F |
|
Regression |
1 |
2.00308 |
2.00308 |
5.943499 |
0.044895 |
|
Residual |
7 |
2.359142 |
0.33702 |
|
|
|
Total |
8 |
4.362222 |
|
|
|
|
|
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 95% |
Upper 95% |
|
Intercept |
16.13266 |
0.342254 |
47.13647 |
5.06E-10 |
15.32336 |
16.94197 |
| Age |
-4.65712 |
1.910278 |
-2.43793 |
0.044895 |
-9.17421 |
-0.14003 |
the p-value in ANOVA table is less than 0.05 hence the model is
significant.
The regression equation is Hours of sleep = 16.1 -
4.7*Age.
