MicrosoftВ® Office ExcelВ® 2007: Data Analysis and Business Modeling (Bpg -- Other)

The file Exponentialdata.xlsx contains annual sales revenue for Staples, Wal-Mart, and Intel. Use this data to work through the following problems.

1. For each company, fit an exponential trend curve to its sales data.

2. For which company does exponential growth have the best fit with its revenue growth?

3. For which company does exponential growth have the worst fit with its revenue growth?

4. For each company, estimate the annual percentage growth rate for revenues.

5. For each company, use your trend curve to predict 2003 revenues.