Skip to content
Research Article Open access CC BY 4.0

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 · pp. 136–145 · Published 7 Jun 2022

10.9734/ajaees/2022/v40i930986

Abstract

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

References (23)

  1. 1 European journal of operational research [DOI]
  2. 2 Forecasting principles and practice
  3. 3 Exponential smoothing: The state of the art [DOI]
  4. 4 Short-term electricity demand forecasting using double seasonal exponential smoothing [DOI]
  5. 5 Statistical Methods for Forecasting. [DOI]
  6. 6 Triple seasonal methods for short-term electricity demand forecasting [DOI]
  7. 7 Robust forecasting with exponential and Holt–Winters smoothing [DOI]
  8. 8 The comparison of Holt–Winters method and Multiple regression method: A case study [DOI]
  9. 9 Forecasting daily supermarket sales using exponentially weighted quantile regression [DOI]
  10. 10 Forecasting Sales by Exponentially Weighted Moving Averages [DOI]
  11. 11 A General Class of Holt-Winters Type Forecasting Models [DOI]
  12. 12 Prediction intervals for multiplicative Holt-Winters [DOI]
  13. 13 Robust exponential smoothing [DOI]
  14. 14 A study of the exponential smoothing technique in software reliability growth prediction [DOI]
  15. 15 Competitive Models for the Spanish Short-Term Electricity Demand Forecasting [DOI]
  16. 16 New Estimation Rules for Unknown Parameters on Holt-Winters Multiplicative Method [DOI]
  17. 17 Initial conditions estimation for improving forecast accuracy in exponential smoothing [DOI]
  18. 18 Monitoring for outliers and level shifts in kalman filter implementations of exponential smoothing [DOI]
  19. 19 Quality and reliability in engineering [DOI]
  20. 20 Agricultural Insurance Revisited: New Developments and Perspectives in Latin America and the Caribbean [DOI]
  21. 21 Comparative Study of Holt-Winters Triple Exponential Smoothing and Seasonal Arima: Forecasting Short Term Seasonal Car Sales in South Africa
  22. 22 Enhancing adaptive capacity through climate-smart insurance: Theory and evidence from India [DOI]
  23. 23 Pradhan Mantri Fasal Bima Yojana: Challenges and Way Forward [DOI]

Cited by 3

A Temporal-Spatial Attention Encoder-Decoder Network for Multivariate Time Series Forecasting and Its Application in Hot Blast Stove Production

Yinghua Yang, Tingwei Qin, Xiaozhi Liu · 2024 36th Chinese Control and Decision Conference (CCDC) · 2024

Showing 1 of 3 known citations — external sources report more than can currently be individually listed.

Related research

Article metrics

Real usage data collected on this platform.

66

Page views

0

PDF downloads

6

Outbound clicks

3

Citations

Views over time

Views by country

Approximate, from request IP at view time — not citizenship or institution. Countries with fewer than 5 views are grouped as "Other".

Traffic sources

Referring site, by host.

Views and downloads exclude known bots/crawlers. Citations combines this platform's own DOI-resolved index with each external source's own reported total — see Cited by above for individually listed citing works. Last refreshed 0 seconds ago.