2-14

Atlanta Houston Atlanta 100 65 Mean 93.571428571 110 150 95 120 Population Standard Deviation 17.72 80 100 65 75 Test Statistic (to 2 decimals) -2.42 100 130 75 80 P-value (to 4 decimals) 0.0078 100 75 95 90 Significance Level (Alpha) 0.05 95 135 100 105 reject 70 115 since pvalue is 100 110 60 120 100 85 110 135 105 135 110 130 70 85 90 105 110 135 120 75 115 110 100 55 70 85 100 140 120 75 65 105 115 105 70 55 90 100 75 125 105 145 115 105 75 85 145 120 100 90 135 Hypothesis Decision ( Enter "Reject" or "Do not reject" )

Houston Formulas for Column E Formulas for Column F 105.875 =AVERAGE(A:A) =AVERAGE(B:B) 25.99 =(E2-F2)/SQRT(E4^2/COUNT(A:A)+F4^2/COUNT(B:B)) =NORM.S.DIST(E6,1) =IF(E8<E10,"reject","do not reject") s greater th