UV COM Dig Homework 5 6 Send Sava 4 Garfield Company manufactures popular and ot dog repellant owns Dog Gone it, which stingaton ne botes with a spray attachment. The majority of Gamela's business comes from orders placed by homeowners who are trying to wop neighborhood dogs out of the yard Garfield's operating information for the first six months of the years 9.00 Number of Bottles Sold 1,040 1,370 1.720 Operating COST $10.00 Mooth January February March April May June 1.78 10.10 2.4 3400 5. 18. 078 27.28 .ee Required 3. Using the high cow method, calculate Garfold's totaled operating costs and are operating cost per bottle (Do not round your intermediate chiculations. Round your variable cost per unit answer to 2 decimal places and cost answer to the nearest whole number) 09 Vale Cooper Fan Cost 4 4. Perform a least squares regression analys's on Garfield's data (Use Microsoft Excel or a statistical package to find the coeficients using least squares regression. Round your answers to 3 decimal places) 9.09 points Coefficients Intercept x Vanable 1 5. Determine how well this regression analysis explains the data (Round you regression statistics to three decimal places and your percentage answer to the nearest whole number.) Regression Statistics Multiple RSquare Adjusted R Sure Standard Error Observations From the regression output number of bottles explains about of the variability in Garfield's total cost 6. Using the regression output, create a linear cost equation (y+bx) for estimating Garfield's operating costs. (Round your answers to 3 decimal places.) Total Cost (Number of Bottes UV COM Dig Homework 5 6 Send Sava 4 Garfield Company manufactures popular and ot dog repellant owns Dog Gone it, which stingaton ne botes with a spray attachment. The majority of Gamela's business comes from orders placed by homeowners who are trying to wop neighborhood dogs out of the yard Garfield's operating information for the first six months of the years 9.00 Number of Bottles Sold 1,040 1,370 1.720 Operating COST $10.00 Mooth January February March April May June 1.78 10.10 2.4 3400 5. 18. 078 27.28 .ee Required 3. Using the high cow method, calculate Garfold's totaled operating costs and are operating cost per bottle (Do not round your intermediate chiculations. Round your variable cost per unit answer to 2 decimal places and cost answer to the nearest whole number) 09 Vale Cooper Fan Cost 4 4. Perform a least squares regression analys's on Garfield's data (Use Microsoft Excel or a statistical package to find the coeficients using least squares regression. Round your answers to 3 decimal places) 9.09 points Coefficients Intercept x Vanable 1 5. Determine how well this regression analysis explains the data (Round you regression statistics to three decimal places and your percentage answer to the nearest whole number.) Regression Statistics Multiple RSquare Adjusted R Sure Standard Error Observations From the regression output number of bottles explains about of the variability in Garfield's total cost 6. Using the regression output, create a linear cost equation (y+bx) for estimating Garfield's operating costs. (Round your answers to 3 decimal places.) Total Cost (Number of Bottes