Given data is as below-
| Xi |
Yi |
| 2 |
50 |
| 15 |
48 |
| 7 |
58 |
| 22 |
11 |
| 19 |
23 |
We need to develop a regression model to predict the value of
y
So, Y = f(X)
The regression output is as follows-
| SUMMARY
OUTPUT |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Regression Statistics |
|
|
|
|
|
|
|
| Multiple R |
0.847691176 |
|
|
|
|
|
|
|
| R Square |
0.71858033 |
|
|
|
|
|
|
|
| Adjusted R Square |
0.624773773 |
|
|
|
|
|
|
|
| Standard Error |
12.24348307 |
|
|
|
|
|
|
|
| Observations |
5 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| ANOVA |
|
|
|
|
|
|
|
|
|
df |
SS |
MS |
F |
Significance F |
|
|
|
| Regression |
1 |
1148.291367 |
1148.291367 |
7.660235644 |
0.069701474 |
|
|
|
| Residual |
3 |
449.7086331 |
149.9028777 |
|
|
|
|
|
| Total |
4 |
1598 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 95% |
Upper 95% |
Lower 95.0% |
Upper 95.0% |
| Intercept |
64.42086331 |
11.00493453 |
5.853816136 |
0.009938266 |
29.39825009 |
99.44347653 |
29.39825009 |
99.44347653 |
| X Variable 1 |
-2.032374101 |
0.734315317 |
-2.767713071 |
0.069701474 |
-4.369293168 |
0.304544966 |
-4.369293168 |
0.304544966 |
The regression equation is as follows-
Y = 64.42 -
2.03*X
Let me know if you need anything else, if not please don't
forget to like the answer :)
