a) Scatter Plot
Construct scatter plot by selecting room rate and entertainment values and going on Insert tab in the following way:
Right click on any point, select Add Trendline, choose Linear and tick Display Equation on chart.
c) y = 1.0625x + 14.215
Entertainment = 1.0625*Hotel Room Rate + 14.215
Slope = 1.0625
Intercept = 14.215
d) The slope of the estimated regression line is aproxiimately 1.0625. So, for every dollar increase in the hotel room rate the amount spent on entertainment increases by $ 1.0625.
e) Room rate in Chicago = 128
Entertainment Expense for Chicago = 1.0625*Hotel Room Rate + 14.215
= 1.0625*128 + 14.215
= $150.215
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...
t htlps/ing cengage.com/static/nb Ai/evoindexhtmesBN 978 1337115 377d 426555 922nbid 1056064snapshotld 105 90% in DTAP Q Search des courseG xtured Activity Concur Technologes, In is a large expense-management company located in regarding business travel expenses. Ther analysis of the data showed that New group meals and bokets for shows, sports, and other events, of $172.t below shows the average daly hotel room rate and the amount spent on answer the following questons Redmond, washington. The Wall Street ounal asked Conur to...
4. Perform a SWOT analysis for Fitbit. Based on your assessment of these, what are some strategic options for Fitbit going forward? 5. Analyze the company’s financial performance. Do trends suggest that Fitbit’s strategy is working? 6.What recommendations would you make to Fitbit management to address the most important strategic issues facing the company? Fitbit, Inc., in 2017: Can Revive Its Strategy and It Reverse Mounting Losses? connect ROCHELLE R. BRUNSON Baylor University MARLENE M. REED Baylor University in the...