Struggling to Explain Statistics to Others?

QI Macros Draws Charts to Explain the Meaning of Statistical Tests

While it's easy to run an ANOVA or t-Test to get a p-value, it can be hard to explain to coworkers and leaders exactly what that means. That's why QI Macros creates charts as part of the statistical test results it calculates.

ANOVA Single Factor Example

Here is the output of an ANOVA Single Factor test that was run using QI Macros:

ANOVA of Keyway Data using QI Macros and Excel

The p-value (cell K13) is zero, so we can reject the null hypothesis that the means are equal (means are not different). The box and whisker plot drawn below makes this comparison even clearer. The means (near the place on the box where the colors change) are not similar. Keyway2 is high; Keyway4 is low; and Keyway's 1 and 3 are similar.

Using Control Charts to Compare Means and Variances

Select the data and use QI Macros Restacking -> Stack Columns feature to stack columns A:D into one column.

qi macros stack data feature

Next, insert a blank row between the data for each keyway.

insert blank rows

Now, select the data and choose QI Macros control chart wizard to run a control chart.

select data with blank rows

QI Macros will recalculate a new set of control limits whenever it detects a blank row in the data. The resulting XmR chart with separate control limits for each of the four keyways will show the differences in the averages as well as the wider variation in Keyway 2 and 4:

control chart

It's also easy to see that Keyways 2 and 4 have a much wider variation in the ranges.

Turn Your Statistics into Charts that Everyone Can Understand

Once you have a significant difference, it's easy to use QI Macros Box & Whisker or Control Charts to turn that difference into a chart that you can explain to anyone.

Isn't it Time to Upgrade Your Excel Charting Skills?

Stop trying to make your spreadsheets easy to read. Nobody wants to read your spreadsheet!
And stop using primitive line, pie and bar charts.
Isn't it time to graduate to Smart Charts: Control Charts, Pareto charts and Histograms?

primitive charts
Primitive Charts
smart charts
Smart Charts

Stop Struggling with Excel Charts!
Start creating Smart Charts in just minutes.

Download a free 30-day trial. Get Smart Charts for Excel now!

Other Charts Included in QI Macros for Excel