HLT 362V Module 5 Correlation Regression and Chi Square Excel Worksheet

HLT 362V Module 5 Correlation Regression and Chi Square Excel WorksheetTo get this tutorial follow this link:http://dodohelp.com/HLT-362V-Grand-Canyon/HLT-362V-Module-5-Correlation-Regression-and-Chi-Square-Excel-WorksheetContact us at:[email protected] AND DIASTOLIC BLOOD PRESSURE OF FEMALESThe 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 diastolicmeasurements.B) Use the Excel Analysis ToolPak to determine the linear regression equation that uses the systolic pressure topredict the diastolic pressure.C) What is the best predicted value for diastolic pressure given that a woman has a systolic level of 100?