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%.Risk of Stroke (%)AgePressureSmoker (Yes=1)1257152024671630135815505686177128591960517618901856155131781200378013511578980227115203670173115671351487720901560199036821191866166034801251362117037592071Interpret the multiple coefficient of determination R-square.Compare the R-square of the simple linear regression and the R-square of the multiple regression, what does the differences in R-squares tell us?What does F-test for significance tell us?

Answered: Image /qna-images/answer/ef47f5e0-2309-407e-af66-54f2c618e386.jpg

Answered: Use Excel’s Data Analysis tool to…

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter4: Equations Of Linear Functions

Section4.6: Regression And Median-fit Lines

Problem 6PPS

See similar textbooks

Related questions

Question

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

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

Interpret the multiple coefficient of determination R-square.
Compare the R-square of the simple linear regression and the R-square of the multiple regression, what does the differences in R-squares tell us?
What does F-test for significance tell us?

Expert Solution