Year Mergers Year Mergers 2010 46 2016 83 2011 46 2017 123 2012 62…

Question Answered step-by-step Year Mergers Year Mergers 2010 46 2016 83 2011 46 2017 123 2012 62… Image transcription textUse a 2-year moving average method to calculate forecasts for the years 2012-2022. Question 2—Use a 2-yearweighted moving average method to calculate forecasts for the years 2012-2022, with the weight of 0.7 to beassigned to the most recent year data. Note: The SUMPRODUCT function must be used for comp… Show more… Show moreYearMergersYearMergers2010462016832011462017123201262201897201345201918620146420202252015612021240  Exponential Smoothing    Linear Trendline   PeriodDtFtEtEt^2|Et|% Error FtEtEt^2|Et|% Error146           246           362           445           564           661           783           8123           997           10186           11225           12240                          Exponential SmoothingLinear Trendline        MSE            MAD            MAPD            Bias           Type your conclusions below             Business Management Project Management BIO MISC Share QuestionEmailCopy link Comments (0)