Question

Clicca My WUIN The following information on maintenance and repair costs and revenues for the last two years is available froRegression Statistics Multiple R R Square Standard Error Observations Coefficients Intercept Revenues

0 0
Add a comment Improve this question Transcribed image text
Answer #1
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.

File Connections 2 A2 Home Insert Page Layout Formulas A Show Queries From Table Properties New Query Le Recent Sources All -

View P ower Pivot BE Home Insert Page Layout Formulas Data Review a Show Queries Connections AL ZA iet External From Table E

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
Add a comment
Know the answer?
Add Answer to:
Clicca My WUIN The following information on maintenance and repair costs and revenues for the last...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 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...

  • 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.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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT