Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. statistics
  3. the following information on maintenance and repai

The following information on maintenance and repair costs and revenues for the last two years is available...

70.2K

Verified Solution

Question

Statistics

The followinginformation on maintenance and repair costs and revenues for thelast two years is available from the accounting records at Arnie’sArcade & Video Palace. Arnie has asked you to help himunderstand the relation between business volume and maintenance andrepair cost.

MonthMaintenanceand Repair Cost ($000)Revenues($000)
July$2.01$53.00
August2.9847.00
September2.5043.00
October1.9159.00
November2.0071.00
December0.8499.00
January2.8239.00
February2.8645.00
March2.7255.00
April2.6857.00
May1.7461.00
June1.4873.00
July2.3067.00
August1.7261.00
September2.2769.00
October2.0871.00
November1.1381.00
December0.46111.00
January2.2855.00
February1.9857.00
March1.3977.00
April1.6581.00
May1.6567.00
June1.5163.00

Required:

Using Excel, estimatea linear regression with maintenance and repair cost as thedependent 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 decimalplaces, Intercept and Revenues to 4 decimal places.)

REGRESSIONSTATISTICS
   MULTIPLE R ?
   R SQUARE    ?
   STANDARD ERROR    ?
   OBSERVATIONS    ?
   COEFFICIENTS
   INTERCEPT ?
   REVENUES ?

Answer & Explanation Solved by verified expert
3.8 Ratings (679 Votes)
In regression analysis the dependentvariable is denoted Y and the independentvariables    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Geometry
1.2K views

8 Find the sum of the measures of the interior angles of a poly gon...

Basic Math
1.2K views

Let F be a finite field. Prove that any element of F can be expressed...

Basic Math
1.2K views

Population N Managers 21 Employees 29 Population Mean 95 CI 60 52 4 23 52...

Basic Math
1.2K views

What does Cheever do when he finds Elizabeth Proctor in possession of adoll with a...

Basic Math
1.2K views

Find the slope of the line that passes through (10, -8) and (1, 12).4/9-20/99/420/9

Calculus
1.2K views

Find f x and f c Function f x x 6x 9x 4x 7 f...

Algebra
1.2K views

The equation N (t) = 450 / 1+49e-0.7t models the number of people in a...

Accounting
1.2K views

Riverbed Corporation sold $3,020,000, 6% 5-year bonds on January 1, 2017. The bonds were dated...

Accounting
1.2K views

On January 1, 2021, Bricker Enterprises purchased a framing machine for $100,000. The estimated service...

Accounting
1.2K views

Required: 1. Calculate the expected cash collections for April, May, and June. 2. Calculate the...

Finance
1.2K views

Exercise 3. (Again no picking numbers) Consider a stock that pays no dividends on which...

Accounting
1.2K views

Menchem corporation produces and sells a single product. In April the company sold 2100 units....