470 likes | 491 Views
Learn how to enhance the effectiveness of data presentation by improving graphs and tables. Discover key principles and techniques to optimize visual displays for meaningful insights.
E N D
Eric Rasmusen, erasmuse@indiana.edu March 10, 2014 Graphs and Tables
Uniform Crime Reports: Crime in the United States, Section IV
How can this table be improved? http://rru.worldbank.org/Documents/PapersLinks/RI%20Final%20Guatemalai.pdf
Principles of Tables 1. Keep the data-to-ink ratio high. 2. Leave out dividing lines and boxes unless you have a good reason for them. 3. Leave off repetitive, useless numbers. 4. Don't use just capital letters. 5. Circle or otherwise mark important numbers, in particular, ones you mention in the text or talk. 6. Make the table self-contained. Don't require the reader to refer to the text or a previous table. Include the source and the units of measurement. 7. Number and title every table.
Govt. % of GDP 1970 and 1979
Books by Edward Tufte The Visual Display of Quantitative Information (1983) (pictures of numbers) Envisioning Information (1990) (pictures of nouns) Visual Explanations (1997) (pictures of verbs). Beautiful Evidence A lot of this is from Tufte.
Anscombe’s Quartet: The summary statistics are all the same, but graphing them shows how they are different.
(1) Klass uses horizontal bars. Why? (2) Why is the order of the countries not alphabetical?
Female cancer rates Male cancer rates What do these maps tell us?
http://www.bcg.com/publications/files/Balancing_Act_Implementing_an_Integrated_Strategy_for_Value_Creation_Nov05.pdfhttp://www.bcg.com/publications/files/Balancing_Act_Implementing_an_Integrated_Strategy_for_Value_Creation_Nov05.pdf
http://www.edwardtufte.com/bboard/q-and-a-fetch-msg?msg_id=0000SI&topic_id=1&topic=Ask%20E%2eT%2eNew York Times, March 20, 2003, p. D1
http://rru.worldbank.org/Documents/PapersLinks/RI%20Final%20Guatemalai.pdfhttp://rru.worldbank.org/Documents/PapersLinks/RI%20Final%20Guatemalai.pdf How can this map be improved?
Principles of Graphs • 1. Keep the data-to-ink ratio high. • 2. Erase data-ink for useless data. • 3. Erase non-data ink. • 4. Don't use Moire patterns. • 5. Use boxes and grids only if they help. • 6. Don't use cute pictures that obscure what you are saying. • 7. Consider labelling individual data points of special interest. • 8. Write text horizontally, not vertically. • 9. Make the figure self-contained. Don't require the reader to refer to the text or a previous table. Include the source and the units of measurement. • 10. Number and title every figure.
Excel Charts • 1. Don’t use a legend (side box with variables being graphed) without good reason. You can often put the variable and units of measurement in the title. • 2. Don’t use sideways or vertical writing on the axes • 3. Except for dates, use a comma to separate thousands (this is an Excel option under Number). • 4. Don’t use a chart area border unless you have good reason. http://www.rasmusen.org/g492/fed-debt-chart.xls/
http://www.bcg.com/publications/files/Balancing_Act_Implementing_an_Integrated_Strategy_for_Value_Creation_Nov05.pdfhttp://www.bcg.com/publications/files/Balancing_Act_Implementing_an_Integrated_Strategy_for_Value_Creation_Nov05.pdf