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 $20.82 in Atlanta and $28.02 in Houston. Atlanta Houston 90 95 60 100 95 90 100 115 120 90 115 100 125 55 75 85 70 90 70 95 70 65 120 70 90 75 115 85 100 70 95 145 70 85 65 120 60 135 75 130 125 90 85 60 80 125 65 85 95 65 120 150 90 70 80 150 100 130 110 115 100 70 100 85 90 130 125 140 125 140 110 100 120 85 150 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=0.05 and null hypothesis is Ho u(Atlanta)-u(Houston) >=0 z-value (to 2 decimals) p-value (to 4 decimals) Reject the null hypothesis? ______ We ________ that the mean price of a hotel room in Atlanta is lower than the mean price of a hotel room in Houston.
10.1 con:
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 $20.82 in Atlanta and $28.02 in Houston.
Atlanta | Houston |
90 | 95 |
60 | 100 |
95 | 90 |
100 | 115 |
120 | 90 |
115 | 100 |
125 | 55 |
75 | 85 |
70 | 90 |
70 | 95 |
70 | 65 |
120 | 70 |
90 | 75 |
115 | 85 |
100 | 70 |
95 | 145 |
70 | 85 |
65 | 120 |
60 | 135 |
75 | 130 |
125 | 90 |
85 | 60 |
80 | 125 |
65 | 85 |
95 | 65 |
120 | 150 |
90 | 70 |
80 | 150 |
100 | 130 |
110 | 115 |
100 | 70 |
100 | 85 |
90 | 130 |
125 | 140 |
125 | 140 |
110 | |
100 | |
120 | |
85 | |
150 |
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=0.05 and null hypothesis is Ho u(Atlanta)-u(Houston) >=0
z-value | (to 2 decimals) |
p-value | (to 4 decimals) |
Reject the null hypothesis? ______
We ________ that the mean price of a hotel room in Atlanta is lower than the mean price of a hotel room in Houston.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 5 images