TPT
Total:
$0.00

Statistics Spreadsheet Activity - Binomial, Geometric, Poisson (2 days)

Rated 5 out of 5, based on 2 reviews
5.0 (2 ratings)
;
Mountainworks Education
61 Followers
Grade Levels
9th - 12th, Higher Education
Resource Type
Standards
Formats Included
  • Zip
  • Excel Spreadsheets
Pages
5 pages
$3.25
$3.25
Share this resource
Report this resource to TPT
Mountainworks Education
61 Followers

Description

Statistics Spreadsheet Activity - Binomial, Geometric, Poisson (2 days)

This is a 1-2 day spreadsheet activity for a Statistics class. It uses spreadsheets as a walkthrough to allow students to explore the Binomial, Geometric, and Poisson distributions, as well as create graphs of the distributions. The product includes:

6.3 Spreadsheet Activity (Also included in " Statistics Unit 6 Bundle - Discrete Probability (12 days)" and in " A Mountain of Statistics Curriculum - One Full Year Bundle")

Excel xlsx and xls file formats

Teacher instructions

Answer Key included.

*The topics covered are binomial, geometric, and poisson distributions. The documents are Excel Based, pdfs included, and completely editable. Enjoy!

**If you find this product useful, consider buying the bundle for the entire class**

***Please read the "readme" text file and End User License Agreement contained in the Product. Thank you for respecting my work***

Total Pages
5 pages
Answer Key
Included
Teaching Duration
2 days
Report this resource to TPT
Reported resources will be reviewed by our team. Report this resource to let us know if this resource violates TPT’s content guidelines.

Standards

to see state-specific standards (only available in the US).
Define a random variable for a quantity of interest by assigning a numerical value to each event in a sample space; graph the corresponding probability distribution using the same graphical displays as for data distributions.
Develop a probability distribution for a random variable defined for a sample space in which theoretical probabilities can be calculated; find the expected value. For example, find the theoretical probability distribution for the number of correct answers obtained by guessing on all five questions of a multiple-choice test where each question has four choices, and find the expected grade under various grading schemes.
Develop a probability distribution for a random variable defined for a sample space in which probabilities are assigned empirically; find the expected value. For example, find a current data distribution on the number of TV sets per household in the United States, and calculate the expected number of sets per household. How many TV sets would you expect to find in 100 randomly selected households?
Evaluate and compare strategies on the basis of expected values. For example, compare a high-deductible versus a low-deductible automobile insurance policy using various, but reasonable, chances of having a minor or a major accident.
Analyze decisions and strategies using probability concepts (e.g., product testing, medical testing, pulling a hockey goalie at the end of a game).

Reviews

Questions & Answers