QMM240_W08_DataVisualization

QMM240_W08_DataVisualization - QMM 240 Graphical Data...

Info icon This preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
QMM 240 Graphical Data Visualization Statistical Methods for Business I - Lecture Notes Page: 1 Data Visualization Data visualization and analysis: Explore Gain insight Summarize, describe Communicate findings Characteristics of univariate data Measurement Units? Discrete or continuous? Missing data? Accuracy? Sampling or data collection method? Central tendency or Location Data concentration? Typical or "middle values? Dispersion How variable? Unusual values? Shape Symmetric? Skewed? Flat? Peaked? Multimodal? Example: PERatios.xls
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
QMM 240 Graphical Data Visualization Statistical Methods for Business I - Lecture Notes Page: 2 Measurement Units? Current stock price / earnings per share in last 12 months Accuracy? Discrete? Sampling? Missing data? Sorting Good first step with small datasets Finds missing data Outliers or unusual values Mechanics of Excel sorting Sort keys, asc and dsc to find missing Don't garble your dataset
Image of page 2
QMM 240 Graphical Data Visualization Statistical Methods for Business I - Lecture Notes Page: 3 A first look at Histograms A graphical representation of sorted data Let's create using Excel and Megastat Histogram 0 5 10 15 20 25 30 5 15 25 35 45 55 65 P/E Ratio Percen Central tendency ? Variation? Skewness? Unusual observations? Dot Plots Simple graphical display of n individual values of numerical data Easy to understand Not good for large samples (e.g., > 5,000)
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
QMM 240 Graphical Data Visualization Statistical Methods for Business I - Lecture Notes Page: 4 Let's create using MegaStat and then see how it's actually just an Excel X-Y scatter plot.
Image of page 4