Mosaic Chart - Marimekko Chart

home · products · services · search · view cart · contact  
 
  NAVIGATION        
 

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar

2253 S. Oneida
Ste 3D
Denver, CO 80224


We work with companies
that want to fire up their profits using
Lean Six Sigma

Copyright © 2011



 

Mosaic charts (a.k.a. marimekko charts) take data points and convert them into percentages and map them as a boxy bar chart. In the example below, a restaurant owner wants to know if the type of music playing in the background affects the type of wine purchased by customers.

mosaic-chart-marimekko

In this case, Italian music increases Italian wine purchases (center bar) and French music increases French wine purchases (bottom right bar), but I find this format difficult to analyze. Some argue that this is a form of chart junk that hides the information needed to make good decisions.

Pareto Chart Alternative
Instead of creating a mosaic plot, we could select the data:

mosaic-chart-marimekko-data

And run Pareto charts using the QI Macros:

multiple-pareto-charts

From these three charts, it's easy to see that the Other and French Paretos are pretty flat, meaning that music may have little or no impact on the wine selected. If we look at the Italian wine (middle pareto), however, Italian music has a significant impact on whether or not Italian wine is choosen. French music effectively kills Italian wine sales.

If we look at total wine sold, no music or Italian music sells about 12% more wine than French music:

excel-pareto-chart

This isn't evident from the Mosaic plot.

Here's My Point
There's more than one way to display data on charts. Trying to cram everything onto one chart can make it hard to decipher and hide critical information. When in doubt, use multiple charts to make the case clearly.

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma

QI Macros - One License Per Computer - Download with backup CD & User Guide (#230) $199 + S&H
QI Macros - One License Per Computer - Download Only - No Shipping or Customs Duties (#W230) $199

 

Download
QI Macros

30-Day Trial Now!


Or Buy It Now!

Unconditional
90-Day
Money-Back
Guarantee


 
home | products | services | search | sitemap | view cart | contact
QI Macros | Excel SPC Software | SPC Software Free Trial
Control Charts | c Chart | np Chart | p Chart | u Chart
ImR Chart | XmR Chart | XMedianR Chart | XbarR Chart | XbarS Chart | EWMA Chart
Anom Chart | Cusum Chart | Levey Jennings Chart | Moving Average Chart
Histograms | Pareto Chart | Scatter Plot | Run Chart
Box Whisker Plot | Dot Plot | Multivari Chart

Lean Six Sigma Training | Lean Six Sigma Training Denver
Lean Six Sigma Consulting | Lean Six Sigma Consulting Denver
Lean Six Sigma Training Systems | Do-It-Yourself Lean Six Sigma Training