Question 2 5 pts Using the data Quiz data - blood pressure.xlsx , conduct a hypothesis test to see if there is evidence

[answerhappygod]

Question 2 5 Pts Using The Data Quiz Data Blood Pressure Xlsx Conduct A Hypothesis Test To See If There Is Evidence 1 (60.17 KiB) Viewed 31 times

Question 2 5 pts Using the data Quiz data - blood pressure.xlsx , conduct a hypothesis test to see if there is evidence the mean blood pressure for males is significantly higher than the mean blood pressure for females. You can use the function =T.TEST() in Excel to get the P-value. The sample mean for males is [ Select ] The sample mean for females is [ Select] This is a [ Select] Alternative Hypothesis The P-value is [ Select] and therefore we conclude that we [ Select]
Sex (Male = 1, Female = 2) SBP 136 119 145 N N N High 1 0 1 2 2 2 138 1 N N 162 2 1 141 160 127 148 2 2 2 2 1 1 0 1 151 1 1 142 1 1 137 136 1 1 1 132 1 1 1 1 1 1 1 140 131 1 115 1 0 1 143 142 127 1 1 1 2 2 0 108 0 0 2 1 122 156 105 146 N N N N N N N 0 1 172 2 1 0 117 0 121 112 1 1 2 0 157 143 P PO 1 1 1
2 0 1 1 116 159 130 134 176 N 1 1 1 1 165 2 1 2 2 1 1 142 158 124 133 114 1 1 0 1 N 1 N N 117 2 2 1 1 2 166 108 110 200 119 O O O O 1 N N 2 1 0 158 1 1 1 2 2 0 127 117 2 0 157 1 1 N 2 1 2 1 1 O O 1 1 N 1 200 121 128 135 135 143 125 120 131 133 146 1 1 1 0 O 0 1 1 1 1 2 1 1
0 N N N 2 0 0 127 120 117 143 145 121 180 1 1 1 1 2 1 1 0 1 158 1 1 1 1 143 140 1 1 142 1 1 1 1 124 131 0 1 199 1 1 1 1 1 N 140 150 176 134 162 1 1 1 2 2 2 1 1 156 1 1 134 1 1 N N N 2 2 2 1 2 0 0 O O 2 1 0 1 121 125 144 125 147 125 138 179 118 146 132 2 0 1 1 1 1 1 1 0 1 1 1 1 N
0 N N N 2 . 1 2 1 1 1 1 1 2 1 1 N 125 146 136 155 148 158 154 144 120 127 113 139 168 130 138 131 1 1 0 0 1 2 0 N 1 1 1 2 1 1 2 2 1 1 ANNN 2 0 1 1 0 1 1 N 105 142 129 175 118 152 132 136 136 1 0 1 2 1 1 1 1 1 1 1 131 1 120 127 1 2 1 0 0 150 1 1 1 1 124 120 1 0 0 1 150 1 1
2 0 1 0 2 1 1 2 1 1 1 2 2 N 1 1 0 0 1 0 1 1 0 0 0 1 1 1 0 0 1 1 0 N N 1 2 125 127 172 148 129 120 172 127 154 147 129 108 129 162 131 146 119 111 136 138 117 121 132 128 122 152 111 121 154 176 N N 2 2 2 1 1 1 N 2 N 2 0 1 0 0 1 0 0 1 2 2 1 1 1 2 115 124 NAN 1 1 0 0 2
2 1 153 115 1 0 N 0 1 1 0 127 132 128 155 154 118 158 150 2 1 1 1 1 0 1 1 1 1 140 1 1 1 1 2 144 1 2 0 117 115 N 0 112 1 0 141 1 1 0 114 127 124 124 2 1 1 0 0 2 0 120 1 0 165 NA N 2 1 135 1 2 0 1 1 0 N 1 0 103 145 125 118 180 130 148 135 140 2 2 1 1 1 1 1 1 1 1 1 1 1