HLT 362V Module 5 Correlation Regression and Chi Square Excel Worksheet
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?