$1.$ The attached excel file includes the raw data $($which has not been reviewed for errors$).$ A second tab includes graphs that provide a visual analysis of each of the possible cost drivers against total operating cost. Review the results to determine if there are any outliers that should be corrected. It is noted that the intern has been known to have made mistakes in data entry before by entering double zeroes on accident. Also, there are no other known errors or outliers that should have occurred. Using the graphs, determine if there are any situations where this has occurred.

If any errors are discovered, they should be corrected $($not deleted$),$ and you should use the cleaned$-$up data file for the remainder of this assignment.

Part $2$ Cost Driver Analysis $($uncleaned data with graphs$).$xlsx

$2.$ Using the cleaned data, prepare a correlation matrix showing the relationship among all of the variables.

a$-1.$ Which variable has the strongest correlation with total operating cost?

a$-2.$ What is the correlation?

b$-1.$ Which variable has the weakest correlation with total operating cost

b$-2.$ What is the correlation?

c$.$ Does it make sense to analyze the total number of meals produced, the number of meals sold, and the number of meals donated as separate variables?

$3.$ Prepare a visual diagram of the relationship between total operating cost and the single best driver identified in question $2$a above. Add a regression trend line to the graph.

a$.$ What is the estimate of weekly fixed cost?

b$.$ What is the estimate of variable cost per unit of x$?$

Note: Round your answer to the nearest cent $($two decimal places$).$

c$.$ What percentage of the variation in operating cost can be explained by the single best cost driver?