15 This question does not need any more information you need to solve the question utilizing regression analysis. Use excel. If you do not know how to do that you are the wrong person to answer this question.

The following information on maintenance and repair costs and revenues for the last two years is available from the accounting records at Arnle's Arcade & Video Palace. Arnie has asked you to help him understand the relation between business volume and maintenance and repair cost. Month July August September October November December January February March April May June July August September October November December January February March April May June Maintenance and Repair Cost ($900) $2.41 3.38 2.90 2.31 2.40 1.24 3.22 3.26 3.12 3.08 2.14 1.88 2.70 2.12 2.67 2.48 1.53 0.86 2.68 2.38 1.79 2.05 2.05 1.27 Revenues (5000) $61.00 55.00 51.00 67.00 79.00 107.00 47.00 53.00 63.00 65.ee 69.00 81.00 75.00 69.00 77.00 79.00 89.00 119.00 63.00 65.00 85.00 89.00 75.00 71.00 Required: Using Excel, estimate a linear regression with maintenance and repair cost as the dependent variable and revenue as the independent variable. (Negative amounts should be Indicated by a minus sign. Round "Multiple R, R Square and Standard Error" to 7 decimal places, "Intercept and Revenues" to 4 decimal places.) Regression Statistics Multiple R R Square Standard Error Observations Coefficients Intercept Revenues