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.31 $59.00 August 3.28 53.00 September 2.80 49.00 October 2.21 65.00 November 2.30 77.00 December 1.14 105.00 January 3.12 45.00 February 3.16 51.00 March 3.02 61.00 April 2.98 63.00 May 2.04 67.00 June 1.78 79.00 July 2.60 73.00 August 2.02 67.00 September 2.57 75.00 October 2.38 77.00 November 1.43 87.00 December 0.76 117.00 January 2.58 61.00 February 2.28 63.00 March 1.69 83.00 April 1.95 87.00 May 1.95 73.00 June 1.33 69.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.) Regression Statistics Multiple R R Square Standard Error Observations Coefficients. Intercept Revenues
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.31 $59.00 August 3.28 53.00 September 2.80 49.00 October 2.21 65.00 November 2.30 77.00 December 1.14 105.00 January 3.12 45.00 February 3.16 51.00 March 3.02 61.00 April 2.98 63.00 May 2.04 67.00 June 1.78 79.00 July 2.60 73.00 August 2.02 67.00 September 2.57 75.00 October 2.38 77.00 November 1.43 87.00 December 0.76 117.00 January 2.58 61.00 February 2.28 63.00 March 1.69 83.00 April 1.95 87.00 May 1.95 73.00 June 1.33 69.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.) Regression Statistics Multiple R R Square Standard Error Observations Coefficients. Intercept Revenues
Trigonometry (MindTap Course List)
10th Edition
ISBN:9781337278461
Author:Ron Larson
Publisher:Ron Larson
ChapterP: Prerequisites
SectionP.3: The Cartesian Plane And Graphs Of Equations
Problem 7ECP
Related questions
Question
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.31 | $59.00 |
| August | 3.28 | 53.00 |
| September | 2.80 | 49.00 |
| October | 2.21 | 65.00 |
| November | 2.30 | 77.00 |
| December | 1.14 | 105.00 |
| January | 3.12 | 45.00 |
| February | 3.16 | 51.00 |
| March | 3.02 | 61.00 |
| April | 2.98 | 63.00 |
| May | 2.04 | 67.00 |
| June | 1.78 | 79.00 |
| July | 2.60 | 73.00 |
| August | 2.02 | 67.00 |
| September | 2.57 | 75.00 |
| October | 2.38 | 77.00 |
| November | 1.43 | 87.00 |
| December | 0.76 | 117.00 |
| January | 2.58 | 61.00 |
| February | 2.28 | 63.00 |
| March | 1.69 | 83.00 |
| April | 1.95 | 87.00 |
| May | 1.95 | 73.00 |
| June | 1.33 | 69.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.)
|
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Recommended textbooks for you
Trigonometry (MindTap Course List)
Trigonometry
ISBN:
9781337278461
Author:
Ron Larson
Publisher:
Cengage Learning
Elementary Algebra
Algebra
ISBN:
9780998625713
Author:
Lynn Marecek, MaryAnne Anthony-Smith
Publisher:
OpenStax - Rice University
Trigonometry (MindTap Course List)
Trigonometry
ISBN:
9781337278461
Author:
Ron Larson
Publisher:
Cengage Learning
Elementary Algebra
Algebra
ISBN:
9780998625713
Author:
Lynn Marecek, MaryAnne Anthony-Smith
Publisher:
OpenStax - Rice University
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL