Mean
Median & Quartiles
Spreadsheets
M.A.D.
Vocabulary
100
What is another word for the "mean"?
The "average"
100
What is the first step to find the median?
Sort your data from smallest to largest or largest to smallest
100
What symbol allows you to input a formula for a cell?
=
100
What is the first step in finding the MAD?
Find the mean
100
What is the definition of the sum?
The result when adding numbers together
200
What number is right between 12 and 13?
12.5
200
Find the median of the following list:
6, 5, 11, 13, 24, 12, 14
12
200
What function will find the mean of a list of numbers in a spreadsheet?
=average
200
What is the second step in finding the MAD?
Find each point's distance from the mean
200
What is the symbol for "sum"?
Sigma
300
Find the sum of the following list:
6, 5, 11, 13, 24, 12, 14
85
300
How many quartiles are in 1 data set?
4
300
What does the "$" do when using it in a function?
It locks the cell so that it doesn't change if you drag the formula to more cells
300
What is the last step in finding the MAD?
Find the mean of each data's distance from the mean
300
How do you find the mean?
Divide the sum by the amount of numbers
400
Find the mean of the following list:
6, 5, 11, 13, 24, 12, 14
12.1
400
How do you calculate the IQR?
Q3 - Q1
400
Write the function that adds up all of the numbers shown
=sum(a1:a9)
400
Which dot plot has a higher MAD value? A or B?
B - it has a higher spread
400
How do you find the median?
Find the middle number in a list of arranged data (if there is a tie - find the mean of the two middle numbers)
500
Find the mean of the dot plot
30.47 minutes
500
Find the quartiles of the following data set:
1, 0, 9, 10, 9, 2, 22, 15
Min: 0
Q1: 1.5
Q2: 9
Q3: 12.5
500
Write the function that finds the average of the data shown
=average(a1:a9)
OR
=sum(a1:a9)/9
500
Calculate the MAD of the following list:
1, 2, 3, 4, 5, 6
0.5
500
What are the 5 values in the 5-number summary?
Min, Q1, Q2, Q3, and Max