Draw the appropriate chart using MS EXCEL, also carryout Exponential Smoothing model

in MS EXCEL for the given Alpha values, copy the results $($from EXCEL to Word$)$ and explain

which alpha is relatively better for the forecast. In this journey of identification of relatively

better way of forecasting you may take the support of MAD and MSE type of errors. Suggested

Alpha values are $0\mathrm{.}1,0\mathrm{.}2,0\mathrm{.}5,0\mathrm{.}7,0\mathrm{.}9.(10$ Marks$)$

NMIMS Global Access

School for Continuing Education $($NGA$-$SCE$)$

Course: Decision Science

Internal Assignment Applicable for December $2023$ Examination

Yield of

Groundnut

$($Kg$./$hectare$)$

$2000-01977$

$2001-021127$

$2002-03694$

$2003-041357$

$2004-051020$

$2005-061187$

$2006-07866$

$2007-081459$

$2008-091163$

$2009-10991$

$2010-111411$

$2011-121323$

$2012-13995$

$2013-141764$

$2014-151552$

$2015-161465$

$2016-171398$

$2017-181893$

$2018-191422$

$2019-202063$

$2020-211703$

$2021-221758$