Please show all works, thank you.

5. Explain what the RSquate value in the output above toca $500! ST1000 Using your answer to item 4 and the Exhibit below, propter confidence interval for the 30 purchase order Question A. Cost Behavior SuperReb Products, Inc., a discount store, has gathered data on its overhead activities and associated costs for the past 12 months, Speeder, a member of the CFO's office believes that overheadl activities and coors should be classified into groups that have the same driver. Hey has decided that unloading incoming goods, counting goods, and inspecting goods can be grouped together as a more genital receiving activity, since these three activities are all driver by the number of purchase orders. The following 12 months of data have been gathered for the receiving activity: Purchase Receiving Month Orders Cour 1 20 2 40 3 B0 S 800 4 100 5500 5 9700 6 300 $1200 7 170 S 1400 90 s 2001 100 5 LODE 35 S 900 11 110 s tid 12 BO S 1201 Required: Climate Confidence Interval 8 9 10 7. Explain what the confidence interval means The confidence interval is a range of values with a probability that these range of values contain the true value of a certain statistic. a 1. Using a scattergraph, what is the cost formula using the data above for the receiving activity? 2. Using the high-kwatetiwd, what is the cost formula using the data above for the seculving activity! SUMMARY OUTPUT 95% 99% 12.70 Regression Statisties Multiple 0236 R Square 0.74 Adjusted Souare 0.90 Standard Error 50072 Observations 112 ANOVA Table of Selected Valuest Distribution Degrees of Freedom 90% 4314 2.920 2.353 2.132 2012 1.943 1.893 1.860 1833 1912 1.296 1.782 1,771 1.761 1.753 1.746 1.700 1.734 19 1.729 20 1.725 30 00 1445 278872 MS 2678492 B026740 F 9820 Sienione 2 Regression Residual Total 63.657 9.925 5.81 4.604 4.032 3.TOP 3.499 3.355 3.250 2.10 3.106 3.055 3.055 3.012 2.947 2.921 00 2.88 2.878 2.861 2.345 2.750 2.576 4303 3.12 2.776 2.571 5 2.447 2365 2.306 2262 50 2220 2201 219 2.100 2.145 Sur 2.131 2.120 2.110 2.101 2093 2.086 2042 1.960 256872 Coeffent. Standard Berar 125821 A Stotale 20 034 Intercept X Variable 1697 per costat 30, 3. Lising the provided summary output (that used the method of least squares), what is the cost formula using the data ahore for the receiving usivity 4. Using the provided sustamaty output (that used the method of least squates), wat is the expected cost for purchase orders 5. Explain what the RSquate value in the output above toca $500! ST1000 Using your answer to item 4 and the Exhibit below, propter confidence interval for the 30 purchase order Question A. Cost Behavior SuperReb Products, Inc., a discount store, has gathered data on its overhead activities and associated costs for the past 12 months, Speeder, a member of the CFO's office believes that overheadl activities and coors should be classified into groups that have the same driver. Hey has decided that unloading incoming goods, counting goods, and inspecting goods can be grouped together as a more genital receiving activity, since these three activities are all driver by the number of purchase orders. The following 12 months of data have been gathered for the receiving activity: Purchase Receiving Month Orders Cour 1 20 2 40 3 B0 S 800 4 100 5500 5 9700 6 300 $1200 7 170 S 1400 90 s 2001 100 5 LODE 35 S 900 11 110 s tid 12 BO S 1201 Required: Climate Confidence Interval 8 9 10 7. Explain what the confidence interval means The confidence interval is a range of values with a probability that these range of values contain the true value of a certain statistic. a 1. Using a scattergraph, what is the cost formula using the data above for the receiving activity? 2. Using the high-kwatetiwd, what is the cost formula using the data above for the seculving activity! SUMMARY OUTPUT 95% 99% 12.70 Regression Statisties Multiple 0236 R Square 0.74 Adjusted Souare 0.90 Standard Error 50072 Observations 112 ANOVA Table of Selected Valuest Distribution Degrees of Freedom 90% 4314 2.920 2.353 2.132 2012 1.943 1.893 1.860 1833 1912 1.296 1.782 1,771 1.761 1.753 1.746 1.700 1.734 19 1.729 20 1.725 30 00 1445 278872 MS 2678492 B026740 F 9820 Sienione 2 Regression Residual Total 63.657 9.925 5.81 4.604 4.032 3.TOP 3.499 3.355 3.250 2.10 3.106 3.055 3.055 3.012 2.947 2.921 00 2.88 2.878 2.861 2.345 2.750 2.576 4303 3.12 2.776 2.571 5 2.447 2365 2.306 2262 50 2220 2201 219 2.100 2.145 Sur 2.131 2.120 2.110 2.101 2093 2.086 2042 1.960 256872 Coeffent. Standard Berar 125821 A Stotale 20 034 Intercept X Variable 1697 per costat 30, 3. Lising the provided summary output (that used the method of least squares), what is the cost formula using the data ahore for the receiving usivity 4. Using the provided sustamaty output (that used the method of least squates), wat is the expected cost for purchase orders