July 10, 2006

This new archive of macros will accompany the 4th edition of my Excel Manual for Moore's The Basic Practice of Statistics, to be published in late summer 2006.

July 16, 2005

This zip archive contains macros developed and used in Professor Hoppe's Statistics 1cc3 at McMaster University to facilitate the teaching of statistics with Excel. They are also used in his Excel Manual for Moore's The Basic Practice of Statistics, 3rd edition (2003) W. H. Freeman, NY and are made available to those who have adopted this book. These macros complement the Analysis Toolpak.

Thirty macros are in the archive and some have appeared elsewhere under different names. For instance there are two identical macros for carrying out a one-sample t-test 1zT_BPS03.xls and 1zt.xls. All are included for the convenience of students who are using earlier editions of the manual. Some macros are new.

The regression to the mean macro S1cc3_corr.xls simulates 1000 pairs of observations (x, y) from a population with a correlation given by a parameter "rho" (Greek letter). It draws the line of equal percentiles and also the regression line. The user can change the value of rho with the slider. Each time the sample is taken, the value of the correlation r computed from the sample is shown. Observe that r is close to rho but does vary from sample to sample. Repeated use of macro shows how scatterplots with different correlations might appear.

The sampling simulation macro samsim.xls showing histograms of 1000 SRSs of size 100 from a population. User can change the population proportion.

The macro gbmsim.xls simulates stock market prices using geometric Brownian motion.

From time to time additional macros will be made available here. They are designed mainly for teaching purposes use and have limited error checking ability.

If you have any questions or suggestions for other macros please contact me.

September 30, 2004. If you encounter a run-time error in the boxplot macro using the RUN button, then access the macro from the menu Tools --> Macros --> bp--- open_dialog_box. Let me know what version of Excel and OS you are using.

A Few Lottery Clips in the Media

Fred M. Hoppe
July 10, 2006