HLT 362 Module 5 Correlation Regression and Chi Square Excel Worksheet | Documents and Forms | Research Papers

HLT 362 Module 5 Correlation Regression and Chi Square Excel Worksheet

HLT 362 Module 5 Correlation Regression and Chi Square Excel Worksheet PLDZ-591 Instant Download Price
In Stock
$ 7.00 USD
Bright Solutions
Buy and Download Description

Directions: Answer all problems and submit to instructor at the end of Module 5

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

SYSTOLIC: 104, 99, 102, 114, 94, 101, 108, 104, 123, 93, 89, 112, 107, 116, 181, 98, 100, 127, 107, 116, 97, 155, 106, 110, 105, 118, 133, 113, 113, 107, 95, 108, 114, 125, 124, 92, 119, 93, 106

Diastolic: 61, 64, 65, 76, 58, 66, 61, 41, 72, 61, 56, 62, 48, 62, 102, 61, 53, 74, 67, 71, 64, 85, 59, 70, 69, 82, 83, 75, 66, 67, 59, 72, 79, 73, 73, 85, 46, 81, 64, 64

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?

Directions: Answer all problems and submit to instructor at the end of Module 5The following table represents systolic and diastolic blood pressure measurements of 40 females:SYSTOLIC: 104, 99, 102, 114, 94, 101, 108, 104, 123, 93, 89, 112, 107, 116,
Recent Reviews Be the first to Review this product!
0 0 0 0 reviews