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.
Categories: