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.36 | $60.00 |
August | 3.33 | 54.00 |
September | 2.85 | 50.00 |
October | 2.26 | 66.00 |
November | 2.35 | 78.00 |
December | 1.19 | 106.00 |
January | 3.17 | 46.00 |
February | 3.21 | 52.00 |
March | 3.07 | 62.00 |
April | 3.03 | 64.00 |
May | 2.09 | 68.00 |
June | 1.83 | 80.00 |
July | 2.65 | 74.00 |
August | 2.07 | 68.00 |
September | 2.62 | 76.00 |
October | 2.43 | 78.00 |
November | 1.48 | 88.00 |
December | 0.81 | 118.00 |
January | 2.63 | 62.00 |
February | 2.33 | 64.00 |
March | 1.74 | 84.00 |
April | 2.00 | 88.00 |
May | 2.00 | 74.00 |
June | 1.30 | 70.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.)
Multiple R: ?
R Square: ?
Standard Error: ?
Observations: ?
Intercept: ?
Revenues: ?
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