Question

Concur Technologies, Inc., is a large expense-management company located in Redmond, Washington. The Wall Street Journal...

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.
Boston 147 159
Denver 98 106
Nashville 87 102
New Orleans 114 142
Phoenix 87 99
San Diego 103 122
San Francisco 134 166
San Jose 90 140
Tampa 85 96
  1. Develop the least squares estimated regression equation.

    Entertainment = ?????? + ?????? Room Rate (to 4 decimals)

  2. 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 increases in the hotel room rate the amount spent on entertainment increases by $???

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Concur Technologies, Inc., is a large expense-management company located in Redmond, Washington. The Wall Street Journal...
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...
In exercise 12, the following data on x = average daily hotel room rate and y...
In exercise 12, the following data on x = average daily hotel room rate and y = amount spent on entertainment (The Wall Street Journal, August 18, 2011) lead to the estimated regression equation ลท = 17.49 + 1.0334x. For these data SSE = 1541.4. Click on the datafile logo to reference the data. Use Table 1 of Appendix B. City Room Rate ($) Entertainment ($) Boston 148 161 Denver 96 105 Nashville 91 101 New Orleans 110 142 Phoenix...
City Hotel Room Rate ($) Entertainment ($) Boston 146 162 Denver 96 105 Nashville 87 102...
City Hotel Room Rate ($) Entertainment ($) Boston 146 162 Denver 96 105 Nashville 87 102 New Orleans 107 140 Phoenix 91 99 San Diego 104 118 San Francisco 140 166 San Jose 93 140 Tampa 81 100 Develop a scatter diagram for these data with the room rate as the independent variable what does the scatter diagram developed in part (a.) indicate about the relationship between the two variables develop the least squares estimated regression equation provide an interpretation...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how the firms resources incompetencies support the given pressures regarding costs and local responsiveness. Describe entry modes have they usually used, and whether they are appropriate for the given strategy. Any key issues in their global strategy? casestudy: Atlanta, June 17, 2014. Sea of Delta employees and their families swarmed between food trucks, amusement park booths, and entertainment venues that were scattered throughout what would...
provide 3-4 paragraphs post (team 2) 1-What are 4 key things you learned about the topic...
provide 3-4 paragraphs post (team 2) 1-What are 4 key things you learned about the topic from reading their paper? 2-How does the topic relate to you and your current or past job? 3-Critique the paper in terms of the organization and quality.1- Employee Stress and how it has an Adverse Effect on a Company This paper explores employee stress and how it has an adverse effect on a company, its employees and the organization. Job stress can have a...