Waxers provided the following information for its car waxing business for selected months: July August September...

Transcribed Image Text:

Waxers provided the following information for its car waxing business for selected months: July August September October Cars waxed Total waxing cost Multiple R R Square Adjusted R Square Standard Error Observations ANOVA Regression Residual Total 4.800 4,300 $31.800 $29,200 Management has also provided the following output from Excel. Answer the questions that follow. Regression Statistics Intercopt X Variable 1 0.965223 0.970665 0.963331 396.4393 6 1 4 5 June Coefficients 7932.917 4,000 $27,050 SS MS 20801344 2.1E-07 132.354 628656.4 157164 21430000 Signi F 0.000326 A. Based on the regression: 1. How much is the variable cost per unit if 4,200 cars a waxed? 3.900 $27.250 Lower 95% Upper 95% 4.900 $31.500 Lower 95.0% Standard Error 1885.963 2696.645 13169.19 0.425435 11.5045 0.00033 3.713236 6.075631 3.713236 6.075631 t Stat P-value 4.2063 0.01363 2696.645 13169.19 November 4,600 $30,500 B. Use the high-low method to: 1. Show calculations to determine the components of the cost equation for Waxers. Upper 95.0% 2. If 4,370 cars are waxed in December, how much will be the total cost? Do not round in the interim. Display your final answer with 2 decimals. 3. Name the specific data for Waxers which will be typed into the input y range in the regression wizard. 2. Write Waxers' cost equation in standard form here: 3. How much are total costs if 4,160 cars are waxed during December? Waxers provided the following information for its car waxing business for selected months: July August September October Cars waxed Total waxing cost Multiple R R Square Adjusted R Square Standard Error Observations ANOVA Regression Residual Total 4.800 4,300 $31.800 $29,200 Management has also provided the following output from Excel. Answer the questions that follow. Regression Statistics Intercopt X Variable 1 0.965223 0.970665 0.963331 396.4393 6 1 4 5 June Coefficients 7932.917 4,000 $27,050 SS MS 20801344 2.1E-07 132.354 628656.4 157164 21430000 Signi F 0.000326 A. Based on the regression: 1. How much is the variable cost per unit if 4,200 cars a waxed? 3.900 $27.250 Lower 95% Upper 95% 4.900 $31.500 Lower 95.0% Standard Error 1885.963 2696.645 13169.19 0.425435 11.5045 0.00033 3.713236 6.075631 3.713236 6.075631 t Stat P-value 4.2063 0.01363 2696.645 13169.19 November 4,600 $30,500 B. Use the high-low method to: 1. Show calculations to determine the components of the cost equation for Waxers. Upper 95.0% 2. If 4,370 cars are waxed in December, how much will be the total cost? Do not round in the interim. Display your final answer with 2 decimals. 3. Name the specific data for Waxers which will be typed into the input y range in the regression wizard. 2. Write Waxers' cost equation in standard form here: 3. How much are total costs if 4,160 cars are waxed during December?

Answer rating: 100% (QA)

Question The given reaction is intramolecular aldol condensation reaction When a molecule contains t... View the full answer