Simple Regression Using a Spreadsheet (Appendix A): 2. Problem 5-61 (C Only) 4 Name: 5 Date: Pts. Available: Pts. Earned: INF 8. Provided Information: Month O NONOWN Cases 345,000 $ 362,000 $ 358,000 $ 380,000 $ 374,000 $ 395,000 $ 367,000 $ 412,000 $ 398,000 $ 421,000 $ 417,000 $ 432,000 $ Operating Costs 5,699,139 5,806,638 5,849,905 5,927,617 5,939,135 6,043,364 5,918,495 6,133,868 6,126,130 6,186,625 6,208,799 6,362,255 gaaga 24 C. Perform a simple regression of operating costs on cases shipped: Estimate the operating costs assuming 450,000 cases will ship. Cost Formula: Cost of 450,000 cases: The R2 value for the regression: 34 Run Regression using Excel Analysis Toolpak: nn minimal Add SUMMARY OUTPUT (Here) ||