**ALL I NEED IS THE DATA ANALYSIS RAN** Just to double check my work. I can answ
ID: 2930917 • Letter: #
Question
**ALL I NEED IS THE DATA ANALYSIS RAN**
Just to double check my work. I can answer other questions
Lab
3. (7 points) A recent 10-year study conducted by a research team at the Great Falls Medical School was conducted to assess how age, systolic blood pressure, and smoking affect or relate to the risk of strokes. Assume that the following data are from a portion of this study and data saved as Stroke on Blackboard. Define a dummy variable with 1 indicating a smoker and 0 indicating a nonsmoker. Using Excel Data Analysis (Analysis ToolPak),
(a) (3 points) Develop an estimated multiple regression equation that relates risk of stroke to the person’s age, systolic blood pressure, and whether the person is a smoker.
(b) (2 points) Is smoking a significant factor in the risk of a stroke? Use 0.05 level of significant?
(c) (2 points) What is the multiple coefficient of determination for this model? Interpret this value.
Please submit you’re your Excel output:
00 es es 2359996577 5730916210 235769505 5239111 s565798 g 77869668081077026029 56585757877767686865 2436818175265856 1215251331231413 683 433Explanation / Answer
a)
Stroke=-91.759498+1.0767*Age+0.25*BP+8.74*Smoker
b)
p-value is 0.01 which is less than 0.05 and hence it is a significant factor
c)
It is 0.8735 which means 87.35% of the variation in dependent variable is accounted for by the independent variable.
SUMMARY OUTPUT Regression Statistics Multiple R 0.934605168 R Square 0.87348682 Adjusted R Square 0.849765599 Standard Error 5.756574565 Observations 20 ANOVA df SS MS F Significance F Regression 3 3660.739588 1220.246529 36.82301223 2.06404E-07 Residual 16 530.2104116 33.13815073 Total 19 4190.95 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept -91.75949844 15.22276009 -6.027783261 1.75755E-05 -124.0303082 -59.48868866 Age 1.076741057 0.165963611 6.48781412 7.4873E-06 0.724913919 1.428568194 Blood Pressure 0.251813473 0.045225519 5.567951023 4.24366E-05 0.155939656 0.347687289 Smoker 8.739871056 3.000815432 2.912498704 0.010173553 2.378426519 15.10131559Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.