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.