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? __drives²
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