Solving Problems of Normal Distribution using MS Excel.
- Subject:
- Mathematics
- Statistics and Probability
- Material Type:
- Diagram/Illustration
- Homework/Assignment
- Interactive
- Author:
- Sagar Khairnar
- Date Added:
- 05/16/2020
Solving Problems of Normal Distribution using MS Excel.
Middle and High School educators across Lebanon County, Pennsylvania developed lesson plans to integrate the Pennsylvania Career Education and Work Standards with the content they teach. This work was made possible through a partnership between the South Central PA Workforce Investment Board (SCPa Works) and Lancaster-Lebanon Intermediate Unit 13 (IU13) and was funded by a Teacher in the Workplace Grant Award from the Pennsylvania Department of Labor and Industry. This lesson plan was developed by one of the talented educators who participated in this project during the 2019-2020 school year.
In Stella, students act as astronomers, studying stars in a “patch” of sky in our own galaxy. Using simulated data from spectroscopy and other real-world instrumentation, students learn to determine star positions, radial velocity, proper motion, and ultimately, degree of parallax. As students establish their expertise in each area, they earn “badges” that allow them greater and easier access to the data. The Teacher Guide includes background on stellar spectroscopy (the brightness of a star), photometry (the breakdown of light from a star), and astrometry (measuring the positions of stars).
In this dynamic data science activity, students use data to build binary trees for decision-making and prediction. Prediction trees are the first steps towards linear regression, which plays an important role in machine learning for future data scientists. Students begin by manually putting “training data” through an algorithm. They can then automate the process to test their ability to predict which alien creatures are sick and which are healthy. Students can “level up” to try more difficult scenarios.
Additional practice problems related to Levels of Measurement.
*Supplemental resource to A.Holmes derivative statistics text.*
Additional practice problems related to tests of two independent population variances.
*Supplemental resource to A.Holmes derivative statistics text including adapted and revised problems.*
*Supplemental materials to A.Holmes derivative text.*
Introduction to the calculation of weighted means including demonstration and practice problems.
*Supplemental materials to A.Holmes derivative text.*
Material includes problems to help practice the mechanics of calculating the standard deviation for sets of population and sample data.
*Supplemental materials to A.Holmes derivative text.*
An introduction to Pearson's Coefficient of Skewness including demonstration and practice problems.
*Supplemental resource to A.Holmes derivative text.*
Additional practice problems related to Measures of Location: Quartiles, Percentiles, & IQR Values.
Includes demonstration of MS Excel commands.
*(2.2) Supplemental resource to A.Holmes derivative statistics text.*
Calculation of a mean and variance for discrete random variables.
*(4.0) Supplemental resource to A.Holmes derivative text.*
Additional demonstration and practice problems related to the Central Limit Theorem.
*Supplemental Resource to A.Holmes Derivative Statistics Text.*
Introductory explanation of process capability.