In: Statistics and Probability
Need Linear Regression Analysis done for the following data:
|
Day |
BP Diastolic |
Ate Healthy and Exercised |
|
1 |
85 |
N |
|
2 |
109 |
N |
|
3 |
96 |
N |
|
4 |
92 |
N |
|
5 |
99 |
N |
|
6 |
98 |
N |
|
7 |
102 |
Y |
|
8 |
93 |
N |
|
9 |
90 |
Y |
|
10 |
84 |
N |
|
11 |
90 |
N |
|
12 |
86 |
N |
|
13 |
81 |
N |
|
14 |
77 |
Y |
|
15 |
90 |
Y |
|
16 |
86 |
Y |
|
17 |
83 |
N |
|
18 |
80 |
Y |
|
19 |
78 |
N |
|
20 |
74 |
Y |
|
21 |
72 |
Y |
|
22 |
79 |
Y |
|
23 |
84 |
Y |
|
24 |
91 |
Y |
|
25 |
85 |
Y |
|
26 |
77 |
Y |
|
27 |
78 |
Y |
|
28 |
81 |
N |
|
29 |
88 |
Y |
|
30 |
85 |
Y |
|
31 |
77 |
Y |
|
32 |
74 |
Y |
|
33 |
72 |
Y |
|
34 |
77 |
N |
|
35 |
80 |
Y |
|
36 |
81 |
Y |
|
37 |
76 |
Y |
|
38 |
78 |
Y |
|
39 |
72 |
Y |
|
40 |
73 |
Y |
|
41 |
72 |
Y |
|
42 |
79 |
Y |
|
43 |
80 |
Y |
|
44 |
84 |
Y |
|
45 |
81 |
Y |
|
46 |
78 |
Y |
|
47 |
71 |
Y |
|
48 |
73 |
Y |
|
49 |
76 |
Y |
|
50 |
75 |
Y |
|
51 |
76 |
N |
|
52 |
81 |
Y |
|
53 |
78 |
N |
|
54 |
75 |
Y |
|
55 |
77 |
Y |
|
56 |
76 |
Y |
Let us consider BP Diastolic(Y) is dependent variable and Ate Healthy and Exercised(X) is independent varaible
Ate Healthy and Exercised(X) :
If X = 1, Ate Healthy and Exercised (Yes)
X = 0, Do not ate Healthy and Exercised (No)
| SUMMARY OUTPUT | ||||||||
| Regression Statistics | ||||||||
| Multiple R | 0.44587202 | |||||||
| R Square | 0.198801858 | |||||||
| Adjusted R Square | 0.183964856 | |||||||
| Standard Error | 7.473174191 | |||||||
| Observations | 56 | |||||||
| ANOVA | ||||||||
| df | SS | MS | F | Significance F | ||||
| Regression | 1 | 748.3150452 | 748.3150452 | 13.39905798 | 0.000573317 | |||
| Residual | 54 | 3015.809955 | 55.8483325 | |||||
| Total | 55 | 3764.125 | ||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
| Intercept | 87.41176471 | 1.812510974 | 48.22688854 | 4.43011E-46 | 83.777899 | 91.04563042 | 83.777899 | 91.04563042 |
| Ate Healthy and Exercised(X) | -7.950226244 | 2.171912649 | -3.660472371 | 0.000573317 | -12.30464893 | -3.595803559 | -12.30464893 | -3.595803559 |
BP Diastolic(Y) = 87.4118 - 7.9502 * Ate Healthy and Exercised(X)
R^2 = 0.1988,
19.88% of variation in Y variable is explained by variation in X variable
If X = 1, Ate Healthy and Exercised (Yes)
BP Diastolic(Y) = 87.4118 - 7.9502 * 1 = 79.4616
X = 0, Do not ate Healthy and Exercised (No)
BP Diastolic(Y) = 87.4118 - 7.9502 * 0 = 87.4118