The data below have been taken from the cost records of the Halifax General Hospital. The data relate to the costs 0fadmitting patients at various levels of patient activity: Month Number of Patients Admitting Admitted Department Costs May ..................................................................... 3,600 3 29,400 June .................................................................... 3,800 3 23,700 July ...................................................................... 2,900 3 27,400 August ................................................................ 3,200 5 28,000 September .......................................................... 3,300 5 28,600 October ............................................................... 2,600 3 26,200 November ........................................................... 2,200 5 25,600 December ........................................................... 3,500 5 29,300 Requirements: 1. Using the high-low method, and based upon the data collected: {a} estimate the variable cost per admission. {b} estimate the fixed costs for admission. {c} estimate the cost formula for admissions [cost formula is in the format on : a + bx]. Using the cost formula you derived above, what admission costs would you expect to be incurred during a month in which there are 2,750 hospital admissions? Prepare a scattergraph plot using the data. Plot cost on the vertical axis and activity on the horizontal axis. Add the visual best-fit "trendline" to fit a line through the points on your scattergraph. Also add the "high-low trendline" so that you can compare the two trendlines and the data set points in Requirement 4. (Hint: You can either use software, such as Microsoft Excel, or Google Sheets, or draw the scattergraph plot on your computer using a drawing program (Microsoft Paint, or similar} or you can draw and plot the points on a piece of paper by hand and take a picture and insert the picture into your document.) Scrutinize the points on your scattergraph, and explain why the high-low method would or would not yield an accurate cost formula in this situation