Essential Question: How do I analyze statistics?
Mastery Objectives:
SWBAT use basic statistics to analyze data.
SWBAT use formulas in google sheets to analyze data.
Directions: Use the spreadsheet below to calculate the statistics and answer the questions in a google doc. Make a copy of the spreadsheet to add your own formulas. Answer only the questions that are bulleted.
https://docs.google.com/spreadsheets/d/1H-LlvHjJ-Vb00-ajG5L18NE733eR4q401CkyYdUnOTE/edit?usp=sharing
Youtube video on statistical analysis in google sheets: https://www.youtube.com/watch?v=xLQgIYe5Dss
Vocabulary
Average/Mean - add up all the numbers and divide by the number count
Sum - add up all the numbers
Max - the largest number in a data set
Min - the lowest number in a data set
Mean - same thing as the average
Standard Deviation - the amount by which a single measurement differs from a fixed value such as the mean.
Median - the middle value of a data set
Mode - most occurring value in a data set
How much data is there?
In a spreadsheet, we can look at the row numbers on the left side or use the COUNTA function.
=COUNTA(Range:range)
How many rows are there of fast foods data?
What are the averages for the numeric columns?
=AVERAGE(RANGE:RANGE)
In a spreadsheet, use the AVERAGE function on the desired column.
What's the average number of calories (rounded)?
What is the average fat grams?
What are the largest and smallest values for a column?
In a spreadsheet, use the MIN/MAX functions on the desired column.
=MIN(RANGE:RANGE)
=MAX(RANGE:RANGE)
What's the smallest serving size?
What's the highest amount of sodium?
What is the highest calorie item on the list?
What is the lowest calorie item on the list?
What is the total value of a column?
=SUM(RANGE:RANGE)
In a spreadsheet, use the SUM function on the desired column.
If you ate every menu item on the list, how many calories would that be?
If you ate every menu item on the list, how much sodium would that be?
Filtering data
When we want to compute statistics on a subset of a data set, we filter the data.
In a spreadsheet, use the IF functions, like COUNTIF to count the number of rows that are equal to a value. Related functions are AVERAGEIF, SUMIF, MINIFS, MAXIFS. COUNTIF function - Microsoft Support
How many milkshakes are in the data set?
How many burgers are in the data set?
How many chicken nuggets are in the data set?
Summarizing by group
Our earlier strategies all compute a single statistic, either of the entire data set or a subset. Sometimes we want to view a summary of statistics according to some grouping of the data
In a spreadsheet, create a pivot table that groups by a particular column and shows the desired statistic for that column.Create a PivotTable to analyze worksheet data - Microsoft Support
What's the highest calorie count of the menu items from White Castle?
Which restaurant offers the menu item with the highest calorie count?
What is the lowest calorie count of the menu items at Jack in the Box?
Median -How to Find Mean, Median, and Mode on Excel: 3 Easy Methods
What is the median of the sugar content of the menu items?
What is the median of the serving size of the menu items?
Mode -How to Find Mean, Median, and Mode on Excel: 3 Easy Methods
What is the mode of sugar content of the menu items?
What is the mode of service size of the menu items?