Question 3 (30 marks) The medical centre tender selection panel have provided you with some estimated figures of the number of emergency appointments, patients per day and the associated administrative costs for the first year of operation. Below is the summary of the year's expected patients. It has been estimated that the clinic's relevant range is 150 to 300 patients per day. Month Emergency appointments Patients per day Administrative costs ($) January 30 350 2780 February 125 1400 March 100 1200 April 250 2000 May 325 2380 June 225 1840 July 275 2040 August 75 820 September 175 1880 October 300 2220 November 150 1660 3220 December 375 Required: 5. Identify the number of emergency appointments, patient load and administrative costs for each month within the relevant range (5 marks) 6. Construct an excel spreadsheet and create a regression analysis to estimate 1. An equation with patient per day, predicting administrative cost within the relevant range (2 marks) 2. An equation with both activities - patients per day and number of emergency appointments, predicting administrative costs within the relevant range (3 marks) 3. Does the inclusion of an additional cost driver improve the model? Explain your