Regression statistics | |
Multiple R | 0.8852219 |
R square | 0.7836178 |
Standard error | 0.3041103 |
Observations | 24 |
Coefficients | |
Intercept | 3.9044 |
Revenues | -0.0336 |
---------------------------------------------------------------------------------------------------------------------------
The general form of linear regression equation is defined as
Y = b0 + b1 X
where Y = dependent variable = Maintenance and repair cost
X = independent variable = Revenues
b0 = intercept
b1 = slope
To obtain the values of intercept and slope, we have to perform regression analysis in excel.
In excel, go to data tab and choose data analysis and select regression.
SUMMARY OUTPUT | ||||||||
Regression Statistics | ||||||||
Multiple R | 0.885221888 | |||||||
R Square | 0.783617791 | |||||||
Adjusted R Square | 0.773782236 | |||||||
Standard Error | 0.304110289 | |||||||
Observations | 24 | |||||||
ANOVA | ||||||||
df | SS | MS | F | Significance F | ||||
Regression | 1 | 7.368305846 | 7.368306 | 79.67194 | 9.148E-09 | |||
Residual | 22 | 2.034627487 | 0.092483 | |||||
Total | 23 | 9.402933333 | ||||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
Intercept | 3.904394424 | 0.241992535 | 16.13436 | 1.12E-13 | 3.4025326 | 4.40625623 | 3.402532622 | 4.406256226 |
X Variable 1 | -0.03362783 | 0.003767438 | -8.92591 | 9.15E-09 | -0.041441 | -0.0258146 | -0.041441018 | -0.025814641 |
Clicca My WUIN The following information on maintenance and repair costs and revenues for the last...
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...
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.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...
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...
The following information is available for a company’s maintenance cost over the last seven months. Month Units Produced Maintenance Cost June 110 $ 5,320 July 170 7,300 August 130 5,980 September 160 6,970 October 220 8,950 November 250 9,940 December 70 4,000 Using the high-low method, estimate both the fixed and variable components of its maintenance cost.
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...