IDEAS home Printed from https://ideas.repec.org/a/ags/ajaees/367036.html

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. 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.
    3. Gardner, Everette Jr., 2006. "Exponential smoothing: The state of the art--Part II," International Journal of Forecasting, Elsevier, vol. 22(4), pages 637-666.
    4. 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.
    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. 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.
    7. Ralph D Snyder, 2005. "A Pedant's Approach to Exponential Smoothing," Monash Econometrics and Business Statistics Working Papers 5/05, Monash University, Department of Econometrics and Business Statistics.
    8. Pleños, Mary Cris F., . "Time Series Forecasting Using Holt-Winters Exponential Smoothing: Application to Abaca Fiber Data," Problems of World Agriculture / Problemy Rolnictwa Światowego, Warsaw University of Life Sciences, vol. 22(2).
    9. Rice, William L. & Park, So Young & Pan, Bing & Newman, Peter, 2019. "Forecasting campground demand in US national parks," Annals of Tourism Research, Elsevier, vol. 75(C), pages 424-438.
    10. Mr. Atsushi Iimi, 2006. "Exchange Rate Misalignment: An Application of the Behavioral Equilibrium Exchange Rate (BEER) to Botswana," IMF Working Papers 2006/140, International Monetary Fund.
    11. Kosuke Kawakami & Hirokazu Kobayashi & Kazuhide Nakata, 2021. "Seasonal Inventory Management Model for Raw Materials in Steel Industry," Interfaces, INFORMS, vol. 51(4), pages 312-324, July.
    12. Kim, Jae H. & Wong, Kevin & Athanasopoulos, George & Liu, Shen, 2011. "Beyond point forecasting: Evaluation of alternative prediction intervals for tourist arrivals," International Journal of Forecasting, Elsevier, vol. 27(3), pages 887-901.
    13. Stefan Mihai Petrea & Cristina Zamfir & Ira Adeline Simionov & Alina Mogodan & Florian Marcel Nuţă & Adrian Turek Rahoveanu & Dumitru Nancu & Dragos Sebastian Cristea & Florin Marian Buhociu, 2021. "A Forecasting and Prediction Methodology for Improving the Blue Economy Resilience to Climate Change in the Romanian Lower Danube Euroregion," Sustainability, MDPI, vol. 13(21), pages 1-36, October.
    14. Trull, Oscar & García-Díaz, J. Carlos & Troncoso, Alicia, 2021. "One-day-ahead electricity demand forecasting in holidays using discrete-interval moving seasonalities," Energy, Elsevier, vol. 231(C).
    15. Daniel C Medina & Sally E Findley & Boubacar Guindo & Seydou Doumbia, 2007. "Forecasting Non-Stationary Diarrhea, Acute Respiratory Infection, and Malaria Time-Series in Niono, Mali," PLOS ONE, Public Library of Science, vol. 2(11), pages 1-13, November.
    16. Tsao, Yu-Chung & Chen, Yu-Kai & Chiu, Shih-Hao & Lu, Jye-Chyi & Vu, Thuy-Linh, 2022. "An innovative demand forecasting approach for the server industry," Technovation, Elsevier, vol. 110(C).
    17. Felipe Leite Coelho da Silva & Josiane da Silva Cordeiro & Kleyton da Costa & Nemias Saboya & Paulo Canas Rodrigues & Javier Linkolk López-Gonzales, 2025. "Time series forecasting via integrating a filtering method: an application to electricity consumption," Computational Statistics, Springer, vol. 40(9), pages 5023-5042, December.
    18. A A Syntetos & J E Boylan & S M Disney, 2009. "Forecasting for inventory planning: a 50-year review," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 60(1), pages 149-160, May.
    19. repec:rnp:ppaper:r90221 is not listed on IDEAS
    20. Oleksandr Melnychenko & Valerii Matskul & Tetiana Osadcha, 2022. "The Dynamics of Trade Relations between Ukraine and Romania: Modelling and Forecasting," Virtual Economics, The London Academy of Science and Business, vol. 5(2), pages 7-23, July.
    21. Abdisalam Amin Esse & Abdisalan Ahmed Osman & Abdisalam Hassan Muse, 2025. "Modeling and Predicting Livestock Export in Somaliland: A Comparative Hybrid Model Approach," SN Operations Research Forum, Springer, vol. 6(4), pages 1-23, December.

    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.