10.1 Excel Activity 2a - Hypothesis Test for the Difference of Two Means (Structured)

Please see attachments for data

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 $19.48 in Atlanta and $29.96 in Houston.

Duesllon 1 Suppose that you are responsible for making arrangements for a busine;s 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 Dnline 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 $19.48 in Atlanta and $29.96 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 He iAmh pm 2 0. zeualue _0 (m 2 decimals) p-value -0 (to 4 decimals) Rejec'tthe null hypothesis? Do not reject v Q We @ that the mean price of a hotel room in Atlanta is lower than the mean price of a hotel room in Houston. Atlanta Houston Atlanta Houston Formulas for Column E Formulas for Column F 115 145 Mean #N/A #N/A 95 140 80 75 Population Standard Deviation 19.48 29.96 120 65 90 120 Test Statistic (to 2 decimals) #N/A 85 130 80 65 P-value (to 4 decimals) #N/A LD CO 60 60 10 105 130 Significance Level (Alpha) 0.05 11 70 65 12 70 80 Hypothesis Decision (Enter "Reject" or "Do not reject") #N/A 13 60 65 14 65 90 15 120 65 16 85 145 17 105 80 18 85 130 19 110 105 20 105 80 21 115 135 22 115 80 23 75 85 24 80 110 25 85 95 26 120 105 27 115 125 28 120 130 29 75 55 30 75 125 31 80 90 32 90 150 33 110 90 34 125 140 35 100 105 36 100 65 37 85 38 135 39 60 40 85 41 140