Question

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.94 in Atlanta and $26.66 in Houston.

Atlanta	Houston
95	90
95	125
120	85
120	75
120	140
70	105
100	120
110	140
80	110
115	70
125	140
105	75
115	150
115	80
85	135
60	105
100	75
70	115
105	85
95	125
70	150
80	140
75	105
95	115
100	150
90	85
100	90
100	130
70	120
125	80
75	90
95	105
60	60
110	95
80	70
	130
	125
	90
	65
	130

	Atlanta	Houston		Formulas for Column E	Formulas for Column F
Mean				#N/A	#N/A
Population Standard Deviation	18.94	26.66
Test Statistic (to 2 decimals)				#N/A
P-value (to 4 decimals)				#N/A
Significance Level (Alpha)	0.05
Hypothesis Decision (Enter "Reject" or "Do not reject")				#N/A

Answer 1