Question

Refer to the data in Exercise 3–8 for Brentline Hospital.
In exercise
Required:
1. Using Microsoft Excel, prepare a scattergram using the data from Exercise 3–8. Plot cost on the vertical axis and activity on the horizontal axis. Use the “add trendline” feature of Microsoft Excel to fit a line through the points on your scattergram.
2. Scrutinize the points on your graph, and explain why the high–low method would or would not yield an accurate cost formula in this situation.


$1.99
Sales0
Views52
Comments0
  • CreatedJuly 08, 2015
  • Files Included
Post your question
5000