Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Malcar Autoparts Company has started producing replacement control microcomputers for automobiles. Sales data since 2000 are as follows: Year Sales 1 2000 240,000 2

1. Malcar Autoparts Company has started producing replacement control microcomputers for automobiles. Sales data since 2000 are as follows:

Year

Sales

1

2000

240,000

2

2001

218,000

3

2002

405,000

4

2003

587,000

5

2004

795,000

6

2005

762,000

7

2006

998,000

8

2007

1,217,000

9

2008

1,570.000

10

2009

1,947,000

11

2010

2,711,000

12

2011

3,104,000

13

2012

2,918,000

14

2013

4,606,000

15

2014

5,216,000

16

2015

5,010,000

Total

a) Graph these data and indicate whether they appear to have

a linear trend. Discuss this.

b) Develop a simple linear regression model with time as the independent variable. Using this regression model, describe the trend and the strength of the linear trend over the 16 years. Is the trend line statistically significant? Plot the trend line against the actual data.

c) Compute the MAD for this model.

d) Provide the Malcar Autoparts Company an estimate of its expected sales for the next 5 years.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Customer Support Audit

Authors: Colin G. Armistead

1st Edition

190776609X, 978-1907766091

More Books

Students also viewed these Accounting questions