Suppose that you are responsible for making arrangements for a business convention and that you have been charged with choosing a city for the convention that has the least expensive rooms. You have narrowed your choices to Atlanta and Houston. The table containing samples of prices for rooms in Atlanta and Houston is provided in the Excel Online le below. Construct a spreadsheet to answer the following questions. Because considerable historical data on the prices of rooms in both cities are available, the population standard deviations for the prices can be assumed to be $18.95 in Atlanta and $29.8 in Houston. Open spreadsheet Based on the sample data, can you conclude that the mean price of a hotel room in Atlanta is lower than one in Houston? Use a = .05 and null hypothesis is H0 1 \"Atlanta 7 \"Houston 2 0 . zvalue (to 2 decimals) p-value (to 4 decimals) Reject the null hypothesis? Do not reject a M We cannot conclude a M that the mean price of a hotel room in Atlanta is lower than the mean price of a hotel room in Houston. Formulas for Column F Atlanta Houston Atlanta Houston Formulas for Column E 100 65 Mean #N/A #N/A W NI 100 80 80 80 Population Standard Deviation 18.95 29.80 65 90 70 Test Statistic (to 2 decimals) #N/A 140 105 130 60 95 P-value (to 4 decimals) #N/A 125 95 10 115 115 Significance Level (Alpha) 0.05 11 125 105 12 105 140 Hypothesis Decision (Enter "Reject" or "Do not reject") #N/A 13 110 105 14 90 70 15 120 150 16 60 105 17 75 90 18 95 70 19 75 65 20 115 135 21 105 100 22 80 130 23 85 135 24 80 90 25 80 105 26 80 60 27 100 125 28 105 150 29 75 130 30 80 130 31 80 55 32 110 90 33 110 130 34 95 7523 85 135 24 80 90 25 80 105 26 80 60 27 100 125 28 105 150 29 75 130 30 80 130 31 80 55 32 110 90 33 110 130 34 95 75 35 105 60 36 125 120 37 55 38 55 39 65 40 65 41 80 42 43