3.5 - Data analysis tools

Question 1

list the data analysis tools

Answer 1

Data tables - (e.g database table of patients)

Visualisation of data (e.g pie chart showing sales of five leading trainers)

Trend and Pattern identification
(e.g a line graph of last year’s sales per month)

Data cleaning
(e.g removing customers who have not made a purchase in the last two years)

Geographic information system/location mapping
(e.g tracking the movement of shipping containers around the world)

Question 2

Data tables

Answer 2

showing data in columns and rows. e.g : spreadsheet or database.

It may let you easily sort (alphabetical order, descending/ascending order) and filter data (deselect certain names/bits of analysis)

Question 3

Visualisation of data

Answer 3

e.g generating a graph or chart - it makes whole dataset easier to understand

Question 4

Trend and Pattern Identification

Answer 4

e.g extending a line graph into the future to make predictions

Question 5

Data cleaning

Answer 5

Removing outdated or inaccurate data. This should be done under the legislation - Data Protection Act

Question 6

Geographic information/ Location Mapping

Answer 6

showing movement of objects.
e.g - over a map / plane traffic / shipping containers