QMM
QMM240_W08_DataVisualization

# QMM240_W08_DataVisualization - QMM 240 Graphical Data...

• Notes
• 13
• 100% (1) 1 out of 1 people found this document helpful

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

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

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

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
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)

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

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.