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.jpg

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

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter4: Equations Of Linear Functions

Section4.5: Correlation And Causation

Problem 15PPS

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