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. 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.
    4. Gardner, Everette Jr., 2006. "Exponential smoothing: The state of the art--Part II," International Journal of Forecasting, Elsevier, vol. 22(4), pages 637-666.
    5. 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.
    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. repec:rnp:ppaper:r90221 is not listed on IDEAS
    8. Svetunkov, Ivan & Chen, Huijing & Boylan, John E., 2023. "A new taxonomy for vector exponential smoothing and its application to seasonal time series," European Journal of Operational Research, Elsevier, vol. 304(3), pages 964-980.
    9. Vesna Karadzic & Bojan Pejovic, 2021. "Inflation Forecasting in the Western Balkans and EU: A Comparison of Holt-Winters, ARIMA and NNAR Models," The AMFITEATRU ECONOMIC journal, Academy of Economic Studies - Bucharest, Romania, vol. 23(57), pages 517-517.
    10. Li, Qinyun & Gaalman, Gerard & Disney, Stephen M., 2023. "On the equivalence of the proportional and damped trend order-up-to policies: An eigenvalue analysis," International Journal of Production Economics, Elsevier, vol. 265(C).
    11. 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.
    12. Jennifer Castle & David Hendry, 2012. "Forecasting by factors, by variables, or both?," Economics Series Working Papers 600, University of Oxford, Department of Economics.
    13. Niels Haldrup & Oskar Knapik & Tommaso Proietti, 2016. "A generalized exponential time series regression model for electricity prices," CREATES Research Papers 2016-08, Department of Economics and Business Economics, Aarhus University.
    14. 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).
    15. Petropoulos, Fotios & Apiletti, Daniele & Assimakopoulos, Vassilios & Babai, Mohamed Zied & Barrow, Devon K. & Ben Taieb, Souhaib & Bergmeir, Christoph & Bessa, Ricardo J. & Bijak, Jakub & Boylan, Joh, 2022. "Forecasting: theory and practice," International Journal of Forecasting, Elsevier, vol. 38(3), pages 705-871.
      • Fotios Petropoulos & Daniele Apiletti & Vassilios Assimakopoulos & Mohamed Zied Babai & Devon K. Barrow & Souhaib Ben Taieb & Christoph Bergmeir & Ricardo J. Bessa & Jakub Bijak & John E. Boylan & Jet, 2020. "Forecasting: theory and practice," Papers 2012.03854, arXiv.org, revised Jan 2022.
    16. M A Rahman & B R Sarker & L A Escobar, 2011. "Peak demand forecasting for a seasonal product using Bayesian approach," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 62(6), pages 1019-1028, June.
    17. Tiantian Tu, 2025. "Bridging Short- and Long-Term Dependencies: A CNN-Transformer Hybrid for Financial Time Series Forecasting," Papers 2504.19309, arXiv.org.
    18. Naragain Phumchusri & Poonnawit Suwatanapongched, 2023. "Forecasting hotel daily room demand with transformed data using time series methods," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 22(1), pages 44-56, February.
    19. 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.
    20. Klymenko, Nataliia & Voronenko, Iryna & Nehrey, Maryna & Rogoza, Konstyantyn & Rogoza, Nataliy, . "Risk assessment of shock periods and investment attractiveness of agroholdings of Ukraine," Agricultural and Resource Economics: International Scientific E-Journal, Agricultural and Resource Economics: International Scientific E-Journal, vol. 9(2).
    21. 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.

    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.