Loading the lesson
Loading the lesson
Search AllRounder.ai
Search the courses, subjects, tracks, games and features, or jump straight to a page.
Search the courses, subjects, tracks, games and features, or jump straight to a page.
2 cards from this section. Quick, good the night before a test.
What is the syntax for the AVERAGE function?
Think about how functions are usually written in spreadsheets.
What would =AVERAGE(C1:C5) calculate?
Remember, 'C1:C5' refers to all cells in that range.
What does the AVERAGE function calculate?
Think about what 'average' usually means in statistics.
True or False: The AVERAGE function considers blank cells in calculations.
Consider how averages are calculated only from the numbers present.
You have the following numbers in a dataset: 5, 10, 15, 20, 1, and 50. Calculate the average, discuss how the number 50 affects the average.
Consider what happens when you remove outliers.
In a survey, the following ratings were received: 1, 4, 4, 4, 5, 2, 3. What does the average indicate about satisfaction levels?
Sum all scores and divide by how many were given.
5 more questions in this section. Enroll free to practise them all.
Enroll free