Answer Happy

Consider the following first dose (COVID vaccine)
recipiency rate of the following New York City zip codes as
according to their respective boroughs:
Zip Code - Borough - First Dose
Recipiency Rate (%)
10004 Manhattan 99
10006 Manhattan 99
11697 Queens 99
10464 Bronx 86
10282 Manhattan 89
11109 Queens 99
10069 Manhattan 99
11363 Queens 94
10007 Manhattan 99
10005 Manhattan 99
10280 Manhattan 84
10044 Manhattan 96
10018 Manhattan 99
10474 Bronx 80
11693 Queens 70
11239 Brooklyn 99
11366 Queens 87
10307 Staten Island 66
10470 Bronx 81
10017 Manhattan 99
11362 Queens 91
10302 Staten Island 89
11428 Queens 96
11415 Queens 85
11004 Queens 83
11360 Queens 91
11436 Queens 85
11426 Queens 84
11694 Queens 71
10037 Manhattan 81
11692 Queens 71
10471 Bronx 89
11411 Queens 74
11356 Queens 99
10038 Manhattan 99
10075 Manhattan 99
10012 Manhattan 89
10310 Staten Island 88
11427 Queens 97
11104 Queens 99
11361 Queens 99
11416 Queens 93
10303 Staten Island 82
11232 Brooklyn 90
10039 Manhattan 77
10036 Manhattan 99
10001 Manhattan 99
10065 Manhattan 99
11414 Queens 72
10013 Manhattan 99
10030 Manhattan 76
10308 Staten Island 72
11102 Queens 99
10014 Manhattan 95
10022 Manhattan 99
11417 Queens 91
11423 Queens 88
11370 Queens 85
11429 Queens 74
11422 Queens 75
10309 Staten Island 74
10010 Manhattan 90
11369 Queens 99
11103 Queens 93
10035 Manhattan 88
11364 Queens 94
11358 Queens 99
11222 Brooklyn 97
11378 Queens 87
11105 Queens 84
11433 Queens 83
11379 Queens 80
11101 Queens 99
11231 Brooklyn 83
11106 Queens 96
11418 Queens 90
10454 Bronx 85
11412 Queens 78
10026 Manhattan 79
11357 Queens 91
10301 Staten Island 85
11421 Queens 94
11367 Queens 80
11217 Brooklyn 87
11374 Queens 93
10304 Staten Island 87
10455 Bronx 84
10034 Manhattan 77
10475 Bronx 77
10305 Staten Island 85
10465 Bronx 74
11413 Queens 73
10019 Manhattan 99
11365 Queens 93
10040 Manhattan 79
11228 Brooklyn 83
11205 Brooklyn 66
10021 Manhattan 89
11224 Brooklyn 71
10451 Bronx 92
10028 Manhattan 88
11420 Queens 88
10459 Bronx 84
11237 Brooklyn 92
11419 Queens 93
10461 Bronx 90
10011 Manhattan 96
10016 Manhattan 99
10306 Staten Island 87
11238 Brooklyn 96
11354 Queens 99
10003 Manhattan 90
11216 Brooklyn 84
10009 Manhattan 91
11225 Brooklyn 78
10024 Manhattan 93
11435 Queens 86
10033 Manhattan 77
10128 Manhattan 94
10460 Bronx 80
10031 Manhattan 80
10473 Bronx 81
11372 Queens 99
11432 Queens 99
10312 Staten Island 76
10023 Manhattan 99
11201 Brooklyn 99
10032 Manhattan 81
10027 Manhattan 84
11213 Brooklyn 70
11210 Brooklyn 67
11434 Queens 77
11691 Queens 63
11209 Brooklyn 86
10472 Bronx 85
11215 Brooklyn 88
10463 Bronx 84
11375 Queens 84
10466 Bronx 74
10469 Bronx 74
11203 Brooklyn 79
10457 Bronx 85
11212 Brooklyn 84
11218 Brooklyn 77
11233 Brooklyn 69
10452 Bronx 87
10462 Bronx 93
10002 Manhattan 99
11204 Brooklyn 74
10468 Bronx 80
11235 Brooklyn 80
10029 Manhattan 86
10453 Bronx 83
11355 Queens 99
11221 Brooklyn 84
11223 Brooklyn 71
10458 Bronx 80
11229 Brooklyn 71
11377 Queens 99
11206 Brooklyn 68
11230 Brooklyn 65
11207 Brooklyn 79
11219 Brooklyn 59
10025 Manhattan 92
11373 Queens 99
10314 Staten Island 77
11214 Brooklyn 84
10456 Bronx 80
11234 Brooklyn 70
11220 Brooklyn 99
11208 Brooklyn 81
11236 Brooklyn 73
11226 Brooklyn 86
11211 Brooklyn 66
10467 Bronx 81
11385 Queens 81
11368 Queens 99
A. Calculate the average first dose recipiency rate for
Brooklyn and the Bronx. What is the point estimate for the
population difference between Brooklyn and the Bronx?
B. What is the standard error of the point estimate
from part A?
C. Following up on questions parts A and B, if you
were to test for the significance of the difference in average
first-dose recipiency rates between the two boroughs, what would
the test statistic be?
D. Is the difference in average first-dose
recipiency rates between Brooklyn and the Bronx significant at the
.05 level? (Choose an answer: Yes/No/Can't determine given
available evidence)