The followinginformation on maintenance and repair costs and revenues for thelast two years is available from the accounting records at Arnie’sArcade & Video Palace. Arnie has asked you to help himunderstand the relation between business volume and maintenance andrepair cost.
| Month | Maintenanceand Repair Cost ($000) | Revenues($000) |
| July | $2.01 | $53.00 |
| August | 2.98 | 47.00 |
| September | 2.50 | 43.00 |
| October | 1.91 | 59.00 |
| November | 2.00 | 71.00 |
| December | 0.84 | 99.00 |
| January | 2.82 | 39.00 |
| February | 2.86 | 45.00 |
| March | 2.72 | 55.00 |
| April | 2.68 | 57.00 |
| May | 1.74 | 61.00 |
| June | 1.48 | 73.00 |
| July | 2.30 | 67.00 |
| August | 1.72 | 61.00 |
| September | 2.27 | 69.00 |
| October | 2.08 | 71.00 |
| November | 1.13 | 81.00 |
| December | 0.46 | 111.00 |
| January | 2.28 | 55.00 |
| February | 1.98 | 57.00 |
| March | 1.39 | 77.00 |
| April | 1.65 | 81.00 |
| May | 1.65 | 67.00 |
| June | 1.51 | 63.00 |
|
Required:
Using Excel, estimatea linear regression with maintenance and repair cost as thedependent 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 decimalplaces, Intercept and Revenues to 4 decimal places.)
REGRESSIONSTATISTICS
  MULTIPLE R ?
  R SQUARE   ?
  STANDARD ERROR   ?
  OBSERVATIONS   ?
  COEFFICIENTS
  INTERCEPT ?
  REVENUES ?
