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 2Use 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)


