Mohammad Salehi



Using MS Excel in Teaching Design of Experiment

pdf PDF


Choosing right software to teach an applied statistical course is very crucial. When one teaches applied statistical courses to statistics students s/he needs to use an interactive software. Instructors should communicate with the software rather getting all the statistical results by clicking tabs. The mean reason is that the instructor can simultaneously teach the techniques and the data analysis. Perhaps the most straightforward option is to use the free software R but it is not easy for average students to use R. In this paper, I will share the experience of using MS Excel in teaching Design of Experiment. I find this experience as a success one.


Interactive teaching approach, Statistical package, Problem-oriented, Technique-oriented


[1] Chatfield C. Teaching a Course in Applied Statistics, Journal of the Royal Statistical Society. Series C (Applied Statistics), Vol. 31, No. 3, 1982 pp. 272-289

[2] Goos P. and Leemans H., Journal of Statistics Education Vol.12, No 3, 2004), www.amstat.org/publications/jse/v12n3/goos.ht ml.

[3] Montgomery, D. C. Design and Analysis of Experiments, 8th edition, John Wiley & Sons, New York, 2013.

[4] Paura L., Arhipova I. Advantages and Disadvantages of Professional and Free Software for Teaching Statistics, Information Technology and Management Science, Vol. 15, 2012, pp 9-14.

[5] Singer J. D. and Willett J. B, Improving the Teaching of Applied Statistics: Putting the Data Back into Data Analysis, The American Statistician, Vol. 44, No.3, 1990, 224-230.

[6] The R Project for Statistical Computing.[Online]. Available: http://www.R-project.org/

Cite this paper

Mohammad Salehi. (2016) Using MS Excel in Teaching Design of Experiment. International Journal of Education and Learning Systems, 1, 93-98


Copyright © 2016 Author(s) retain the copyright of this article.
This article is published under the terms of the Creative Commons Attribution License 4.0