Use the XL.Miner Analysis ToolPak to conduct your regresselon analysis After deleting all teat in this shaded area, set the output range in the Toolpak to the fop lett cell of thrs areat (D) Yout zegression outpet should fir lato this thaded area a. Compute b1 and b0 (to 1 decimal). b1 b0 Complete the estimated regression equation (to 1 decimal). y^= b. According to this model, what is the change in cost (in dollars) for every unit produced (to 1 decimal)? c. Compute the coefficient of determination (to 3 decimals). Note: report r2 between 0 and 1 . r2= What percentage of the variation in total cost can be explained by the production volume (to 1 decimal)? d. The company's production schedule shows 500 units must be produced next month. What is the estimated total cost for this operation (to the nearest whole number)? notel Use the XL.Miner Analysis ToolPak to conduct your regresselon analysis After deleting all teat in this shaded area, set the output range in the Toolpak to the fop lett cell of thrs areat (D) Yout zegression outpet should fir lato this thaded area a. Compute b1 and b0 (to 1 decimal). b1 b0 Complete the estimated regression equation (to 1 decimal). y^= b. According to this model, what is the change in cost (in dollars) for every unit produced (to 1 decimal)? c. Compute the coefficient of determination (to 3 decimals). Note: report r2 between 0 and 1 . r2= What percentage of the variation in total cost can be explained by the production volume (to 1 decimal)? d. The company's production schedule shows 500 units must be produced next month. What is the estimated total cost for this operation (to the nearest whole number)? notel