CHAPTER 4 - TECHNICAL CASE A major Polytechnical University collected data on yearly freshman applications (students who apply but might not be accepted or enroll). These are shown in the following table YEAR 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 ACTUAL 400 REGISTRATIONS 600 400 500 1000 800 700 900 1200 1400 1500 Use the above to answer these questions: Below is the screenshot of the formula applied - FILE HOME PAGE LAYOUT FORMULAS DATA VW VIEW OAXlceltop Co Autofum Receniny Financial Local Tee Duter Log Math & More Vid Time Terme To Function Manage Thace Dependents march See Remove it Function 020 Year period MA period WMA 12-10). 1 2010 3 2011 4 2012 5 2013 6 2014 2015 2016 2017 10 2011 11 2019 12 2020 13 2021 14 Registration 400 600 400 500 1000 000 700 900 1.200 1.400 1500 212 ROUNDUPLAVERAGE1264 ROUNDU ROUNDUPLAVERAGE3.05.01 ROUNDUP ROUNDUP AVERAGE 02:00 RO GROUNDUP AVERAGES 6.0) ROUNG ROUNDUPLAVERAGE 06-30 ROUNDUPLAVERAGE ROUNOU ROUNDUPLAVERAGE 10 ROUNOU ERAGE OSAS.) ROUNOUR ROUNDUP ERAGEBIO B12 ROUNDUR 11/2010 12-10 203*11/21*110 2-301/21*11.01 Below is the screenshot of the result - FLE HOME PAGE LAYOUT FORMAS DATA VE Y Decoracion De Cheese X Calibre romatiche 121 E H 1 N 1 2 Forecast 4 5 1300 6 1 Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 c D Registration period Mod WMA 400 000 400 430 1000 500 500 100 634 725 700 767 72 900 834 800 1200 300 05 3400 934 1000 1500 1167 1367 3000 3 10 1 15 From graph, it seems that 3 perod weighted moving average is more closer than 3 period moving average. 3. Graph the ORIGINAL DATA from the chart above against both the MOVING AVERAGE and the WEIGHTED MOVING AVERAGE. Which of the two methods comes closest to the actual and which seems better? Why