Answer Happy

123456 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 B2 83 34 B5 36 37 38 39 -40 41 Atlanta Houston 100 95 105 90 65 75 95 125 105 105 115 105 65 100 85 105 125 70 95 70 90 115 105 115 115 80 120 125 65 100 80 105 75 90 120 150 100 65 150 115 125 60 90 80 115 135 75 100 135 65 60 85 70 150 140 60 115 120 110 150 150 145 135 100 75 110 130 95 85 75 75 115 90 105 60 Mean Population Standard Deviation Test Statistic (to 2 decimals) P-value (to 4 decimals) (to 2 decimals) Atlanta z-value p-value .0351 Reject the null hypothesis? We cannot conclude price of a hotel room in Houston. 97 Significance Level (Alpha) Hypothesis Decision (Enter "Reject" or "Do not reject") 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 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 $18.44 in Atlanta and $30.17 in Houston. (to 4 decimals) 18.44 X 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 Ho: HAtlanta - Houston 20. 0.05 Houston [Do not reject that the mean price of a hotel room in Atlanta is lower than the mean 105.4166667 30.17