Q: The US Box Office Gross profit was recorded for the first eleven weekends after the release of a major motion picture. For the dataset posted below this question, construct a scatterplot with the...

Q:
The US Box Office Gross profit was recorded for the first eleven weekends after the release of a major motion picture. For the dataset posted below this question, construct a scatterplot with the weekend as the horizontal axis and US Gross (in millions of dollars) as the vertical axis. Conduct an analysis of the Residuals using the Data Analysis ToolPak Regression tool. Comment on whether the assumptions of linear regression have been met. (Please solve this in Excel)