WHAT ARE INFOGRAPHICS?
Visual Representation of Information A way to communicate Information more effectively Makes information (Numbers, Data Statistics, etc..) easier for audience to “read/visualize”
We may have only a short attention span Information overload Easy to understand Visual retention is better than reading retention Images are more appealing
INFOGRAPHICS : WHAT AND HOW?
What do they convey? Timeline Informational Survey results, etc. How? Graphs/Charts Tables Diagrams/Maps Blend Text and Images Videos, etc.
HOW TO USE INFOGRAPHICS? To advocate an issue To show the status of an indicator To compare indicators To demonstrate correlations To illustrate trends, etc.
TO ADVOCATE AN ISSUE
TO SHOW THE STATUS OF AN INDICATOR
TO COMPARE INDICATORS
TO DEMONSTRATE CORRELATIONS
TO ILLUSTRATE TRENDS
INFOGRAPHICS USING EXCEL
Frequency Tables and Histograms Charts : create and format charts Conditional Formatting Sparklines Excel Graphics
Shows how many observations fall in various categories(bins) Can be represented in a Frequency Table To obtain a Frequency Table for any given data, we must first choose appropriate number of bins Each bin defines a “slot” where some values may fall in There is no set rule for choosing no of bins (good practice is 8 to 15) Need enough categories to get a meaningful distribution, but too many categories will result in few observations per category
A FREQUENCY TABLE OF MARKS OBTAINED
Mark Range (Bins) 1-2 3-4 5-6 7-8 9-10
2 15 25 18 5
A histogram is the graphical analog of a...