Download Transforming & Presenting Quantitative Data: Classifications & Effective Graphs - Prof. El and more Study notes Information Technology in PDF only on Docsity! Transforming data between format Quantitative Data Two Classifications of Data Qualitative Qualitative data is data which is not numerically significant. color of cars feelings about a new product taste thoughts on the ride Quantitative Quantitative data is data which is expressed in numerical terms. number of hours worked amount spent cups of coffee drunk number of cars passing per hour http://www.hnc-business.co.uk/les04_unit5.html Good Graphical Representations: Focus attention Stimulate interest Improve message comprehension Add variety and emphasis Explain complex facts and processes Reinforce key points Make abstract ideas complete Leave a lasting impression http://docs.google.com/viewer?a=v&q=cache:0N5tv-s1hdMJ:gametlibrary.worldbank.org/FILES/74_Tips%2520for%2520using%2520gr aphics.pdf+data+presentation+techniques&hl=en&gl=us&pid=bl&srcid=ADGEESgDl8ul9HLzZ4LdAK-BXCrUv5FPnnMK2FwOacNnBBW 27EuXnWryTxFv0EalhzpJPN8LyIgsPBgXYquFEXUZiHCd1QB946QcGkH4EM6H1prDM2xW-6uG7tFM2u1KstvxlAnfK6ZC&sig=AHIEtbR1Cqt 14uLQw6GJzwCcMzdwCe0Phw Bad Graphical Representations: Bore Alienate Confuse Overwhelm Inhibit communication http://docs.google.com/viewer?a=v&q=cache:0N5tv-s1hdMJ:gametlibrary.worldbank.org/FILES/74_Tips%2520for%2520using %2520graphics.pdf+data+presentation+techniques&hl=en&gl=us&pid=bl&srcid=ADGEESgDl8ul9HLzZ4LdAK- BXCrUv5FPnnMK2FwOacNnBBW27EuXnWryTxFv0EalhzpJPN8LyIgsPBgXYquFEXUZiHCd1QB946QcGkH4EM6H1prDM2xW- 6uG7tFM2u1KstvxlAnfK6ZC&sig=AHIEtbR1Cqt14uLQw6GJzwCcMzdwCe0Phw Choosing the Best Display Tool To Show Use Data Needed Frequency of occurrence: Simple percentages or comparisons of magnitude Bar chart Pie chart Pareto chart Tallies by category (data can be attribute data or variable data divided into categories) Trends over time Line graph Run chart Control chart Measurements taken in chronological order (attribute or variable data can be used) Distribution: Variation not related to time (distributions) Histograms Forty or more measurements (not necessarily in chronological order, variable data) Association: Looking for a correlation between two things Scatter diagram Forty or more paired measurements (measures of both things of interest, variable data) http://www.qaproject.org/methods/ resstattools.html Different types of maps
Ghart/Graph
Each feature on the map is illustrated in a
chart on the map
State
GS Property
SB Income
5 tales
State
HS Property
BS Income
C5 Sales
Dot density map
Wendy Heard ESART
Census tracts
1 Dot = 250 people
Wendy Heard ESART
http://docs.google.com/viewer?a=v&q=cache:ON5tv-s1hdM):gametlibrary.worldbank.org/FILES/74_Tips%2520for%2520 using
520graphics. pdf+data+presentation+techniq ues&hl=en&gl= us&pid=bl&srcid =ADGEESgDI8ul9HLzZ4LdAK-
BXCrUv 5FPnnMK2FwOacNnBBW27EuxXnWryTxFvOEalhzp|PN8LylgsPBgXYq uFEXUZiIHCd 1QB946QcGkH4EM6H1prDM2xW-
6uG7tFM2ulKstvxlAnfK6ZC&sig=AHIEtbR1Cqt1 4 uLQw6GJzwCcMzdwCe0Phw
Quantitative Data – Not a Chart or Map http://docs.google.com/viewer?a=v&q=cache:0N5tv-s1hdMJ:gametlibrary.worldbank.org/FILES/74_Tips%2520for%2520using %2520graphics.pdf+data+presentation+techniques&hl=en&gl=us&pid=bl&srcid=ADGEESgDl8ul9HLzZ4LdAK- BXCrUv5FPnnMK2FwOacNnBBW27EuXnWryTxFv0EalhzpJPN8LyIgsPBgXYquFEXUZiHCd1QB946QcGkH4EM6H1prDM2xW- 6uG7tFM2u1KstvxlAnfK6ZC&sig=AHIEtbR1Cqt14uLQw6GJzwCcMzdwCe0Phw Tools for Making Graphical Displays MS Word Has chart and graph function Data can be entered into a table, highlighted, and turned into a graph or chart “Insert” -> “Charts” “Insert” -> “SmartArt Graphics” MS Excel Similar options to MS Word Data can be enter in Excel, highlighted, and turned into a graph or chart MS Powerpoint Similar options to MS Word and MS Excel Tables and graphics can be pasted from MS Word and MS Excel