Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. general management
  3. the number of internal disk drives? (in millions)

The number of internal disk drives? (in millions) made at a plant in Taiwan during the...

60.1K

Verified Solution

Question

General Management

The number of internal disk drives? (in millions) made at aplant in Taiwan during the past 5 years? follows:???????????????????????????????????????????????????????????????????Year Disk Drives

1      138

2       160

3         190

4       202

5 216

?a) Using simple linear regression?, the forecast for the numberof disk drives to be made next year? =240.6 disk drives

?b) The mean squared error? (MSE) when using simple linearregression? ____________drives2

c) The mean absolute percent error (MAPE) when using simplelinear refression=__________%

I was able to wrk through A), but how to I calculate b &c?

Answer & Explanation Solved by verified expert
3.7 Ratings (483 Votes)
Let the linear regression equation isY a bX Y Dependent variable Forecasted number of disk drives X Year number A b Constants We place all the values of Year and disk drives as provided in 2 separate columns in excel and apply the formula LINEST to obtain values of a and b    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

Q

Solve the given equation. 7 sin2(θ) − 36 sin(θ) + 5 = 0

Basic Math
Q

PV AND LOAN ELIGIBILITY You have saved $5,000 for a down payment on a new car....

Finance
Q

1)You are a fourth engineer on board ship and you were have told by a chief...

Civil Engineering
Q

Activity 4: • What was the peak voltage at R1 and R2 when you first stimulated...

Medical Sciences
Q

Blood type is an example of immunity therefore Type A blood carries the anti B...

Biology
Q

For a particle executing SHM the displacement x is given by x A cos wot...

Physics
Q

Y 27 71 4 Does the set of numbers form a Pythagorean triple Explain 7...

Geometry
Q

The coefficients of x23y19 in the expansion of 2x 3y2 is Select one O 8...

Algebra
Q

Si una cartera tuviera un rendimiento del 17%, el rendimiento del activo libre...

Accounting
Q

Cindrella uses aging to estimate uncollectibles. Accounts of $150,000 are less than 30 days old...

Accounting
Q

EMBA In Class Chapter 18 1. Carson Company manufactures a single product. Annual production costs...

Accounting
Q

The following post-closing trial balance was drawn from the accounts of Hardwood Timber Co. as...

Accounting