Asking about this question below. please follow exactly the instructions, should do it by excel, and give me detail solutions.

This question will be marked specifically for the use of excel functions and formulas. . Please review Lab Excel Tutorial 3 You may also need to review Lab Excel Tutorial 2 To receive full marks: Formulas must be used for ALL calculations . All statements, analysis and/or tables must have proper headings, and totals; sub-totals and final totals should have proper underlines and dollar signs if reporting a financial statement. . Checking spelling & grammar, and round all answers to the nearest $1 or whole number for total dollars. Per unit values should be to two decimal places. Evergreen Manufacturing has assembly support costs. Each unit produced requires assembly time. Depending on the product, some take longer to assemble. For example, the deluxe model takes two hours of assembly time versus the basic model. All units are assembled as built. Observation Finishing Hours Total Costs 1 900 $11,500 800 $10,250 W N 1,400 $16,750 1,300 $15,000 1,200 $13,000 Required 1. In Excel, set up a table that reports the data above (see Lab 2 excel tutorial for how to create a table). 2. Estimate the cost function using the high low method. Use the min and max formulas for identifying the high and low values in the data set (see Lab 3 excel tutorial) 3. Graph the observation data. Ensure to format the graph appropriately; it should include appropriate scaling for each axis, titles, trendline, cost function. Also report the cost equation in the graph. 4. Briefly discuss why the cost function from requirement #1 is different than the cost function from requirement #3. 5. Evaluate the cost function from requirement # 3, considering the following. a. Economic Plausibility b. Goodness of Fit c. Slope of regression line