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

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

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
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman