Challenge - 5 Problems
Statistical Functions Master
Get all challenges correct to earn this badge!
Test your skills under time pressure!
📊 Formula Result
intermediate2:00remaining
Calculate the average sales
You have sales data in cells A1 to A5: 100, 200, 300, 400, 500. Which formula correctly calculates the average sales?
Attempts:
2 left
💡 Hint
Think about which function directly calculates the average value.
✗ Incorrect
The AVERAGE function calculates the mean of the numbers in the range. SUM divided by count also works but AVERAGE is simpler and clearer.
❓ Function Choice
intermediate2:00remaining
Choose the function for the middle value
Which Excel function returns the middle value in a list of numbers, summarizing the data by its center?
Attempts:
2 left
💡 Hint
The middle value is not the average but the median.
✗ Incorrect
MEDIAN returns the middle number when data is sorted, which summarizes the center of the data well.
📊 Formula Result
advanced2:00remaining
Find the most frequent value
Given the data in cells B1:B6: 3, 5, 3, 8, 3, 5, which formula returns the most frequent number?
Attempts:
2 left
💡 Hint
The most frequent value is called the mode.
✗ Incorrect
MODE.SNGL returns the value that appears most often in the range, summarizing data by frequency.
🎯 Scenario
advanced2:00remaining
Summarize data spread with a function
You want to understand how spread out your test scores are in cells C1:C10. Which function helps summarize this spread?
Attempts:
2 left
💡 Hint
Spread means how much the numbers differ from the average.
✗ Incorrect
STDEV.P calculates the standard deviation, showing how data values spread around the mean.
❓ data_analysis
expert2:00remaining
Identify the error in this formula
You want to calculate the average of numbers in D1:D5 but the formula =AVERAGE(D1:D6) is used. What is the result?
Attempts:
2 left
💡 Hint
Think about how Excel treats empty cells in average calculations.
✗ Incorrect
AVERAGE ignores empty cells, so including D6 if empty does not cause error or count as zero.