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

HLT362V

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?

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

HLT362V

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?

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

HLT362V

SYSTOLIC AND DIASTOLIC BLOOD PRESSURE OF FEMALES

The following table represents systolic and diastolic blood pressure measurements of 40 females.

A) Use HLT362VModule5CorrelationRegressionandChiSquare 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 HLT362VGrandCanyon systolic pressure to predict the diastolic HLT362VModule5CorrelationRegressionandChiSquare pressure.

C) What is the best predicted HLT 362V Module 5 Correlation Regression and Chi Square, HLT362VModule5CorrelationRegressionandChiSquare, HLT 362V Module 5, HLT362VModule5, HLT 362V Grand Canyon, HLT362VGrandCanyon, HLT 362V GCU, HLT362VGCU, HLT 362V, HLT362Vvalue for diastolic pressure given that a woman has a systolic level of 100?

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

Tags: HLT 362V Module 5 Correlation Regression and Chi Square, HLT362VModule5CorrelationRegressionandChiSquare, HLT 362V Module 5, HLT362VModule5, HLT 362V Grand Canyon, HLT362VGrandCanyon, HLT 362V GCU, HLT362VGCU, HLT 362V, HLT362V

## Comments on “HLT 362V Module 5 Correlation Regression and Chi Square”