Multiple Regression AnalysisAmazon.com has become one of the most successful online merchants. Two measures of its success are sales and net income/loss figures. The data:YearNet Income/LossSales1995-0.30.51996-5.715.71997-27.5147.71998-124.5609.81999-719.91639.82000-1411.22761.92001-567.33122.92002-149.13933200335.35263.72004588.5692120053598490200619010711200747614835200864519.17200990224.512010115234.2201163148.082012-3961.09201327474.452014-24188.99 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 mode*Please provide steps and if possible screen shots on the excel portion when I tried to do the scatter plot my range was really off so i need specifics

Answered: Image /qna-images/answer/9b94918e-91fd-43f3-99ce-f15bcb844690.jpgonly a part is solved

Answered: Amazon.com has become one of the most…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

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:

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

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 mode

*Please provide steps and if possible screen shots on the excel portion when I tried to do the scatter plot my range was really off so i need specifics

Expert Solution