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 1. What is the correlation coefficient between Risk of Stroke and Age? How do you find it?   2. Use Excel’s Data Analysis tool to conduct a multiple regression, using Risk of Stroke as the dependent variable, and all the rest of variables as independent variables. Choose confidence level at 99%. 3. Based on the multiple regression analysis output, write the estimated regression equation.

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
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

1. What is the correlation coefficient between Risk of Stroke and Age? How do you find it?  

2. Use Excel’s Data Analysis tool to conduct a multiple regression, using Risk of Stroke as the dependent variable, and all the rest of variables as independent variables. Choose confidence level at 99%.

3. Based on the multiple regression analysis output, write the estimated regression equation.  

Expert Solution
steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Similar questions
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