A 10-year study conducted by the American Heart Association provided data on how age, blood pressure, and smoking related to the risk of strokes. The data file “Statsdata2.xslx” includes a portion of the data from the study. The variable “Risk of Stroke” is measured as the percentage of risk (proportion times 100) that a person will have a stroke over the next 10-year period. Use Excel’s Data Analysis tool to conduct a simple linear regression between Risk of Stroke and Age. Choose confidence level at 95%. Please copy and paste the regression analysis output below. 1. Based on the simple regression analysis output, write the estimated regression equation. 2. If we choose the significance level α=0.05, is Age a significant factor in explaining the risk of a stroke? Explain. 3. What is the coefficient of determination (R-square)? How to interpret R-square? Risk of Stroke (%) Age Pressure Smoker (Yes=1) 12 57 152 0 24 67 163 0 13 58 155 0 56 86 177 1 28 59 196 0 51 76 189 0 18 56 155 1 31 78 120 0 37 80 135 1 15 78 98 0 22 71 152 0 36 70 173 1 15 67 135 1 48 77 209 0 15 60 199 0 36 82 119 1 8 66 166 0 34 80 125 1 3 62 117 0 37 59 207 1
A 10-year study conducted by the American Heart Association provided data on how age, blood pressure, and smoking related to the risk of strokes. The data file “Statsdata2.xslx” includes a portion of the data from the study. The variable “Risk of Stroke” is measured as the percentage of risk (proportion times 100) that a person will have a stroke over the next 10-year period.
Use Excel’s Data Analysis tool to conduct a simple linear regression between Risk of Stroke and Age. Choose confidence level at 95%.
Please copy and paste the
1. Based on the simple regression analysis output, write the estimated regression equation.
2. If we choose the significance level α=0.05, is Age a significant factor in explaining the risk of a stroke? Explain.
3. What is the coefficient of determination (R-square)? How to interpret R-square?
| Risk of Stroke (%) | Age | Pressure | Smoker (Yes=1) |
| 12 | 57 | 152 | 0 |
| 24 | 67 | 163 | 0 |
| 13 | 58 | 155 | 0 |
| 56 | 86 | 177 | 1 |
| 28 | 59 | 196 | 0 |
| 51 | 76 | 189 | 0 |
| 18 | 56 | 155 | 1 |
| 31 | 78 | 120 | 0 |
| 37 | 80 | 135 | 1 |
| 15 | 78 | 98 | 0 |
| 22 | 71 | 152 | 0 |
| 36 | 70 | 173 | 1 |
| 15 | 67 | 135 | 1 |
| 48 | 77 | 209 | 0 |
| 15 | 60 | 199 | 0 |
| 36 | 82 | 119 | 1 |
| 8 | 66 | 166 | 0 |
| 34 | 80 | 125 | 1 |
| 3 | 62 | 117 | 0 |
| 37 | 59 | 207 | 1 |
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 2 images
