The file P16_03.xlsx gives the annual sales for Microsoft (in millions of dollars) for a 10-year period.

Question:

The file P16_03.xlsx gives the annual sales for Microsoft (in millions of dollars) for a 10-year period.

a. Fit an exponential trendline to these data.

b. By what percentage do you estimate that Microsoft will grow each year?

c. Why can’t a high rate of exponential growth continue for a long time?

d. Rather than an exponential curve, what type of curve might better represent the growth of a new technology?

e. If you can find Microsoft sales data since the period shown in the file, check whether its sales continued at the exponential rate from part b.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Practical Management Science, Revised

ISBN: 9781118373439

3rd Edition

Authors: Wayne L Winston, S. Christian Albright

Question Posted: