VCE Data Analytics U3O1 Crossword: Sourcing, validating and referencing data to Statistical analysis of data (Modules 50–91)
Name:
Date:
Class:
✎
Crossword
Read each clue and write the matching term in the grid. Numbers in brackets show the letters in each word.
1
2
3
4
5
6
7
8
9
10
Across
- 3. A line fitted through a chart's points that shows the overall direction of the data. A chart tool can add one with its equation, and the R-squared value shows how well it fits. (9)
- 5. An empty cell where data should be. Find it with a filter for blanks, then delete the row, fill it from a reliable source or exclude it so AVERAGE and COUNT are not distorted. Word 2 of: _______ _____ (5)
- 8. Finds Pearson's r for two equal-length number ranges. The result is from -1 to 1: near 1 is strong positive, near -1 is strong negative, near 0 is no linear link. Word 1 of: =______(B2:B9,C2:C9) (6)
- 9. A spreadsheet tool that limits cells to allowed entries, like a whole number from 1 to 100 or a drop-down list, and shows an error message if someone types anything else. Word 1 of: ____ Validation (4)
- 10. Word 1 of the term in 5 Across: _______ _____ (7)
Down
- 1. A spreadsheet tool that deletes rows repeating the same values in the columns you choose to compare, keeping the first match. Always keep a copy of the raw data first. Word 1 of: ______ __________ (6)
- 2. The range is the largest value minus the smallest value. It measures spread, and one outlier can make it much bigger. Word 4 of: =MAX(B2:B30)-___(B2:B30) (3)
- 4. Word 2 of the term in 1 Down: ______ __________ (10)
- 6. A message starting with # (such as #DIV/0!, #N/A, #VALUE! or #REF!) that a cell shows when a formula fails. It hints at what went wrong so you can fix the formula or data. Word 1 of: _____ _____ (5)
- 7. Text functions split text or join it. ______, RIGHT and MID take part of a value; CONCAT or & joins parts into one. This formula returns the first 3 characters of cell A2. Word 1 of: =____(A2,3) (4)
Answer Key
VCE Data Analytics U3O1 · Modules 50–91
1R
2M
3T
R
E
N
4D
L
I
N
E
M
U
N
O
P
5V
A
L
U
6E
E
I
R
7L
8C
O
R
R
E
L
9D
A
T
A
O
F
T
R
T
E
10M
I
S
S
I
N
G
Across
3TRENDLINE — A line fitted through a chart's points that shows the overall direction of the data. A chart tool can add one with its equation, and the R-squared value shows how well it fits.
5VALUE — An empty cell where data should be. Find it with a filter for blanks, then delete the row, fill it from a reliable source or exclude it so AVERAGE and COUNT are not distorted. Word 2 of: _______ _____
8CORREL — Finds Pearson's r for two equal-length number ranges. The result is from -1 to 1: near 1 is strong positive, near -1 is strong negative, near 0 is no linear link. Word 1 of: =______(B2:B9,C2:C9)
9DATA — A spreadsheet tool that limits cells to allowed entries, like a whole number from 1 to 100 or a drop-down list, and shows an error message if someone types anything else. Word 1 of: ____ Validation
10MISSING — Word 1 of the term in 5 Across: _______ _____
Down
1REMOVE — A spreadsheet tool that deletes rows repeating the same values in the columns you choose to compare, keeping the first match. Always keep a copy of the raw data first. Word 1 of: ______ __________
2MIN — The range is the largest value minus the smallest value. It measures spread, and one outlier can make it much bigger. Word 4 of: =MAX(B2:B30)-___(B2:B30)
4DUPLICATES — Word 2 of the term in 1 Down: ______ __________
6ERROR — A message starting with # (such as #DIV/0!, #N/A, #VALUE! or #REF!) that a cell shows when a formula fails. It hints at what went wrong so you can fix the formula or data. Word 1 of: _____ _____
7LEFT — Text functions split text or join it. ______, RIGHT and MID take part of a value; CONCAT or & joins parts into one. This formula returns the first 3 characters of cell A2. Word 1 of: =____(A2,3)