Concur Technologies, Inc., is a large expense-management company located in Redmond, Washington. The Wall Street Journal asked Concur to examine the data from 8.3 million expense reports to provide insights regarding business travel expenses. Their analysis of the data showed that New York was the most expensive city, with an average daily hotel room rate of $198 and an average amount spent on entertainment, including group meals and tickets for shows, sports, and other events, of $172. In comparison, the U.S. averages for these two categories were $89 for the room rate and $99 for entertainment. The table in the Excel Online file below shows the average daily hotel room rate and the amount spent on entertainment for a random sample of 9 of the 25 most visited U.S. cities (The Wall Street Journal, August 18, 2011). Construct a spreadsheet to answer the following questions.

Open spreadsheet

1. Choose the correct diagram for these data with the room rate as the independent variable.

   The correct scatter diagram is

   diagram Adiagram Bdiagram Cdiagram D

   .

   A.
   B.
   C.
   D.

2. What does the scatter diagram developed in part (a) indicate about the relationship between the two variables?

   The scatter diagram indicates a

   negativepositive

   linear relationship between the hotel room rate and the amount spent on entertainment.

3. Develop the least squares estimated regression equation.

   (to 4 decimals)

4. Provide an interpretation for the slope of the estimated regression equation (to 3 decimals).

   The slope of the estimated regression line is approximately . So, for every dollar

   increasedecrease

   in the hotel room rate the amount spent on entertainment increases by $.

5. The average room rate in Chicago is $128, considerably higher than the U.S. average. Predict the entertainment expense per day for Chicago (to whole number).

   $

Chrome File Edit View History Bookmarks Profiles Tab Window Help . Fri Dec 17 12:13 PM ... Mail - Bresema X CO Caurse: 21FM S X MindTap - Conx S Excel Online St X Excel Online St x $ Excel Online St. x Excel Online StX Reserves and X + c O about:blank U * : Excel template Search Option Fic Home Insert Daw , PAJ Layout Formulas nala Review View Help Editing Comments Aria CO 10 B General Merge su S# Conditional Formatting Styles Format Tabic Format As Table F2 - A D E G H I I ] K L M M N 0 o P Q R s T U V w x Parta Use the area beton to draw a scatter diagram. B Hotel Room Rate Entertainment $1 (S) 150 159 92 105 8! 100 113 141 14 191 103 122 12 136 16B 87 140 91 98 City Boelon 3 Denver 4 Nashville 5 New Orleans 6 Phoenix 7 San Diego San Francisco 9 San Jose 10 Tampa 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Pata Formula NA Son Intercept PINIA Parte. Room Rate in Chicago 129 Entertainment Expense for Chicago #NA 28 29 30 31 32 33 35 36 = Data + Waiting for excel.officeapps.live.com... Give Feedback to Microsoft 100% + DEC 17 A YA PRO OP