首页    期刊浏览 2024年12月03日 星期二
登录注册

文章基本信息

  • 标题:Holt-Winters Forecast on Seasonal Time Series Crop Insurance Data with Structural Outliers (2000-2018) Using Ms Excel
  • 本地全文:下载
  • 作者:P.Asha Priyanka ; E.Nandakumar ; R.Sangeetha
  • 期刊名称:Asian Journal of Agricultural Extension, Economics & Sociology
  • 电子版ISSN:2320-7027
  • 出版年度:2022
  • 卷号:40
  • 期号:9
  • 页码:136-145
  • DOI:10.9734/ajaees/2022/v40i930986
  • 语种:English
  • 出版社:Sciencedomain International
  • 摘要:Time series data on the number of farmers enrolled in different crop insurance schemes such as NAIS, MNAIS and PMFBY in the state of Tamil Nadu, India was analysed for its seasonality, outliers and forecast. The data was found to be seasonal and exponentially increasing. Seasonality is innate as the crop insurance itself was registered separately for two seasons (Kharif and Rabi). Multiplicative Holt-Winters Model should be applied in order to do short range forecast for an exponentially increasing dataset. The model was run in Ms-Excel in order to understand the basics of times series forecasting. Minimum MSE value was the criteria used to find the better fitting smoothing values. The residual of the model was examined for the fit of the model. Residual mean value was close to zero. Residuals are tested for autocorrelation with Durbin-Watson test and Runs test. Histogram of residuals implies a normal distribution. Presence of outliers are detected using 3IQR method and the identified outliers are part of the structure of data and need not be removed. However, alternate models of Holt-Winters itself which are robust to work with outliers are reviewed and RHW model of Gelpers et al. [1] was suggested.
  • 关键词:Holt-winters;forecast;seasonal data;crop insurance;structural outliers
国家哲学社会科学文献中心版权所有