Veronica Hupper

This activity looks at a realistic data set and walks the student through constructing a frequency table and histogram using Microsoft Excel. It should be noted that Excel is not the best software package for creating histograms, but because it one of, it not the most widely used software package for data storage and presentation in business, it is important to know how to create professional-looking and statistically accurate graphics using this tool. There are two different ways to constru

INTENDED TO BE USED IN CONJUNCTION WITH THE MS EXCEL SIMULATION WORKSHEET ON THE SAME TOPIC. This activity walks students through the logic behind the comparison between the binomial distribution and the normal distribution. In particular, it is demonstrated that in order for the binomial distribution to have an approximately mounded and symmetric distribution, np and nq must both be greater than 5. The simulation in MS Excel that goes with this exercise can be used to show this easily. Stud

This interactive Excel worksheet uses a histogram to demonstrate to students the conditions under which a normal distribution can be used to approximate binomial probabilities. Users can change the values of n and p, and the histogram will update automatically. The binomial probabilities are also updated with each change. Students will be able to clearly see when the histogram approaches a mounded and symmetric distribution. The bars of the histogram are wide enough for students to be able t

In this powerpoint presentation, the idea and properties of discrete probability distributions is introduced. These properties and how to find simple and compound probabilities from a table are demonstrated using an example. In addition, the mean, variance, and standard deviation of a discrete distribution as found using tables are covered and included in the example. The lesson concludes with an additional example left open for students to perform on their own. Submitted by Veronica Hupper

This document contains a flow chart like diagram breaking down a variable into its types and provides brief examples of each and is appropriate for AP Statistics or college level introductory statistics. It is intended that additional information be provided by the instructor to elaborate on this diagram, but students have found this simplified version easier to study and to understand the basic differences in the types of variables and levels of measurement. Submitted by Veronica Hupper