Advantages and disadvantages comparison of time-series forecast computing via microsoft excel and three different SAS products

Rahardja, Dewi

doi:10.47974/JSMS-983

Open Access Research Article

Advantages and disadvantages comparison of time-series forecast computing via microsoft excel and three different SAS products

^*Dewi RahardjaCorresponding authorrahardja@gmail.comDepartment of DefenseU. S, MD 20755, Fort Meade,, U.S.A.View full profile →

* Corresponding author · click or hover a name for details

pp. 769–784Vol. 27Issue 4May 2024DOI: 10.47974/JSMS-983XML

Received:: 08 Feb 2022
Published Online:: 27 May 2024
Article type:: Research Article
Language:: EN
Article no.:: JSMS-983
Pages:: 769–784

Abstract

Forecasts are never as accurate as organizations need or desire them to be. Yet, lots of forecasting consultants and software vendors are willing to take organizations money in exchange for unfulfilled promises (SAS, 2019). Hence, for users and/or organizations to manage their expectations, we emphasized that it is unrealistic to expect any computation software to produce perfect outputs or forecasts since nothing works perfectly in this world. Therefore, in this paper, we compared the advantages and disadvantages (pros and cons) of Time-Series (TS) forecast computation via the Microsoft Excel (FORECAST.ETS) built-in function and the three different SAS products, prescribed as a roadmap (Rahardja, 2020). Those three SAS products are the SAS Forecast Studio 14.1 drop-down menu, the SAS/ETS 9.4 drop-down menu, and the SAS/ETS 9.4 manual coding procedures or PROCs. Finally, we summarize our conclusion and recommendations for users and/or organizations.

Keywords

Time series Excel SAS SAS/ETS SAS forecast studio Forecast Software

Subject Classifications

(2010) 03D7865D1968Uxx68Q85

References

[1] Box, G.E.P., and Jenkins, G.M. (1976). Time Series Analysis: Forecasting and Control. John Wiley & Sons, Inc., Hoboken, New Jersey.
[2] Brown, R.G. (1959). Statistical Forecasting for Inventory control. McGraw-Hill: New York, NY.
[3] Brown, R.G. (1962). Smoothing, Forecasting and Prediction of Discrete Time Series. Prentice Hall: New Jersey, NJ.
[4] De Gooijer, J.G., and Hyndman, R.J. (2006). 25 years of Time Series Forecasting. International Journal of Forecasting, Vol. 22, No. 3, pp. 443–473.
[5] Fomby, T.B. (2008). Exponential Smoothing Models. Class Notes Version 6. Department of Economics. Southern Methodist University, Dallas, TX, June 2008.
[6] Gardner, E. S., and McKenzie, E. (1985). Forecasting trends in time series. Management Science, Vol. 31, No. 10, pp. 1237–246. https://doi.org/10.1287/mnsc.31.10.1237.
[7] Harvey, A.C. (1989). Forecasting, Structural Time Series Models, and the Kalman Filter. Cambridge University Press.
[8] Holt, C. E. (1957). Forecasting seasonals and trends by exponentially weighted averages (O.N.R. Memorandum No. 52). Carnegie Institute of Technology, Pittsburgh, USA. https://doi.org/10.1016/j.ijforecast.2003.09.015.
[9] Hyndman, R.J., and Athanasopoulos, G. (2018). Forecasting Principles and Practices. Monash University, Australia. https://otexts.org/fpp2/.
[10] Fried R., George A.C. (2011). Exponential and Holt-Winters smoothing. In: Lovric M. (eds) International Encyclopedia of Statistical Science. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-04898-2_24.
[11] Chatfield, C. (1978). The Holt-Winters Forecasting Procedure. Journal of the Royal Statistical Society. Series C (Applied Statistics), Vol. 27, No. 3, pp. 264-279. https://doi.org/10.2307/2347162.
[12] Levenberg, Kenneth (1944). A Method for the Solution of Certain Non-Linear Problems in Least Squares. Quarterly of Applied Mathematics, Vol. 2, No. 2, pp. 164–168.
[13] Marquardt, Donald (1963). An Algorithm for Least-Squares Estimation of Nonlinear Parameters. SIAM Journal on Applied Mathematics, Vol. 11, No. 2, pp. 431–441. https://doi.org/10.1137/0111030.
[14] Sypsas, P.T. (1989). Identifying Patterns in Multiple Time Series Data. Journal of Information and Optimization Sciences, Vol. 10, No. 3, pp. 471–494.
[15] Winters, P. R. (1960). Forecasting sales by exponentially weighted moving averages. Management Science, Vol. 6, No. 3, pp. 324–342.
[16] Rahardja, D. (2020). Statistical methodological review for time-series data. Journal of Statistics and Management Systems, Vol. 23, No. 8, pp. 1445–1461. https://doi.org/10.1080/09720510.2020.1727618.
[17] SAS Institute Inc. (2019). What Managers Should Know. Cary, NC: SAS Institute Inc. Retrieved from: https://www.sas.com/en/whitepapers/management-forecasting-104529.html.
[18] Microsoft Support (2021). FORECAST.ETS function. © Microsoft 2021. Retrieved from: https://support.microsoft.com/en-us/office/forecast-ets-function-15389b8b-677e-4fbd-bd95-21d464333f41.
[19] Excel 2019 Support (2019). What’s new in Excel 2019 for Windows. © Microsoft 2021. Retrieved from: https://support.microsoft.com/en-us/office/what-s-new-in-excel-2019-for-windows-5a201203-1155-4055-82a5-82bf0994631f.
[20] Rahardja, D. (2021a). Statistical Time-Series Forecast via Microsoft Excel (FORECAST.ETS) Built-In Function. Journal of Research in Applied Mathematics, Vol. 7, No. 11, pp. 69–73.
[21] SAS Institute Inc. (2015). SAS® Forecast Studio 14.1: User’s Guide. Cary, NC: SAS Institute Inc. Retrieved from: https://support.sas.com/documentation/onlinedoc/forecast/14.1/fsug.pdf.
[22] Rahardja, D. (2021b). Statistical Computing for Time-Series Forecasts via SAS Forecast Studio. International Journal of Applied Science and Mathematics, Vol. 8, No. 4, pp. 38–45.
[23] SAS Institute Inc. (1995). SAS manual SAS/ETS Software: Time series forecasting system, Version 6, First Edition: 225–235. Cary, NC: SAS Institute Inc.
[24] SAS Institute Inc. (2013). Base SAS® 9.4 Procedures Guide: Statistical procedures, Second edition. Cary, NC: SAS Institute Inc.
[25] SAS Institute Inc. (2017). SAS/ETS® 14.3 User’s Guide. Cary, NC: SAS Institute Inc.
[26] SAS Institute Inc. (2002), SAS/ETS User’s Guide, Version 9, Cary, NC: SAS Institute Inc.
[27] SAS/ETS Software (2002). SAS/ETS main webpage. SAS support website: https://support.sas.com/rnd/app/ets/index.html#s1=6.
[28] SAS ® Help Center (2017). The ESM Procedure. Copyright © SAS Institute Inc. All rights reserved. SAS® 9.4 and SAS® Viya® 3.3 Programming Documentation. SAS Documentation website: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.3/etsug/etsug_esm_syntax02.htm.
[29] SAS Institute Inc. (2014). SAS/ETS® 13.2 User’s guide: The ESM procedure, Chapter 14, pp. 810–839. Cary, NC: SAS Institute Inc.
[30] SAS Institute Inc. (2018). SAS/ETS® 15.1 User’s guide: The ARIMA procedure, Chapter 7, pp. 186–305. Cary, NC: SAS Institute Inc.
[31] SAS Institute Inc. (2014). SAS/ETS® 13.2 User’s guide: The UCM procedure, Chapter 34, pp. 2304–2412. Cary, NC: SAS Institute Inc.
[32] Root-mean-square deviation (RMSE), Wikipedia (2021). Retrieved from: https://en.wikipedia.org/wiki/Root-mean-square_deviation.
[33] Mean-squared error (MSE), Wikipedia (2021). Retrieved from: https://en.wikipedia.org/wiki/Mean_squared_error.
[34] Mean Absolute Percentage Error, MAPE (2000). In: Swamidass P.M. (eds) Encyclopedia of Production and Manufacturing Management. Springer, Boston, MA. Retrieved from: https://doi.org/10.1007/1-4020-0612-8_580.
[35] Mean absolute difference (MAD), Wikipedia (2021). Retrieved from: https://en.wikipedia.org/wiki/Mean_absolute_difference.
[36] Akaike Information Criteria (AIC), Wikipedia (2020). Retrieved from: https://en.wikipedia.org/wiki/Akaike_information_criterion.
[37] Akaike, H. (21 December 1981), “This Week’s Citation Classic” (PDF), Current Contents Engineering, Technology, and Applied Sciences, Vol. 12, No. 51, pp. 42 [Hirotogu Akaike comments on how he arrived at AIC].
[38] Schwarz Information Criteria (SIC), Wikipedia (2020). Retrieved from: https://en.wikipedia.org/wiki/Bayesian_information_criterion.
[39] Bhat, H. S., and Kumar, N (2010). On the derivation of the Bayesian Information Criterion. Archived from the original on 28 March 2012. Retrieved from: https://web.archive.org/web/20120328065032/http://nscs00.ucmerced.edu/~nkumar4/BhatKumarBIC.pdf.
[40] Findley, D. F. (1991). “Counter examples to parsimony and BIC”. Annals of the Institute of Statistical Mathematics, Vol. 43, No. 3, pp. 505–514. https://doi.org/10.1007/BF00053369.
[41] Kass, R. E.; Wasserman, L. (1995). “A reference Bayesian test for nested hypotheses and its relationship to the Schwarz criterion”. Journal of the American Statistical Association, Vol. 90, No. 431, pp. 928–934. https://doi.org/10.2307/2291327. JSTOR 2291327.
[42] Hannan, E. J., and B. G. Quinn (1979). The Determination of the order of an autoregression. Journal of the Royal Statistical Society, Series B, Vol. 41, pp. 190–195.
[43] Hannan-Quinn Information Criteria (HQC), Wikipedia (2020). Retrieved from: https://en.wikipedia.org/wiki/Hannan%E2%80%93Quinn_information_criterion.
[44] Programming Language Generations, Wikipedia (2021). Retrieved from: https://en.wikipedia.org/wiki/Programming_language_generations.
[45] Fourth-generation programming language (4GL), Wikipedia (2021). Retrieved from: https://en.wikipedia.org/wiki/Fourth-generation_programming_language.
[46] Third-generation programming language (3GL), Wikipedia (2021). Retrieved from: https://en.wikipedia.org/wiki/Third-generation_programming_language.
[47] Fifth-generation programming language (5GL), Wikipedia (2021). Retrieved from: https://en.wikipedia.org/wiki/Fifth-generation_programming_language.
[48] Graphical User Interface (GUI), Wikipedia (2021). Retrieved from: https://en.wikipedia.org/wiki/Graphical_user_interface.
[49] Second-generation programming language (2GL), Wikipedia (2021). Retrieved from: https://en.wikipedia.org/wiki/Second-generation_programming_language.
[50] First-generation programming language (1GL), Wikipedia (2021). Retrieved from: https://en.wikipedia.org/wiki/First-generation_programming_language.
[51] SAS Institute Inc. (2014). SAS/ETS® 13.2 User’s guide: The X11 procedure, Chapter 36, pp. 2606–2665. Cary, NC: SAS Institute Inc.

Views: 274Downloads: 87Citations: 1