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.
Continue Reading "How Many Green and Black Belts Do You Need?"
Posted by Jay Arthur in Lean, Service, Six Sigma.
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.
Continue Reading "Minitab and Excel: Which Should I Use and When?"
Posted by Jay Arthur in QI Macros.