Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Name: Date: Topic Five: Correlation/Regression and Chi Square Excel Worksheet Directions: Answer all problems and submit to instructor at the end of Module 5 SYSTOLIC

Name: Date: Topic Five: Correlation/Regression and Chi Square Excel Worksheet Directions: Answer all problems and submit to instructor at the end of Module 5 SYSTOLIC AND DIASTOLIC BLOOD PRESSURE OF FEMALES The following table represents systolic and diastolic blood pressure measurements of 40 females. A) Use the Excel Analysis ToolPak to find the linear correlation coefficient for the systolic and diastolic measurements. B) Use the Excel Analysis ToolPak to determine the linear regression equation that uses the systolic pressure to predict the diastolic pressure. C) What is the best predicted value for diastolic pressure given that a woman has a systolic level of 100? SYS 104 99 102 114 94 101 108 104 123 93 89 DIAS 61 64 65 76 58 66 61 41 72 61 56 A: place correlation table here SYS SYS DIAS B: place regression equation table here SUMMARY OUTPUT Regression Statistics Multiple R R Square DIAS 112 107 116 181 98 100 127 107 116 97 155 106 110 105 118 133 113 113 107 95 108 114 104 125 124 92 119 93 106 62 48 62 102 61 53 74 67 71 64 85 59 70 69 82 83 75 66 67 59 72 79 73 73 85 46 81 64 64 Adjusted R Square Standard Error Observations ANOVA df SS MS F Significance F Coefficients Standard Error t Stat P-value Lower 95% Regression Residual Total Intercept SYS Type the regression equation: C: Predicted diastolic pressure Show calculations of predicted diastolic pressure

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

An Introduction to the Mathematics of financial Derivatives

Authors: Salih N. Neftci

2nd Edition

978-0125153928, 9780080478647, 125153929, 978-0123846822

More Books

Students also viewed these Mathematics questions