Question
The following information on maintenance and repair costs and revenues for the last two years is available from the accounting records at Arnies Arcade &
The following information on maintenance and repair costs and revenues for the last two years is available from the accounting records at Arnies Arcade & Video Palace. Arnie has asked you to help him understand the relation between business volume and maintenance and repair cost.
Month | Maintenance and Repair Cost ($000) | Revenues ($000) |
July | $2.11 | $55.00 |
August | 3.08 | 49.00 |
September | 2.60 | 45.00 |
October | 2.01 | 61.00 |
November | 2.10 | 73.00 |
December | 0.94 | 101.00 |
January | 2.92 | 41.00 |
February | 2.96 | 47.00 |
March | 2.82 | 57.00 |
April | 2.78 | 59.00 |
May | 1.84 | 63.00 |
June | 1.58 | 75.00 |
July | 2.40 | 69.00 |
August | 1.82 | 63.00 |
September | 2.37 | 71.00 |
October | 2.18 | 73.00 |
November | 1.23 | 83.00 |
December | 0.56 | 113.00 |
January | 2.38 | 57.00 |
February | 2.08 | 59.00 |
March | 1.49 | 79.00 |
April | 1.75 | 83.00 |
May | 1.75 | 69.00 |
June | 1.45 | 65.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.)
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started