Show trends and patterns in data using graphs and charts
Overview
Identify the graph and chart requirements for the data set to be studied with stakeholders
Remove any duplicate, inaccurate and null values to cleanse data
Select the type of graphical output required in line with requirements
Produce graph or chart of the required dataset in line with organisational procedures
Identify the form of trend the data exhibits to report trend indicators to stakeholders
Identify trend type and fit a linear trend line to visualize time series data or a smoothing trend to visualise the moving average in line with requirements
Show the trend line equation for the data to o predict future values in line with requirements
Save the graph output in the spreadsheet in line with organisational procedures
Performance criteria
You must be able to:
- Import file data into a spreadsheet
- Identify data set to be studied
- Validate data to identify non-compliant data
- Remove duplicate, inaccurate and null data
- Select the type of graphical output to apply in line with requirements
- Create graph or chart instance of the required data
- Identify the form of trend the data exhibits
- Select and fit a linear trend line to visualize time series data trend
- Select and fit a smoothing trend to data with moving average
- Format and edit a trend line as required
- Show the trend line equation for the current data
- Save the graph output in the spreadsheet
Knowledge and Understanding
You need to know and understand:
- How to import data sets from files and other spreadsheets
- What the purpose of the analysis study of the dataset is
- The graph and chart methods used to summarise, analyse and interpret numerical data and when they are appropriate
- The importance of data validation and verification and how these can be assured in spreadsheets
- How to validate and remove erroneous data
- How to use data validation to restrict the type of data entered
- How to identify and rectify problems of data duplication and redundancy
- The main data types and formats used
- The standard statistical methods that are used to fit trends to data
- How to apply basic predefined statistical methods to identify trends and patterns in data
- The key features of spreadsheet software for fitting trends to data
- How to create graphs and charts using spreadsheet functions
- How to identify the data pattern displayed by the data
- The steps involved in determining the trend line equation
- Common data validation and trend analysis error messages and how to respond to them
- How to layout and save trend analysis graphs and charts