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