E2 fx C D E F G H A B Atlanta Houston Atlanta Houston Formulas for Column E Formulas for Column F #N/A 70 Mean #N/A WN 65 80 60 115 Population Standard Deviation 21.16 31.30 95 135 60 145 Test Statistic (to 2 decimals) #N/A 95 60 115 P-value (to 4 decimals) #N/A 115 60 75 10 120 85 Significance Level (Alpha) 0.05 110 145 #N/A 115 125 Hypothesis Decision (Enter "Reject" or "Do not reject") w 120 110 14 120 115 120 90 16 120 70 17 75 140 18 80 70 19 115 65 20 70 130 21 85 60 22 85 150 23 70 90 24 75 115 25 80 105 26 85 60 27 65 90 28 95 70 29 85 60 30 65 60 31 80 65 32 110 55 33 115 135 34 100 65 35 95 135 36 60 125 37 125 38 130 39 100 40 140 41 135