Data & Statistics
Measures of Center & Spread
Excel Formulas
Z-Scores & Probabilities
Problems
100

This type of statistics summarizes data using tables, charts, or averages

What is descriptive statistics?

100

These are the three main descriptors of data. 

What are shape, location, and variability? 

100
This is the formula to find the mean of a data set. 

What is =AVERAGE?

100

When asked to find a value's relative standing in comparison to the rest of the data, the question is asking for this measure. 

What is Z-score?

100

A student scores 85 on a test with μ = 75, σ = 5. Find Z. 

What is Z = 2?

200

The scale of measurement for class rank (Freshman, Sophomore, Junior, Senior). 

What is ordinal?

200

This is the shape of data when the mean is less than the median. 

What is left skewed? 

200

This is the formula to find the range of a data set. 

What is =MAX(:) - MIN(:) ?

200

You use this formula when you are given a probability and are tasked with finding the associated Z-score.

What is "=NORM.S.INV()"?

200

The normal distribution of a monthly utility bill has a mean = $97 and a standard deviation = $12. What percentage of homes have a monthly bill > $97?

What is 50%

300

A professor surveys only students in her class to represent all students at the university. This is an example of what type of bias?

What is selection bias?

300

This rule states that 68% of data is within 1 standard deviation of the mean. 

What is the Empirical Rule? 

300

This is the formula to use when asked to find the area to the right of a Z-score. 

What is = 1- NORM.S.DIST(Z, true) ? 

300

If Z = –1.5, the observation is located here relative to the mean.

What is 1.5 standard deviations below the mean?

300

SAT scores are normally distributed with a mean of 500 and a standard deviation of 100. What’s the probability a student scores above 600? 

About 16%

400

Identify the population and sample: “A company randomly surveys 200 of its 2,000 employees about job satisfaction.”

Population = all 2,000 employees; Sample = 200 surveyed employees.

400

This theorem is used when the data is skewed and not symmetric. 

What is Chebyshevs Theorem? 
400

This is the formula to calculate the Interquartile Range of a data set. 

What is = QUARTILE.EXE(:,3) - QUARTILE.EXE(:,1) ?
400

When asked to find the probability between two values, this is the Excel formula you would use to calculate that. 

What is =NORM.S.DIST(Z2,true) - NORM.S.DIST(Z1,true) ?

400

Mean = 500, SD= 150, Probability to the left is 60%. This is the X value. 

What is 538?

500

Inference about a population based on a sample is called this branch of statistics. Based on the information given, "The parameter of interest"

What is inferential statistics?

500

This part of the box plot will tell us the skewdness of the data. 

What is the median line? 

500

What are the steps to creating a complete Data Analytics table in Excel?

What is Data, Data Analytics, Input Range, Output Range, and Summary Statistics? 

500

The area to the right of Z is 10%, this is the Excel formula used to calculate the Z-Score. 

What is =NORM.S.INV(1-0.1)?

500

Coffee shop wait times are normally distributed with a mean of 4 minutes and a standard deviation of 1. What wait time marks the top 2.5% of waits?

About 6 minutes (Z = 2)

M
e
n
u