# Stats and Data Quiz

## Quiz by SELKIRK, Ian

### Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

15 questions
• Q1
What are the 3 types of AVERAGE?
mean, median, mode
unpleasant, centre, modulate
grumpy, sleepy, sneezy
10s
• Q2
Which average means most common?
mean
median
mode
10s
• Q3
What does the Standard Deviation measure?
how well data meets a good standard
whether the deviation fits a standard pattern
how much variability there is in a dataset
20s
• Q4
A baseball bat and a ball cost £1.10 in total. The bat costs £1.00 more than the ball. How much does the ball cost?
50p
90p
5p
10p
10s
• Q5
At a four legged table, there are 1 grandma, 2 moms, 2 daughters and a granddaughter. How many legs are under the table?
16
10
14
12
20s
• Q6
What does a high Standard Deviation indicate?
there are a lot of values higher and/or lower than the average
there are few values higher and/or lower than the average
there is a lot of deviant data
20s
• Q7
vlookup is recommended for use in spreadsheet models
FALSE
TRUE
10s
• Q8
Safe alternatives to VLOOKUP are:
INDEX MATCH and HLOOKUP
INDEX MATCH and XLOOKUP
INDEX MATCH only
10s
• Q9
What does correlation show?
How far apart two variables are
How closely two variables are related
10s
• Q10
Pearson correlation that is negative would have a number > 0
FALSE
TRUE
10s
• Q11
Positive correlation would show in a scatter plot as an upward-sloping line
TRUE
FALSE
20s
• Q12
What will the output of this formula be?
3
100
300
1
10s
• Q13
What will this formula return?
Hello
Goodbye
20s
• Q14
What does this formula return?
Hello
Goodbye
20s
• Q15
What does this formula return if B3847=Y, C3847=Y, D3847=Y, E3847=N, F3847=Y, G3847=N, I3847=N, K3847=Funded, L3847=N, M3847=Y?
0
1
"Do not pay"
45s

Teachers give this quiz to your class