Solve question 4 and 5

E10-32 (similar to) Maureen Baker is the new manager of the materials stonenoom for Keller Manufacturing Maureen has been asked to estimate Auture data for the past 9 months as folows EEB (Click the loon to view the data for the past 9 months Estimated monthly purchases for this part based on expected demand of the two products for the rest of he year are as follows EEB (Click the icon to view the expected demand for the rest of the year) monthiy purchase costs for part 9096, used in two of Kaler's products. Maureen has purchase cost and quante Read the cequirements Requirements Data Table -X0 Data Table 1. The computer in Maureens office is down, and Maureen has been asked to Purchase Quantity Expected Cost of Purchase Quantity Purchased immediately provide an equation to estimate the future purchase cost for part #696 Maureen grabs a calculator and uses te highHow method to estimate a cost equation. What equation does she get? 2.890 parts 3.340 pars 3,760 3,100 12.880 2,830 74714,10 purchase costs for each of the last 3 months of the year 023 3,758 13,170 .6 3. Aher a few hours Maureens computer is fxed Maureen uses the frst 9 months of data and regression analysis to estimabe the relationship between the quantity purchased and purchase costs of pert 8696. The regression line Maureen obtains is as follows Print Done 3,.9003.343 15,278 3600 10,1152.262 14,900 $2.0579 3.71x and 1 Stat for the XValable 1 statistics.(Enter the R Square and t Evaluane the regression line using the criteria of economic plausbiny goodness of fit. and signficance of the independent variable. Compare the regression equation to the equation based on the high-low method. Which is a beter fi? Why? 4 Use the regression resuits to calculate the expected purchase costs for Print Done October, November, and December Compare the expected purchase costs to the expected purchase costs caloulaned using the high-low method requirement 2. Comment on your