TPT
Total:
$0.00
Selected
Subjects
2 results

High school statistics simulations for Microsoft Excel

Preview of Comparing Linear, Quadratic, Exponential Regressions w/Spreadsheets

Comparing Linear, Quadratic, Exponential Regressions w/Spreadsheets

Created by
Holland Math
This project incorporates spreadsheets with scatter plots and lines of best fit. It asked students to perform various regressions, such as linear, power, exponential, and logarithmic, The students are asked to generate an model to help park rangers determine the weight of black bears by using only one of three measures, neck girth, length, and chest girth. Calculating the bears weights allow the rangers to anesthetize them in order for them to care for the bears. The r values in this project
Preview of Normal Approximation to the Binomial Demonstration

Normal Approximation to the Binomial Demonstration

Created by
Veronica Hupper
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
Showing 1-2 of 2 results