SYSTOLIC AND DIASTOLIC BLOOD PRESSURE OF FEMALES

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?

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"