1. Prepare a visual analysis of the data to identify any potential outliers.

2. Use the cleaned up data set to prepare a correlation matrix showing the relationships among total operating costs and all possible cost drivers. Based strictly on the correlation matrix, identify the single best cost driver. Does this make sense for Taylors business? Why or why not? 3. Prepare a visual diagram of the relationship between total operating cost and the single best driver identified in part 1. Add a trend line (simpre regression) to the graph. How much of the total variation in operating cost can be explained by a single cost driver? Explain how this ties to the correlation matrix you prepared above.

4. Run a multiple regression that includes all of the cost drivers. How does this model compare to the simple regression from requirement 3? 5. Use the model you identify as best to predict annual operating cost based on 52 weeks, 8,000 direct labor hours, 30,000 meal kits delivered, 150 new menu items developed and 750 shipments of donated meals.

A B C D E F G I J 143 4 460 8 143 3 465 8 8 143 4 570 400 2 8 131 146 3 458 8 147 3 8 490 588 147 4 8 150 3 300 8 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 150 3 420 10 4 440 8 150 150 5 430 150 4 475 10 8 8 150 3 500 515 150 4 8 150 4 8 24 $ 25 $ 261 $ 271 $ 28 $ 29 $ 30$ 31 $ 32] $ 33 $ 34 $ 350 $ 36 $ 37 $ 38 $ 39 $ 40 $ 41 $ 42 $ 43 $ 44 $ 45$ 46 $ 47 $ 48$ 49 $ 50 $ 51 $ 52 $ $ 5,506 $ 5,756 $ 6,256 $ 5,565 $ 5,656 $ 5,856$ 6,406 $ 4,855 $ 5,506 $ 5,656 $ 5,681 $ 5,731 $ 6,006 $ 6,106 $ 6,256 $ 6,306 $ 6,406 $ 6,907 $ 7,107 $ 5,856 $ 6,507 $ 6,857 $ 7,007 $ 7,883$ 5,600$ 4,375$ 8,008$ 6,081 $ 6,256 $ 292,472 $ 3,983 3,855 4,151 3,718 4,174 3,966 4,270 3,808 4,347 4,300 4,472 4,098 3,796 3,904 4,552 4,457 4,684 4,281 4,404 4,424 4,586 4,651 4,976 4,983 4,785 5,120 5,127 4,609 4,742 212,351 480 540 3,146 3,289 3,575 3,180 3,232 3,346 3,661 2,774 3,146 3,232 3,246 3,275 3,432 3,489 3,575 3,604 3,661 3,947 4,061 3,346 3,718 3,918 4,004 4,505 32,000 2,500 4,576 3,475 3,575 195,927 1,573 1,645 1,788 1,590 1,616 1,673 1,830 1,387 1,573 1,616 1,623 1,637 1,716 1,745 1,788 1,802 1,830 1,973 2,031 1,673 1,859 1,959 2,002 2,252 1,600 1,250 2,288 1,737 1,788 83,564 1,573 1,645 1,788 1,590 1,616 1,673 1,830 1,387 1,573 1,616 1,623 1,637 1,716 1,745 1,788 1,802 1,830 1,973 2,031 1,673 1,859 1,959 2,002 2,252 1,600 1,250 2,288 1,737 1,788 83,564 150 4 10 8 150 4 490 41 42 43 4 650 8 1,500 150 4 670 8 44 154 4 8 450 320 120 4 10 10 169 5 580 169 3 700 8 169 5 680 10 173 4 600 10 45 46 47 48 49 50 51 52 53 54 55 5 720 4 173 173 180 188 8,595 8 100 10 3 600 450 460 24,878 4 10 510 Total 182 A B C D E F G I J 143 4 460 8 143 3 465 8 8 143 4 570 400 2 8 131 146 3 458 8 147 3 8 490 588 147 4 8 150 3 300 8 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 150 3 420 10 4 440 8 150 150 5 430 150 4 475 10 8 8 150 3 500 515 150 4 8 150 4 8 24 $ 25 $ 261 $ 271 $ 28 $ 29 $ 30$ 31 $ 32] $ 33 $ 34 $ 350 $ 36 $ 37 $ 38 $ 39 $ 40 $ 41 $ 42 $ 43 $ 44 $ 45$ 46 $ 47 $ 48$ 49 $ 50 $ 51 $ 52 $ $ 5,506 $ 5,756 $ 6,256 $ 5,565 $ 5,656 $ 5,856$ 6,406 $ 4,855 $ 5,506 $ 5,656 $ 5,681 $ 5,731 $ 6,006 $ 6,106 $ 6,256 $ 6,306 $ 6,406 $ 6,907 $ 7,107 $ 5,856 $ 6,507 $ 6,857 $ 7,007 $ 7,883$ 5,600$ 4,375$ 8,008$ 6,081 $ 6,256 $ 292,472 $ 3,983 3,855 4,151 3,718 4,174 3,966 4,270 3,808 4,347 4,300 4,472 4,098 3,796 3,904 4,552 4,457 4,684 4,281 4,404 4,424 4,586 4,651 4,976 4,983 4,785 5,120 5,127 4,609 4,742 212,351 480 540 3,146 3,289 3,575 3,180 3,232 3,346 3,661 2,774 3,146 3,232 3,246 3,275 3,432 3,489 3,575 3,604 3,661 3,947 4,061 3,346 3,718 3,918 4,004 4,505 32,000 2,500 4,576 3,475 3,575 195,927 1,573 1,645 1,788 1,590 1,616 1,673 1,830 1,387 1,573 1,616 1,623 1,637 1,716 1,745 1,788 1,802 1,830 1,973 2,031 1,673 1,859 1,959 2,002 2,252 1,600 1,250 2,288 1,737 1,788 83,564 1,573 1,645 1,788 1,590 1,616 1,673 1,830 1,387 1,573 1,616 1,623 1,637 1,716 1,745 1,788 1,802 1,830 1,973 2,031 1,673 1,859 1,959 2,002 2,252 1,600 1,250 2,288 1,737 1,788 83,564 150 4 10 8 150 4 490 41 42 43 4 650 8 1,500 150 4 670 8 44 154 4 8 450 320 120 4 10 10 169 5 580 169 3 700 8 169 5 680 10 173 4 600 10 45 46 47 48 49 50 51 52 53 54 55 5 720 4 173 173 180 188 8,595 8 100 10 3 600 450 460 24,878 4 10 510 Total 182