Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Spreadsheet eBook The file P02_26.xlsx lists sales (in millions of dollars) of Dell Computer during the period 1987-1997 (where year 1 corresponds to 1987). a.

image text in transcribed
image text in transcribed
Spreadsheet eBook The file P02_26.xlsx lists sales (in millions of dollars) of Dell Computer during the period 1987-1997 (where year 1 corresponds to 1987). a. Fit a power and an exponential trend curve to these data. Which fits the data better? Enter MAPE as a percentage with a one-decimal digit precision. The exponential fit is the better of the two, with a MAPE of 13.8 b. Use your part a answer to predict 1999 sales for Dell. Round your answer to a whole number. 23453 c. Use your part a answer to describe how the sales of Dell have grown from year to year. Round your answer to a whole percentage. The model you chose in part a, predicts that sales are increasing by 14 % per year. A B D C Dell sales 2 3 Year Sales 69 . 159 258 7 W NA No 389 8 546 890 9 10 11 8 2014 2873 3475 5296 12 9 10 13 14 11 7759 15 16 17 18 Spreadsheet eBook The file P02_26.xlsx lists sales (in millions of dollars) of Dell Computer during the period 1987-1997 (where year 1 corresponds to 1987). a. Fit a power and an exponential trend curve to these data. Which fits the data better? Enter MAPE as a percentage with a one-decimal digit precision. The exponential fit is the better of the two, with a MAPE of 13.8 b. Use your part a answer to predict 1999 sales for Dell. Round your answer to a whole number. 23453 c. Use your part a answer to describe how the sales of Dell have grown from year to year. Round your answer to a whole percentage. The model you chose in part a, predicts that sales are increasing by 14 % per year. A B D C Dell sales 2 3 Year Sales 69 . 159 258 7 W NA No 389 8 546 890 9 10 11 8 2014 2873 3475 5296 12 9 10 13 14 11 7759 15 16 17 18

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

Business Finance

Authors: Eddie McLaney

11th Edition

1292134402, 9781292134406

More Books

Students also viewed these Finance questions