QI Macros

Improvement Insights Blog

Posts tagged "QI Macros"

How Many Green and Black Belts Do You Need?

A QI Macros customer recently asked: ” What is a reasonable and productive ratio of Lean or Six Sigma expert (LSSBB, for example) to staff for a healthcare organization that is starting the journey?”

The general consensus I can find online about Six Sigma belts/employees is:
1 BB/100 employees
3 GB/100 employees

I think these numbers are designed to keep Six Sigma training companies in business.

Depending on the size of a Medical center, you could use one BB and some GBs to get started. You can’t fix everything all at once, so one BB ramrodding a handful of GBs to solve key problems would be a good start.

Posted by Jay Arthur in Lean, Service, Six Sigma.

Minitab and Excel: Which Should I Use and When?

In a recent blog post, Minitab asked: “Have you ever found yourself switching back and forth between a Microsoft Excel file and Minitab Statistical Software just to complete a single analysis?”

Comparing Minitab to Excel (without QI Macros) is a bit like comparing a calculator to an abacus.

If you have the QI Macros add-in for Excel, you don’t have to switch. You can do everything in Excel.

Creating Graphs with Raw Data Easily

The blogger says: “Just try creating a Pareto Chart in Excel…I dare you!”

I’ll take that dare. If you have a column of defects (below), just click on the title for the column and choose the QI Macros Pareto Chart.

Posted by Jay Arthur in QI Macros.