Week 10 Business Statistic Multiple Regression Analysis
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