Atlanta Houston 110 70 Atlanta Houston 100 150 65 115 Population Standard Deviation 100 18.76 125 29.58 115 125 70 55 90 130 110 75 125 140 Significance Level (alpha) 65 60 0.05 100 100 85 100 90 120 60 125 85 70 95 85 80 95 115 85 85 130 70 150 115 100 80 55 105 85 80 75 90 115 90 80 105 80 90 150 60 70 120 110 95 150 80 95 125 125 115 110 70 55 115 130 150 130 85Suppose 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 file 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 $1B.76 in Atlanta and $29.58 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 Hy : patlanta UHouston = 0. z-value 9 (to 2 decimals) p-value 0 (to 4 decimals) Reject the null hypothesis? Reject e We can conclude & @ that the mean price of a hotel room in Atlanta is lower than the mean price of a hotel room in Houston