HLT 362V Week 5 Assignment, 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.
- Use the Excel Analysis ToolPak to find the linear correlation coefficient for the systolic and diastolic measurements.
- Use the Excel Analysis ToolPak to determine the linear regression equation that uses the systolic pressure to predict the diastolic pressure.
- What is the best ….value for diastolic pressure …that a woman has a systolic level of 100?.