Podcast
Questions and Answers
Which formula is used to calculate the Average of a dataset?
Which formula is used to calculate the Average of a dataset?
- COUNT(values, values)
- MODE(no1, no2...)
- MEDIAN(no1, no2...)
- AVERAGE(no1, no2...) (correct)
What is the correct formula to find the median value?
What is the correct formula to find the median value?
- MAX(no1, no2...)
- AVERAGE(no1, no2...)
- PERCENTILE(array, k)
- MEDIAN(no1, no2...) (correct)
How does Excel determine the mode when two values repeat the same number of times?
How does Excel determine the mode when two values repeat the same number of times?
- Excel goes top-down and chooses the first to find mode (correct)
- Excel chooses the highest value
- Excel goes bottom-up
- Excel chooses the second value
Which formula is used to find the maximum value in a dataset?
Which formula is used to find the maximum value in a dataset?
What does a percentile value of 25 translate to in percentage?
What does a percentile value of 25 translate to in percentage?
Flashcards are hidden until you start studying
Study Notes
Statistical Formulas
- Sample Size formula: COUNT(values, values)
- Average formula: AVERAGE(no1, no2...)
- Median formula: MEDIAN(no1, no2...)
- Mode formula: MODE(no1, no2...)
- If multiple values have the same frequency, Excel follows a top-down approach and returns the first value it encounters as the mode.
- Maximum formula: MAX(no1, no2...)
- Minimum formula: MIN(no1, no2...)
- 25th Percentile formula: PERCENTILE(array, k)
- k represents the data tile (e.g., 0.25 for the 25th percentile)
- When using PERCENTILE, the range is for baking ( unclear what this means, needs clarification)
- The notation [acb] is used for a specific range (needs clarification)
- Percentage notation: always represent as a decimal between 0 and 1, e.g., 25% is equivalent to 0.25
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.