Gow should this be completed in Excel ? Could you please include the Excel Formulas?

Review Home insert Page Layout Formulas Data View D PROTECTED VIEW Be careful-files from the Internet can contain vinnes. Unless you need to edit usater to stay in Protected View Enable ting X Cost Behavior G H M Cost Behavior Performing a regression analysis to predict overhead for a hospital laboratory The manager of the main laboratory facility at Elmhurst Health Center is interested in being able to predict the overhead costs each month for the lab. The manager believes that total overhead varies with the number of lab tests performed but that some costs remain the same each month regardless of the number of lab tests performed. The manager of the main laboratory facility at Elmhurst Health Center collected the following seven months of data. The number of tests performed and the total monthly overhead costs for the lab 4 follow 5 Number of Lab Total 6 Month Tests Laboratory 7 August 3,350 $ 23,500 . September 3,700 $ 27.550 . October 3,650 $ 24,500 90 November 3.450 $ 26,400 11 December 4,200 $ 28,500 12 January 2.500 $ 22,800 February 3,800 5 25,350 TE 15 Use the blue shaded areas on the ENTERANSWERS tab for inputs, Always un cell references and formulas where appropriate to receive full credit. If you 16 apr/parte from the instruction tab you will be marked wrong > Requirements INSTRUCTIONS ENTERANSWERS (hp Data File Home Insert Page Layout Formulas Review View Help PROTECTED VIEW Be carefulFiles from the Internet can contain viruses. Unless you need to edit, it's safer to sta Al 1. Run a regression analysis using data for August through Fel D E G H 11. Run a regression analysis using data for August through February. Determine the 2 a. Rename the regression output tab name "REGRESSION". (Always use cell references and formulas where appropriate to receive full credit. 3 If you copy/paste from the Instruction tab you will be marked wrong.) 4 5 y = 6 7 2. Determine the R-square using the Excel output you obtain. (Always use cell references and formulas where appropriate to receive full credit. 8 If you copy/paste from the Instruction tab you will be marked wrong.) 9 10 R square = 11 12 3. Predict the lab's total overhead costs for the month if 3,500 tests are performed. 13 a. Reference values calculated in previous requirements as needed. (Always use cell references and formulas where appropriate to receive full credit. 14 If you copy/paste from the Instruction tab you will be marked wrong.) 15 16 The total laboratory overhead at a volume of 3,500 lab tests is 17 18 19 20 21 48 AM 14/2021 22 INSTRUCTIONS ENTERANSWERS