Visualizing and Understanding Probability and Statistics: Graphical Simulations Using Excel

Authors:
  • SGSheldon P. Gordon
    Sheldon P. Gordon
  • FGFlorence S. Gordon
    Florence S. Gordon

Abstract
The authors describe a collection of dynamic interactive simulations for teaching and learning most of the important ideas and techniques of introductory statistics and probability. The modules cover such topics as randomness, simulations of probability experiments such as coin flipping, dice rolling and general binomial experiments, a simulation of the Law of Large Numbers, simulations of the distributions of various sampling distributions (the mean, median, mode, and sample proportions), a simulation of confidence intervals, a simulation of hypothesis testing, and simulations for regression analysis.