o P 1 4 U Umce Update to keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. ws x fx B D G H M N 1 Use the accounting data for Disney listed below to complete the following: 2 20pts Assume you want to forecast Cost of Goods Sold (COGS) based on its relationship with Revenue. 3 Graph the relationship between Revenue and Cost of Goods Sold for 2012-2018. Insert a trendline Display the trendline equation and the R-squared on the graph. Make the graph presentable. Place chart title on the graph. Label the axes. 2 10pts Does there appear to be a strong relationship between the Revenue and the Cost of Goods Sold? 6 What metric would you use to judge the strength of the relationship? 7 3 10pts Forecast Sales for 2019 and 2020 using the TREND function. Use the information obtained from the trendline equation to estimate COGS 2019. 40p 9 10 11 Disney 12 Chart Areal As of September 30, in S millions 5 8 13 14. 15 16 17 18 19 Revenue COGS 2012 42,278 23,468 2013 45,041 25,034 2014 48,813 26,420 2015 52,465 28,364 2016 55,632 29,993 2017 55,137 30,306 2018 59,434 32,726 2019 2020 20 21 22 23 24 Foreman Forecast 25 26 27 28 29 30 31 32 33 Exam Summary Problem 1 Problem 2 Problem 3 +