Hello. I have this question around multiple regression for accounting. The question in part a asks me to use multiple regression via an excel program like Mega stat and find the cost driver rates. I entered the data from the problem and ran an ANOVA test in Megastat but I am unsure if this is te right Megastat test to use to find the cost driver rates. would you advise?

PROBLEMS 30. Multiple regression. The managers of Peterson's Catering Company are analyzing the costs involved in providing catering services Managers have selected the following cost drivers units of meals produced, total deliveries, namber of VIP services, number of driver activity for the past 16 months. new customers, and new products developed. Here are the cost data and levels of cost New Customers VIP Services New Products Total Overhead Meals Produced Deliveries 0 Month 3 4 4 1 2 12.690 11.980 10.950 10.280 0 345 310 280 245 205 355 150 4 2 2 3 3,130 6 7 4 8 2 1.340 1180 1.050 930 840 780 700 630 630 760 890 1070 1240 1.390 1.450 1.510 5 69.004 64.927 60,332 57,953 55.984 53.119 52,700 53.874 53.445 56,869 59.985 61.121 63.976 66.602 72,773 71,391 5972.101 9 5 7 8 10 12 10 9 8 7 6 4 4 2 6.980 8.930 9.800 10.560 11.560 11.710 12.460 13.520 13.620 169,730 10 11 135 120 175 200 240 285 330 315 3.614 12 13 0 14 1 15 16 Totals 103 17 a. Using multiple regression, find the cost driver rates for cach of the cost drivers. (Note: You must use a computer program such as Microsoft Excel to perform this step.) b. Management estimates the following levels of cost driver volumes for the next month for the budget. What is the estimated cost for the budget? (Don't forget to include the intercept of the regression in your estimate.) 12,000 1,100 300 Meals produced Deliveries VIP services New customers New products c. Peterson's Catering Company is considering outsourcing deliveries. Compared to your answer in requirement b., how much would be saved per month by outsourcing the delivery service before considering the cost of outsourcing)? 31. Account analysis. Refer to problem 30. File Home Insert Page Layout Formulas Data Review View Help Acrobat Calibri X Cut Le Copy Paste Format Painter 11 A A = CAS 2 Wrap Text Merge & Center V BIU v Clipboard 2 Font Alignment K16 fx H OO 4 10 A B D E F G 1 Total Overhead Meals produced Deliveries VIP Services New customers New products 2 69094 12690 1340 345 3 3 64927 11980 1180 310 4 4. 60332 10950 1050 280 1 5 57953 10280 930 245 5 0 6 55984 9020 840 205 7 2 7 53119 8130 780 185 8 2 8 52706 7540 700 160 3 9 53874 6980 630 144 12 4 53445 8930 680 135 10 11 54869 9800 760 120 9 12 59985 10560 890 175 8 13 61121 11560 1070 200 7 14 63926 11710 1240 240 6 15 66602 12460 1390 285 4 16 72773 13520 1450 330 4 1 17 71391 13620 1510 315 2 0 18 19 10 NONOO 20 21 22 23 24 25 26 27 28 G H D B 2 One factor ANOVA p-value 132E-79 Deliveries 10275 Meals produced 10.508.1 Total Overhead 60,758,3 Mean n Std Dev 5 60.7563 16 6,727 00 Total Overhead 6 10,6081 16 2,069.66 Meals produced 7 1,0275 18 293 66 Deliveries 3 2296 16 74 25 VIP Services 9 6.4 16 2.90 New customers 10 1.1 16 129 New products 17 121048 96 22 374 17 Total 12 13 ANOVA table 14 Source SS df MS 15 Treatment 5. 113194 16. Error 744,415, 119.81 90 8,271,290 220 1 Total 95 30 19 Post hoc analysis 20 D values for hirwise tests 21 New products New customers VIP Services 22 11 84 229 23 New products 11 24 New customers 54 9956 25 VP Services 2290 0227 3200 26 Deliveries 10275 3156 3180 2 Meals produced 10.0001 364031 1 000 20 Total Overhead 10.7563 32074 4 20 JO 2 Tukey simultaneous companion values (ar 00) New products New customers VIP Services 33 11 64 2290 34 New products 11 35 New customers 6.4 001 VP Services 2206 022 022 37 Delivenes 1027.5 101 100 078 38 Meals produced 10,000 1 10:43 10.45 1021 29 Total Overhead 00.2503 5975 5053 10 41 critical values for experimentwise tror 0.05 202 43 0:01 149 1 Descriptive stats 1 2:47 4566 15 125 61-621 Delivered 10275 Meals produced 10.6001 Total Overhead 00,7563 9:42 915 4032 1 Scatter Plot 1 Regression 1 Raw data 30 AOV 30 Raw data