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.
Is this your assignment or some part of it?
We can do it for you! Click to Order!
