Save
PAPER 1 - Data & Probability
Representing & Interpreting data
Spreadsheets and diagrams
Save
Share
Learn
Content
Leaderboard
Share
Learn
Created by
harry
Visit profile
Cards (8)
Spreadsheet functions
field
record
sort
sum
filter
count
average
standard deviation
Field
- a category of information stored about the data.
Record - an entry into the spreadsheet.
Sort
- used to either arrange
quantitative
data in
ascending
/ descending order or qualitative data alphabetically.
Filter
- used when you only want data to do with a specific field on the
spreadsheet
.
Count
- used to count the number of records in a particular section, for quantitative we use 'count' for qualitative we use
'countA'
.
Sum
- used to add up all the
numerical
values within a particular section.
Standard deviation
- used to find the standard deviation for a particular section.