Excel Equations

READ THISR a regression analysis to determine next year's Cost of Sales (Cost o 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 Year Cost of Sales DO NOT MODIFY THIS Sales 2017 $ 56,745 2016 $ 51,407 2015 $ 43.396 2014 $ 42.40 2013 $ 39.244 25,920 23.343 20.438 20,006 19.831 1) Summary Ouput 2) Analysis of Resuits )a Chart 3)b Chart has Trend Line 04) Recalculate COGS Next provide 3 reasons why this is or is not a good regression (that the correlation is relevant) SUMMARY OUTPUT 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 Sales Cost of Sales 2018 PLEASE PLACE THE GRAPH HERE Yes or No Possble: Is there a relevant correalation? Why or why not? Reason 1 Reason 2: Reason 3: READ THISR a regression analysis to determine next year's Cost of Sales (Cost o 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 Year Cost of Sales DO NOT MODIFY THIS Sales 2017 $ 56,745 2016 $ 51,407 2015 $ 43.396 2014 $ 42.40 2013 $ 39.244 25,920 23.343 20.438 20,006 19.831 1) Summary Ouput 2) Analysis of Resuits )a Chart 3)b Chart has Trend Line 04) Recalculate COGS Next provide 3 reasons why this is or is not a good regression (that the correlation is relevant) SUMMARY OUTPUT 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 Sales Cost of Sales 2018 PLEASE PLACE THE GRAPH HERE Yes or No Possble: Is there a relevant correalation? Why or why not? Reason 1 Reason 2: Reason 3