Using Excel to Simulate and Visualize Conditional Heteroskedastic Models
American Journal of Theoretical and Applied Statistics
Volume 7, Issue 6, November 2018, Pages: 242-246
Received: Oct. 29, 2018; Accepted: Nov. 21, 2018; Published: Dec. 18, 2018
Views 779      Downloads 86
William Henry Laverty, Department of Mathematics and Statistics, University of Saskatchewan, Saskatoon, Canada
Ivan William Kelly, Department of Educational Psychology & Special Education, University of Saskatchewan, Saskatoon, Canada
Article Tools
Follow on us
Longitudinal data are available in many disciplines, and quite often the mechanism generating the data are changing over time. These changes must be accounted for when modelling the data and subsequently drawing conclusions from the data. The three statistical models described in this article (GARCH, HMM, ARHMM) are appropriate modelling data with such changes. These three models are generalizations of a random walk. In a random walk the random changes over time have a constant distribution. The three models illustrated account for changes in the distribution of the random displacements over time. Our purpose in the article is to illustrate these three models and their intricacies using Excel. We would also contend and encourage the application of these three models to the analysis of other continuous data in fields utilizing social and medical data.
Time Series Analysis, GARCH, Hidden Markov Models (HMM), Autoregressive Hidden Markov (ARHMM), Simulation, Excel
To cite this article
William Henry Laverty, Ivan William Kelly, Using Excel to Simulate and Visualize Conditional Heteroskedastic Models, American Journal of Theoretical and Applied Statistics. Vol. 7, No. 6, 2018, pp. 242-246. doi: 10.11648/j.ajtas.20180706.17
Copyright © 2018 Authors retain the copyright of this article.
This article is an open access article distributed under the Creative Commons Attribution License ( which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
B. G. Malkiel (1973) A Random Walk Down Wall Street. W. W. Norton. New York (NY).
R. S. Tsay (2010) Analysis of Financial Time Series. Third Edition. Wiley. Hoboken (NJ).
W. H. Laverty, M. J. Miket, and I. W. Kelly. (2002). Simulation of Hidden Markov Models with EXCEL, Journal of Royal Statistical Society. Series D. 51: 31-40.
I. Visser, M. E. J Raijmakers and P. C. M Molenaar (2002) Fitting Hidden Markov Models to psychological data. Scientific Programming. 10: 185-199. DOI: 10.1109/ICMEW.2013.6618397.
G. S. Fishman (1995) Monte Carlo, Concepts, Algorithms and Applications. Springer, NewYork (NY).
M. Walker II, (2011) Hidden Markov Models for Heart Rate Variability with Biometric Applications. All Theses and Dissertations (ETDs). 491.
R. Mamon, Elliott. (2007) Hidden Markov Models in Finance. International Series n Operations Research and Management Science. Springer. New York. (NY).
W. H. Laverty, M. J. Miket, and I. W. Kelly IW. (2002) Application of Hidden Markov Models on residuals: an example using Canadian traffic accident data. Perceptual and Motor Skills. 94(3 Pt 2): 1151-6.
W. H. Laverty, M. J. Miket, and I. W. Kelly. (2002) Examination of Residuals to Vancouver Crisis Call Data by using Hidden Markov Models. Perceptual and Motor Skills. 94: 548-550.
M. Washha, A. Qaroush, M. Mezghani, and F. Sedes (2017) A Topic-Based Hidden Markov Model for Real-Time Spam Tweets Filtering. 21st International Conference on Knowledge Based and Intelligent Information and Engineering Systems, 6-8 September, Marseille, France.
B. H. Juang & L. R. Rabiner (1986) Mixture autoregressive hidden Markov models for speech signal, IEEE Transactions on Acoustics Speech and Signal Processing. 33(6): 1404 – 1413.
X. Tang. (2004). Autoregressive Hidden Markov Model with Application in an El Nin ̃o study. Master’s thesis, University of Saskatchewan, Saskatoon, Saskatchewan, Canada.
I. Stanculescu, C. K. I Williams, and Y. Freer. (2013). Autoregressive Hidden Markov Models for the Early Detection of Neonatal Sepsis. Biomedical and Health Informatics, IEEE Journal of Biomedical and Health Informatics. 18: 1560-1570. DOI 10.1109/JBHI.2013.2294692.
Science Publishing Group
1 Rockefeller Plaza,
10th and 11th Floors,
New York, NY 10020
Tel: (001)347-983-5186