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.
