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 get more info 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 HLT 362V Module 5 Correlation Regression and Chi Square, HLT362VModule5CorrelationRegressionandChiSquare, HLT 362V Module HLT362VModule5CorrelationRegressionandChiSquare 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 HLT362VGCU 362V Module 5, HLT362VModule5, HLT 362V Grand Canyon, HLT362VGrandCanyon, HLT 362V GCU, HLT362VGCU, HLT 362V, HLT362V