Question

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

April 2.63 56.00

May 1.69   60.00

June 1.43 72.00

July 2.25   66.00

August 1.67 60.00

September 2.22 68.00

October 2.03 70.00

November 1.08 80.00

December 0.41 110.00

January 2.23 54.00

February 1.93 56.00

March 1.34 76.00

April 1.60 80.00

May 1.60 66.00

June 1.54 62.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.)

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Arnies Arcade & Video Palace. S.No Month Maintenance and Repair Cost 1 July 1.9600 2 Augus 2.9300 3 September 2.4500 4 Octob

Add a comment
Know the answer?
Add Answer to:
The following information on maintenance and repair costs and revenues for the last two years is...
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 $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...

  • Clicca My WUIN The following information on maintenance and repair costs and revenues for the last...

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

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

  • 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 Maintenance Hours Maintenance Cost June 9 $ 3,950 July 18 5,750 August 12 4,550 September 15 5,150 October 21 6,350 November 24 6,950 December 6 3,350 Using the high-low method, estimate both the fixed and variable components of its maintenance cost.    High- Low method- Calculation of variable cost per maintenance hour

  • Coding in C++ Write a program using structures to store the following weather information: - Month...

    Coding in C++ Write a program using structures to store the following weather information: - Month name - Day of month (Monday, Tuesday, etc) - High Temperature - Low Temperature - Rainfall for the day Use an the input.txt file to load the data into weather structures. Once the data for all the days is entered, the program should calculate and display the: - Total rainfall for the data - Average daily temperatures. (note: you'll need to calculate the days...

  • Create two tuples named months1 and months2, including first six months and last six months, respectively....

    Create two tuples named months1 and months2, including first six months and last six months, respectively. Create a new tuple from concatenation of the two tuples created previously. Print the tuple including all months. Print the name of the 6th month using tuple index. Query the index of the one of months. (ex.‘November’) python IDL #WORKLAB4.3 month1=('January','February','March','April','May','June') month2=('July','August','September','October','November','December') allMonths = 'months1'+ 'months2' print('allMonths') print(allMonths[6]) print(allMonths.index('November'))

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