Reference no: EM133149691
Amazon.com has become one of the most successful online merchants. Two measures of its success are sales and net income/loss figures. this data
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,4270,2008 24.51,5531,2009 34.2,7643,2010 48.08,10789,2011
By using excel how can I
- 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?