List of Excel Labs
Some of these labs were created by Dr. Laura McSweeney, the rest were created jointly by Marika Jewczyn and Steve Sawin.
- The Monty Hall game -- you are the contestant in a Monty Hall style game. Play many times to find out for yourself: Should you switch or shouldn't you?
- The red and yellow line workbook --Explore two of the most common measures of center of a distribution (indicated by a red and yellow line on the histogram) as you change the distribution.
- Standard Deviation -- Get a feel for the size of the standard deviation by adjusting the distribution and seeing how much of the distribution falls within one or two standard deviations of the mean.
- Normal Distributions --Work with a normal distribution of arbitrary mean and standard deviation.
- Test Lab --This is from Test 1, an oportunity to explore an unknown parameter and see if you can figure out how it behaves for different shapes of histograms.
- Dice Roll --Dice Rolling. This lab simulates the rolling of many (500) samples of 1, 2, 4, or 8 dice. As the sample size changes watch how the mean, standard deviation and shape of the distribution changes.
- Central Limit Theorem -- Design your own distribution and see the shape of the distribution for samples of size two, four, and eight from this population. Surprise! For large n it looks normal. But how large?
- Exploring the t-distribution --
- Exploring the One Sample Confidence Interval with Sigma Known -- Find out how changing the inputs to the calculation of the confidence interval effects the center and width of the interval.
- Exploring the One Sample Confidence Interval with Sigma Unknown -- Find out how changing the inputs to the calculation of the confidence interval effects the center and width of the interval.
- Exploring the Simplest Hypothesis Test -- In the simplest case (quantitative variable, one sample, sigma assumed known), explore how the inputs to the hypothesis test effect the final outcome (the P-value).