12 Sep Multiple Regression Analysis Amazon.com has become one of the most successful online merchants. Two measures of its success are sales and net income/loss figures. The data can be fo
Multiple Regression Analysis
Amazon.com has become one of the most successful online merchants. Two measures of its success are sales and net income/loss figures. The data can be found in the file, Amazon.
Use Excel to complete the following:
- Construct a scatter plot for Amazon's net income/loss and sales figures for the period 1995–2015.
- Determine a polynomial model, including its order (or degree), for Amazon's net income/loss and sales figures.
Use Word to complete the following:
- Explain your process of determining the polynomial model
Sheet1
| Sales | Income | Year |
| 0 | -0.3 | 1995 |
| 0.02 | -5.7 | 1996 |
| 0.15 | -27.5 | 1997 |
| 0.61 | -124.5 | 1998 |
| 1.64 | -719.9 | 1999 |
| 2.76 | -1411.2 | 2000 |
| 3.12 | -567.3 | 2001 |
| 3.93 | -149.1 | 2002 |
| 5.26 | 35.3 | 2003 |
| 6.92 | 588.5 | 2004 |
| 8.49 | 359 | 2005 |
| 10.71 | 190 | 2006 |
| 14.84 | 476 | 2007 |
| 19.17 | 645 | 2008 |
| 24.51 | 902 | 2009 |
| 34.2 | 1150 | 2010 |
| 48.08 | 631 | 2011 |
| 61.09 | -39 | 2012 |
| 74.45 | 274 | 2013 |
| 88.99 | -241 | 2014 |
| 107.01 | 596 | 2015 |
