Dhrumil Mehta PRO
Database Journalist, Politics @ FiveThirtyEight
(It takes a second to load, so just open it up and hang tight, thanks!)
Hello, my name is...
dm3494@columbia.edu
@dmil
Pick a number you find interesting. Copy and paste the whole snippet (including the links) into this padlet.
We will come back to this later
There are different kinds of numbers that must be interpreted and presented differently
βοΈ Identify what kind of number you're dealing with
βοΈ Understand it's limitations
βοΈ Know what kinds of questions to ask of it before reporting on it
Counts and Measurements
Summary Statistics
Probabilities
Inferential Statistics
Indexes
Scaled Numbers
a very complex kind of probabilistic number
I'm sure these aren't the only kinds of numbers...
...but they're all very different from one another
more methodological choices to vet
Let's take come back to this padlet
In the comment for the number you picked, write :
1. what kind of number it is
2. what you'd want to know about this number before your cite it in your reporting
βοΈ There are different kinds of numbers that must be interpreted and presented differently
βοΈ Statistics summarize datasets just like a paragraph can summarize a story. Some things are lost in the process.
βοΈ It's important to determine if the summary statistic does a good job of summarizing the underlying distribution before you cite it.
π» Scary Math Symbol?
π Seems fine!
Ben Orlin β Math with bad drawings
Ben Orlin β Math with bad drawings
Text
Examples
Averages are weighted by the square root of the number of polls that a particular pollster conducted for that particular type of election in that particular cycle.
So, how did the polls do in 2024? Itβs complicated | SilverBulletin
Examples
Ben Orlin β Math with bad drawings
Ben Orlin β Math with bad drawings
Examples
Ben Orlin β Math with bad drawings
Ben Orlin β Math with bad drawings
Ben Orlin β Math with bad drawings
Ben Orlin β Math with bad drawings
https://www.investopedia.com/terms/n/negative-correlation.asp
Correlation doesn't imply causation, but it does waggle its eyebrows suggestively and gesture furtively while mouthing 'look over there'.
Ben Orlin β Math with bad drawings
Ben Orlin β Math with bad drawings
Examples
Examples
Ben Orlin β Math with bad drawings
Ben Orlin β Math with bad drawings
Learning Objectives
βοΈ Use formulas in spreadsheets to calculate summary statistics (bonus: use pivot tables to do the same)
βοΈ Understanding the limitations of summary statistics
βοΈ Learn to make charts in spreadsheets
https://data4news.com/mystery-dataset/
Describe 4 mystery datasets with summary statistics...what can you tell me about these mystery data?
Calculate:
- Mean
- Median
- Mode
- Correlation
- Variance
Done?
Bonus 1: Redo the calculations in the LONG tab with a pivot table.
Bonus 2: Explore the data in the BONUS tab, tell us what you find!
Dataset 1 is done for you
Examples of how to write the formulas are in red
Median Grade: 80%
Median Grade: 80%
Median Grade: 80%
https://fivethirtyeight.com/features/al-gores-new-movie-exposes-the-big-flaw-in-online-movie-ratings/
Pearson correlation is ????
Pearson correlation is 0.9909
because there are 40 duplicate data pts in top right and bottom left corner
BE VERY CAREFUL OF SCATTER PLOTS
1977
Produce checkable artifiacts
β Hi AI, please answer this question about my data
β Hi AI, please write code to answer this question about my data
Let's look at this rolling average.
By Dhrumil Mehta
intro stats