Making a Bell Curve and Assessing Normalcy in Google Sheets - Statistics Tutorials

  Рет қаралды 46,921

Jonathan Estey

Jonathan Estey

Күн бұрын

When you're learning about density curves, Normal distributions, and bell curves in statistics, it can be frustrating to realize that Google Sheets doesn't offer an easy, ready-made option for making density curves. This tutorial video will show you how to "trick" Sheets into making a perfect bell curve. It includes:
1. "Normalizing" your data - that is, figuring out what the relative frequencies in your data set would look like, IF that data set were a perfect Normal distribution.
2. Creating a density curve graph to show that Normalized distribution as a perfect bell curve.
3. Comparing that perfect Normalized distribution to the actual data set to see how well it actually fits, using two different methods: visual comparison, with graphs, and numerical comparisons with the Empirical Rule (a.k.a. the "68-95-99.7 Rule.")
This video is especially aimed at helping any of my Statistics students who are having trouble with our Unit 2 project, "What is Normal?"

Пікірлер
How to Make a Bell Curve in Google Sheets
10:13
Modern School Bus
Рет қаралды 22 М.
How to Create Skewed Bell Curve in Excel
9:15
ExcelDemy
Рет қаралды 16 М.
Кто круче, как думаешь?
00:44
МЯТНАЯ ФАНТА
Рет қаралды 4,1 МЛН
бабл ти гель для душа // Eva mash
01:00
EVA mash
Рет қаралды 9 МЛН
How Strong is Tin Foil? 💪
00:25
Brianna
Рет қаралды 70 МЛН
The Singing Challenge #joker #Harriet Quinn
00:35
佐助与鸣人
Рет қаралды 35 МЛН
Creating a normal distribution curve on Google Sheets
9:09
Jacob Solt
Рет қаралды 9 М.
How to Create Bell Curve with Mean and Standard Deviation
7:59
How to Create a Bell Curve chart for Performance Rating Distribution
11:05
Caripros HR Analytics
Рет қаралды 68 М.
Creating a Graph of the Standard Normal Distribution in Excel
14:23
Dr. Todd Grande
Рет қаралды 159 М.
How to Do a T-Test for Beginners
19:51
ATOMIC Teacher
Рет қаралды 718 М.
The Normal Distribution, Clearly Explained!!!
5:13
StatQuest with Josh Starmer
Рет қаралды 1,5 МЛН
Making a Frequency Table in Google Sheets - Statistics Tutorial
7:14
Confidence Interval Google Sheet
8:18
Greg Savage
Рет қаралды 1,6 М.
Кто круче, как думаешь?
00:44
МЯТНАЯ ФАНТА
Рет қаралды 4,1 МЛН