No Need to provide the three reasons or trendline / formula questions.

READ THIS .Run a regression analysis to determine next year's Cost of Sales (Cost of Year Sales Cost of Sales DO NOT MODIFY THIS 2017 $ 56,745 2016 $ 51,407 2015 43.3 2014 $ 42,401 2013 39,244 25,920 23,343 20.438 20,005 19,831 1) Summary Ouput 2) Analysis of Resuts 3ja Chart 3b Chart has Trend Line 4) Recalculate COGS Goods Sold) where Sales is the Independent Variable. Set the output to cell A9. Then use the results to calculate the Cost of Sales. Enter your formula for this below Next provide 3 reasons why this is or is not a good regression (that the correlation is relevant) Your regression report should show here Graph the Sales and Cost of Sales as an X-Y Scatter Chart and include the Trendline and formula on the graph. Cost of Sales 201