Please enable JavaScript.
Coggle requires JavaScript to display documents.
Unit 2 3.5 Data analysis tools (Graphs (Pie pie, Line line, Bar bar),…
Unit 2 3.5 Data analysis tools
Formulas
SUM
CountIF
Conditional formatting
E.g. If a value is equal to 1 colour blue
Change the look of a value in order to highlight it
Graphs
Pie
Line
Bar
Filters
Sort A-Z / Z-A
Sorting by genre e.g. Adventure, Music, Platformer, Puzzle, MMO & RPG.
Hide columns
Used to make a column not be able to be seen
For example column C can be hidden to not show the data on its column
Visualization of data
Using a map to find information about the location this could be crime rates, cyber attacks, etc.
Trend and pattern identification
Analysis of statistics over time, this could be customers satisfaction rate over a week during the winter or attendance of students before summer break (line graph format).
Geographic information system / location mapping
Giving a visual form of data, for example when an uber is hired, the location is shown to the user were that car is and the location of the user is shown to the driver or a map showing the vegetation and water levels of Hyde park.
Data cleaning
Removal of customer/data after 2 years, for example when a student leaves school they will remove data that is unwanted and unused by the student and that same for if someone was the leave a business.
