Statistics

Please see my other Business Intelligence articles.

Leveraging descriptiven and inferential statistics to deliver a competitive, data-drive strategy.

I’ve found the following free tools to be very useful when analyzing data.

Mockaroo: Easily create large test data sets.
https://mockaroo.com/

Meta-Chart: Easily create diagrams and charts.
https://www.meta-chart.com/

Descriptive statistics leverages method to uncover and interpret patterns in data.

CHARTS, MEASURES
Chart: Area	Chart: Bar
Chart: Bar – Clustered	Chart: Bar – Stacked
Chart: Bar – Vertical	Chart: Bubble
Chart: Box and Whiskers Plot
Chart: Histogram	Chart: Histogram – Frequency Polygon
Chart: Histogram – Relative Frequency
Chart: Line
Chart: Ogive	Chart: Pie
Chart: Stem & Leaf Plots	Chart: XY Scatter Plot
Chart: XY Scatter Plot (Distribution Shapes)
Central Tendency: Mean	Central Tendency: Median
Central Tendency: Mode
Chart: Venn Diagram	Chi-Squared: Validate Results
Cumulative Frequency	Optimization
Quartile	Spread: Range
Spread: Standard Deviation	Spread: Variance
Spread: Z-Scores	Tables – Conditional-Formatting, Filters, and Charts

CONCEPTS
Analysis: A Structured Approach
Communication Options
Confounders	Design Data Tables
Distribution Outliers
Distribution Shapes	Distributions: Conditional
Distributions: Joint	Distributions: Marginal
Distributions – The Empirical Rule
Population versus Sample	Predicting Effects of Data Changes
Probability	Probability: Bayes Theorem
Probability: Independent & Dependent	Sampling Methods
Variables: Independent and Dependent	Variables: Measuring Values
Variable Relationships – Positive and Negative	Variable Types

TABLEAU
A/B Testing Grades vs. Study Tutor	Calculated Field
Clarifying Distributions with Bins	Comparing Workbooks
Formatting With Labels	Mapping Geographic Data
Styling With Colors

Inferential Statistics builds upon information produced from descriptive statistical tools to infer, or predict outcomes.

Excel
Excel: Solver