The following information on maintenance and repair costs and revenues for the last two years is available from the accounting records at Arnie’s 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.16 | $56.00 |
August | 3.13 | 50.00 |
September | 2.65 | 46.00 |
October | 2.06 | 62.00 |
November | 2.15 | 74.00 |
December | 0.99 | 102.00 |
January | 2.97 | 42.00 |
February | 3.01 | 48.00 |
March | 2.87 | 58.00 |
April | 2.83 | 60.00 |
May | 1.89 | 64.00 |
June | 1.63 | 76.00 |
July | 2.45 | 70.00 |
August | 1.87 | 64.00 |
September | 2.42 | 72.00 |
October | 2.23 | 74.00 |
November | 1.28 | 84.00 |
December | 0.61 | 114.00 |
January | 2.43 | 58.00 |
February | 2.13 | 60.00 |
March | 1.54 | 80.00 |
April | 1.80 | 84.00 |
May | 1.80 | 70.00 |
June | 1.42 | 66.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.)
|
Requirements 1
Regression Statistics | |
Multiple R | 0.86175177 |
R Square | 0.7426161 |
Adjusted R Square | 0.73091685 |
Standard Error | 0.339151996 |
Observations | 24 |
Requirement 2
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
Intercept | 4.375712495 | 0.294313407 | 14.86753 | 5.87E-13 | 3.765344 | 4.986081 | 3.765344 | 4.986081 |
Revenue | -0.033474357 | 0.004201549 | -7.96715 | 6.32E-08 | -0.04219 | -0.02476 | -0.04219 | -0.02476 |
Additional
ANOVA | |||||
df | SS | MS | F | Significance F | |
Regression | 1 | 7.301203659 | 7.301204 | 63.47544 | 6.32E-08 |
Residual | 22 | 2.530529674 | 0.115024 | ||
Total | 23 | 9.831733333 |
The following information on maintenance and repair costs and revenues for the last two years is...
The following information on maintenance and repair costs and revenues for the last two years is available from the accounting records at Arnie’s 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 $1.66 $46.00 August 2.63 40.00 September 2.15 36.00 October 1.56 52.00 November 1.65 64.00 December 0.49 92.00 January 2.47 32.00 February 2.51 38.00 March 2.37 48.00...
Clicca My WUIN The following information on maintenance and repair costs and revenues for the last two years is available from the accounting records at Arnie'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 1.59 Maintenance and Repair Cost $000) Revenues ($000) $1.86...
The following information on maintenance and repair costs and revenues for the last two years is available from the accounting records at Arnie’s 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 $1.96 $52.00 August 2.93 46.00 September 2.45 42.00 October 1.86 58.00 November 1.95 70.00 December 0.79 98.00 January 2.77 38.00 February 2.81 44.00 March 2.67 54.00...
The following information on maintenance and repair costs and revenues for the last two years is available from the accounting records at Arnie’s 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...
The following information on maintenance and repair costs and revenues for the last two years is available from the accounting records at Arnie's Arcade & Video Palace. Arnie has asked you to help him understand the relation between business volume and maintenance and repair cost. Month July Maintenance and Repair Cost ($000) $2.51 3.48 3.00 2.41 2.50 1.34 3.32 3.36 3.22 3.18 2.24 1.98 2.80 2.22 2.77 2.58 1.63 0.96 2.78 248 1.89 2.15 2.15 1.21 Revenues ($000) $63.00 57.00...
htlowb age 224 of 734 Contents costs incurred, along with the number of maintenance and repair jobs completed each month The data are shown below: Jobs Month January February March... April...... May June, July August.... September... October.. Repair Costs $22.000 $18.000 $7600 $20,000 $24,000 $22.400 $ 16,000 $ 12,800 $ 13,600 $ 9600 Required: 1. Using Microsoft Excel, prepare a scattergram by plotting jobs performed and repair costs on a graph. Fit a straight line to the plotted points using...
Thane Company is interested in establishing the relationship between electricity costs and machine hours. Data have been collected and a regression analysis prepared using Excel. The monthly data and the regression output follow: Machine Hours 2,500 2,900 1,900 3,100 3,800 Month January February March April May June July August September October November December 3,300 Electricity Costs $ 18,400 $ 21,000 $ 13,500 $ 23,000 $ 28,250 $ 22,000 $ 24,750 $ 22,750 $ 15,500 $ 26,000 $ 31,000 $ 27,750...
Thane Company is interested in establishing the relationship between electricity costs and machine hours. Data have been collected and a regression analysis prepared using Excel. The monthly data and the regression output follow: Month Machine Hours Electricity Costs January 3,000 $ 18,650 February 3,400 $ 21,500 March 2,400 $ 13,750 April 3,600 $ 23,500 May 4,300 $ 28,500 June 3,800 $ 22,500 July 4,600 $ 25,000 August 4,000 $ 23,000 September 2,500 $ 16,000 October 4,200 $ 26,500 November...
Thane Company is interested in establishing the relationship between electricity costs and machine hours. Data have been collected and a regression analysis prepared using Excel. The monthly data and the regression output follow: Month January February March April May June July August September October November December Machine Hours 2,200 2,600 1,600 2,800 3,500 3,000 3,800 3,200 1,700 3,400 4,400 3,900 Electricity Costs $ 19,050 $22,300 $14,150 $24,300 $28,900 $23,300 $25,400 $23,400 $ 16,800 $27,300 $32,300 $28,400 Summary Output Regression Statistics...
Thane Company is interested in establishing the relationship between electricity costs and machine hours. Data have been collected and a regression analysis prepared using Excel. The monthly data and the regression output follow: Month Machine Hours Electricity Costs January 2.500 $ 18.400 February 2,900 21,000 March 1.900 13,500 April 3,100 23,000 May 3.800 28,250 3,300 22,000 4,500 24,750 August 3.500 22,750 September 2,000 15,500 October 3,700 26,000 November 4,700 31.000 December 4.200 27,750 Summary Output Regression Stonistics Multiple 0.965 0.932...