Help !!! Please !!

Video 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.34 in Atlanta and $28.15 in Houston. 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 : /Atlanta - /Houston 2 0. z-value * (to 2 decimals) p-value 0 (to 4 decimals) Reject the null hypothesis? |Do not reject We cannot conclude v ( that the mean price of a hotel room in Atlanta is lower than the mean price of a hotel room in Houston. Check My Work Reset ProblemFile Home Insert Draw Page Layout Formulas Data Review View Help Arial 10 ABID Av Ev a Merge General $ . 00 -20 Conditional Formatting E2 X V fx A B C D E G H K M N O Atlanta Houston Atlanta Houston 2 105 115 125 110 70 95 Population Standard Deviation 19.34 28.15 60 85 125 125 0 100 125 100 145 90 120 120 110 Significance Level (alpha) 0.05 11 100 125 12 100 100 13 110 55 14 80 85 60 145 16 85 140 65 80 18 85 125 19 105 145 20 115 80 21 95 125 22 110 100 23 125 115 24 115 140 25 85 150 26 120 90 27 90 60 28 125 80 29 115 55 30 95 105 31 80 55 32 80 80 33 80 65 34 120 115 35 80 70 36 90 95 37 95 38 115 39 140 40 80 41 135 4