Problems


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.




Microsoft Press - Microsoft Office Excel 2007. Data Analysis and Business Modeling
MicrosoftВ® Office ExcelВ® 2007: Data Analysis and Business Modeling (Bpg -- Other)
ISBN: 0735623961
EAN: 2147483647
Year: 2007
Pages: 200

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net