What are some spreasheet functions
-create workshets
-create links between worksheets
-use a range of data types
-validate data
-create, edit, use charts
-Calculae descriptive statistcs using appropriate functions
-calculate using Pearson’s correlation coefficient (r)
- use lookup functions
-apply conditional formatting
-sort and filter data
-import and export data
-secure data
What are some spreadsheet calcualtions
-average
-median
-minimum
-maximum
-range (vlookup, xlookup)
-count/ frequency
-standard deviation
-sum
Pearson’s correlation co-efficient
What are the 3 electronic validation techniques for spreadsheets
Existence check, range check, type check
What is existence checking
Checking if the required field is entered and not blank
What is range checking
Checking the data is within a certain range
What is type checking
Checking if the data type entered is the right data type
What are the types of graphs in a spreadsheet
-pie
-histograms
-column
-line
-bubble
-scatter
-stream
Uses of a pie chart
-show percentages of a whole
-only represents percentage at a set point in time and does not show change over time
Uses of a histogram
-Represents the distribution of a continuous data set though plotted bars, each representing particular category or class interval
-x axis is usually ranged
Uses of column and bar graphs
Bar and Column graphs can show change over time, but it is a point in time that they are better to display.
uses of line graphs
Commonly used to display change overtime as a series of data points
uses of bubble graphs
Used when you have 3 or more variabls amd typically inlude the x, y axis and the size of the bubble
Uses of Scatter graphs/ plots
it identifies if there is a possible relationship between changes observed in 2 different variables. provides visual on strength of the relationship
Uses of stream graphs
visualises trends and patterns over time
What are the conventions of graphs
Title, key, title axis label, measurments on axis
