5. Suppose you are responsible for making arrangements for a business convention. Because of budget cuts, you have been charged with choosing a city for the convention that has the least expensive hotel rooms. You have narrowed your choices to Atalanta and Houston. The file named Exam Hotel contains samples of prices for rooms in Atlanta and Houston. Test whether the room price of a hotel room in Atlanta is the same as the room price in Houston. Provide the p value to two decimal places.

Answer: _____

Excel e Edit View Insert Format Tools Data Window Help 1+ 4 9 8 Mon Apr 25 3:38 PM AutoSave O OFF n A ? C ... Hotel Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Times New Roman 12 AA ab Wrap Text v General 2 Paste IUV A Merge & Center $ ~ % -0o Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data A1 X V fx Atlanta B C D F G H M N P Q R S U W X Z AA AB AC AD AE 1 Atlanta Houston 85 125 A W N 65 110 00 105 20 120 15 85 125 115 65 65 90 60 115 95 70 105 80 115 75 100 110 120 130 135 120 90 115 Data Sheet2 Sheet3 + Ready 85% 39,073 APR 25 Ai Ps X