Tip: Choose Save as PDF in the print dialog to download. Use A4 paper size.
Shade in the A or B circle for each question.
Draw a line connecting each item on the left to its match on the right.
| Left column | Right column | |
|---|---|---|
| 1Sales: 5, 8, 12, 15 | A=MIN(B2:B8) | |
| 2Ages: 10, 11, 10, 11, 45 | B=MAX(B2:B8) | |
| 3Finding the highest value in a set of data | CA trend going up, because each number is bigger than the one before | |
| 4Finding the lowest value in a set of data | DThe number 45 is an outlier because it stands out from the rest | |
| 5Temps: 20, 22, 24, 26 - 'The trend is going down.' | EThe numbers get bigger each time, so the trend is going up, not down. | |
| 6Class A average 8, Class B average 6 - 'Class B scored higher.' | FClass A has the bigger average, so Class A scored higher when comparing the groups. |
Complete each line of code by filling in the missing parts.
Shade in the letter of the line that contains an error.
pattern, trend, outlier — Look for patterns and trends in data, like highest, lowest, going up or down. An outlier is a value that stands out from the rest. Compare groups to see differences.Highest score: =MAX(B2:B8)Lowest score: =MIN(B2:B8)Data: 4, 5, 6, 5, 50
The number 50 is an outlierScores: 3, 5, 7, 9
The trend is going upClass A: =AVERAGE(B2:B8)
Class B: =AVERAGE(C2:C8)