IDEAS home Printed from https://ideas.repec.org/a/ags/ajaees/367036.html
   My bibliography  Save this article

Holt-Winters Forecast on Seasonal Time Series Crop Insurance Data with Structural Outliers (2000-2018) Using Ms Excel

Author

Listed:
  • Priyanka, P. Asha
  • Nandakumar, E.
  • Sangeetha, R.

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.

Suggested Citation

  • Priyanka, P. Asha & Nandakumar, E. & Sangeetha, R., 2022. "Holt-Winters Forecast on Seasonal Time Series Crop Insurance Data with Structural Outliers (2000-2018) Using Ms Excel," Asian Journal of Agricultural Extension, Economics & Sociology, Asian Journal of Agricultural Extension, Economics & Sociology, vol. 40(9), pages 1-9.
    • Handle: RePEc:ags:ajaees:367036
    as

    Download full text from publisher

    File URL: https://ageconsearch.umn.edu/record/367036/files/Priyanka4092022AJAEES87724.pdf
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. Peter R. Winters, 1960. "Forecasting Sales by Exponentially Weighted Moving Averages," Management Science, INFORMS, vol. 6(3), pages 324-342, April.
    2. Chatfield, Chris & Yar, Mohammed, 1991. "Prediction intervals for multiplicative Holt-Winters," International Journal of Forecasting, Elsevier, vol. 7(1), pages 31-37, May.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Koehler, Anne B. & Snyder, Ralph D. & Ord, J. Keith, 2001. "Forecasting models and prediction intervals for the multiplicative Holt-Winters method," International Journal of Forecasting, Elsevier, vol. 17(2), pages 269-286.
    2. Bianchi, Lisa & Jarrett, Jeffrey & Choudary Hanumara, R., 1998. "Improving forecasting for telemarketing centers by ARIMA modeling with intervention," International Journal of Forecasting, Elsevier, vol. 14(4), pages 497-504, December.
    3. Bermudez, J.D. & Segura, J.V. & Vercher, E., 2006. "A decision support system methodology for forecasting of time series based on soft computing," Computational Statistics & Data Analysis, Elsevier, vol. 51(1), pages 177-191, November.
    4. De Gooijer, Jan G. & Hyndman, Rob J., 2006. "25 years of time series forecasting," International Journal of Forecasting, Elsevier, vol. 22(3), pages 443-473.
    5. Jan G. De Gooijer & Rob J. Hyndman, 2005. "25 Years of IIF Time Series Forecasting: A Selective Review," Monash Econometrics and Business Statistics Working Papers 12/05, Monash University, Department of Econometrics and Business Statistics.
    6. Gardner, Everette Jr., 2006. "Exponential smoothing: The state of the art--Part II," International Journal of Forecasting, Elsevier, vol. 22(4), pages 637-666.
    7. Denafas, Gintaras & Ruzgas, Tomas & Martuzevičius, Dainius & Shmarin, Sergey & Hoffmann, Michael & Mykhaylenko, Valeriy & Ogorodnik, Stanislav & Romanov, Mikhail & Neguliaeva, Ekaterina & Chusov, Alex, 2014. "Seasonal variation of municipal solid waste generation and composition in four East European cities," Resources, Conservation & Recycling, Elsevier, vol. 89(C), pages 22-30.
    8. Ramos, Francisco López & Batres, Rafael & De-la-Cruz-Márquez, Cynthia Griselle & Anzures, Melina López, 2023. "Optimization models for nopal crop planning with land usage expansion and government subsidy," Socio-Economic Planning Sciences, Elsevier, vol. 89(C).
    9. Tiantian Tu, 2025. "Bridging Short- and Long-Term Dependencies: A CNN-Transformer Hybrid for Financial Time Series Forecasting," Papers 2504.19309, arXiv.org.
    10. Holt, Charles C., 2004. "Author's retrospective on 'Forecasting seasonals and trends by exponentially weighted moving averages'," International Journal of Forecasting, Elsevier, vol. 20(1), pages 11-13.
    11. Baloglu, Ulas Baran & Demir, Yakup, 2018. "Lightweight privacy-preserving data aggregation scheme for smart grid metering infrastructure protection," International Journal of Critical Infrastructure Protection, Elsevier, vol. 22(C), pages 16-24.
    12. Hyndman, Rob J. & Khandakar, Yeasmin, 2008. "Automatic Time Series Forecasting: The forecast Package for R," Journal of Statistical Software, Foundation for Open Access Statistics, vol. 27(i03).
    13. Meira, Erick & Cyrino Oliveira, Fernando Luiz & de Menezes, Lilian M., 2022. "Forecasting natural gas consumption using Bagging and modified regularization techniques," Energy Economics, Elsevier, vol. 106(C).
    14. Rossi, Barbara, 2013. "Advances in Forecasting under Instability," Handbook of Economic Forecasting, in: G. Elliott & C. Granger & A. Timmermann (ed.), Handbook of Economic Forecasting, edition 1, volume 2, chapter 0, pages 1203-1324, Elsevier.
    15. Chen, Jiandong & Xu, Chong & Shahbaz, Muhammad & Song, Malin, 2021. "Interaction determinants and projections of China’s energy consumption: 1997–2030," Applied Energy, Elsevier, vol. 283(C).
    16. Daniela Pencheva, 2020. "Use of Factors Related to the Consumption of Fast Moving Consumer Goods in Business Intelligence System for Managing Orders to Suppliers in Retail Chain," Izvestia Journal of the Union of Scientists - Varna. Economic Sciences Series, Union of Scientists - Varna, Economic Sciences Section, vol. 9(2), pages 124-135, August.
    17. Syed M. Ahsan & S. Quamrul Ahsan, 2025. "When Am I Richer than You? Toward a Meaningful Comparison of Income of Nations," CESifo Working Paper Series 12097, CESifo.
    18. Azumah Karim & Ananda Omotukoh Kube & Bashiru Imoro Ibn Saeed, 2020. "Modeling of Monthly Meteorological Time Series," Journal of Statistical and Econometric Methods, SCIENPRESS Ltd, vol. 9(4), pages 1-8.
    19. Zhenni Ding & Huayou Chen & Ligang Zhou, 2023. "Using shapely values to define subgroups of forecasts for combining," Journal of Forecasting, John Wiley & Sons, Ltd., vol. 42(4), pages 905-923, July.
    20. Andrea Kolková, 2024. "Data Analysis in Demand Forecasting: A Case Study of Poetry Book Sales in the European Area," Central European Business Review, Prague University of Economics and Business, vol. 2024(5), pages 51-69.

    More about this item

    Keywords

    ;

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:ags:ajaees:367036. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: AgEcon Search (email available below). General contact details of provider: https://journalajaees.com/index.php/AJAEES/index .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.