Excel activity Multiple Regression Analysis Amazon.com has become one of the most successful online merchants. Two measures of its success are sales and n

Excel activity Multiple Regression Analysis

Amazon.com has become one of the most successful online merchants. Two measures of its success are sales and n

Click here to Order a Custom answer to this Question from our writers. It’s fast and plagiarism-free.

Excel activity 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 attached file.

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

Submit your work in a Word document and attach your Excel file. 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

Place your order now for a similar assignment and have exceptional work written by one of our experts, guaranteeing you an A result.

Need an Essay Written?

This sample is available to anyone. If you want a unique paper order it from one of our professional writers.

Get help with your academic paper right away

Quality & Timely Delivery

Free Editing & Plagiarism Check

Security, Privacy & Confidentiality