Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 below. Use Excel to complete the following: 1. Construct a scatter plot for Amazon's net income/loss and sales figures for the period 1995-2014. 2. Determine a polynomial model including its order for Amazon's net income/loss and sales figures.
Use Word to explain your process of determining the polynomial model.
Year | Net Income/Loss | Sales |
1995 | -0.3 | 0.5 |
1996 | -5.7 | 15.7 |
1997 | -27.5 | 147.7 |
1998 | -124.5 | 609.8 |
1999 | -719.9 | 1639.8 |
2000 | -1411.2 | 2761.9 |
2001 | -567.3 | 3122.9 |
2002 | -149.1 | 3933 |
2003 | 35.3 | 5263.7 |
2004 | 588.5 | 6921 |
2005 | 359 | 8490 |
2006 | 190 | 10711 |
2007 | 476 | 14835 |
2008 | 645 | 19.17 |
2009 | 902 | 24.51 |
2010 | 1152 | 34.2 |
2011 | 631 | 48.08 |
2012 | -39 | 61.09 |
2013 | 274 | 74.45 |
2014 | -241 | 88.99 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started