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

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

Use the Excel Analysis ToolPak to find the linear correlation coefficient for the systolic and diastolic measurements.
Powered by