This is a problem #13, chapter 9 - Regression Analysis, from the textbook by Cliff Ragsdale, "Spreadsheet Modeling and Decision Analysis".
This problem requires the use of Excel and the add-in, called Solver. The course is Excel-based and Solver is the optimization application used for all problems. This problem has (a),(b),(c),(d), and (e) questions to it.
I have answered (a) and(b),
Need to double check if I did (c) correctly
Need help with (d)
Need help with (e) - to answer this question please use formulas in the cells and Solver.
Please look at the excel spreadsheet to answer this questions! I have made a comment on the Excel sheet on question (e)
The expert provides a regression analysis for operational management.