Home »
Blog » QI Macros » Page 26
Improvement Insights Blog
Latest "QI Macros" Posts
Downloaded and installed Excel for the iPad. It’s provides basic Excel functionality. As expected, it will handle QI Macros charting templates, but won’t run macros. https://www.qimacros.com/store/?cat=14
To get the full functionality of the QI Macros or to run any Visual Basic addins, you’ll need a Windows 8 tablet running Excel 2010 or Excel 2013.
I tried several Win 8 tablets.
The Surface Pro is fast, but heavy and runs warm because of the I5 processor. I didn’t love the keyboard.
I tried the Samsung, but it had an idiot light that blinked when closed that ate 5% of the battery every day.
Continue Reading "Excel App for the iPad and QI Macros"
Posted by Jay Arthur in QI Macros.
Vanity metrics let you feel good about your business.
Productivity metrics tell you the truth about your business. From Running Lean, by Ash Maurya via the Lean Startup, here’s some productivity metrics:
- Acquisition (how do users find you?)
- Activation (do they have a great first experience?)
- Retention (do they return?)
- Revenue (how do you make money?)
- Referral (do users tell others?).
Most people want to feel good, so they often select metrics that let them feel good. The people that excel choose metrics that tell them where and how to improve.
You can chart either one with the QI Macros, but vanity charts aren’t going to help you improve.
Continue Reading "Vanity or Productivity Metrics"
Posted by Jay Arthur in Lean, QI Macros.
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.
Seth Godin’s blog brought this data to my attention: http://www.nextbigfuture.com/2011/03/deaths-per-twh-by-energy-source.html.
There’s lots of ways to display it, but I thought it would be fun to look at as Pareto charts.
Deaths from nuclear power are small compared to the power produced. Coal and oil are still the heavy hitters in the mortality department.
Continue Reading "Deaths by Power Source Data"
Posted by Jay Arthur in QI Macros.
Use a histogram to determine the distribution of measurable data and the capability (i.e., the level of performance the customers can consistently expect) of the process. Process capability is determined using your data and the customer’s upper specification (USL) and lower specification limits (LSL).
Its easy to create a histogram in Excel using the QI Macros. See
http://www.youtube.com/user/QIMacros#p/a/u/2/tqlFKtmAxbU
Continue Reading "Create a Histogram in Excel Using the QI Macros"
Posted by Jay Arthur in QI Macros.
Control Charts show your data as a line graph with average and sigma lines to determine stability. The average and sigma lines are calculated from your data. It’s easy to create a control chart in excel using the QI Macros. See http://www.youtube.com/watch?v=5TVKz4OQTp0
Continue Reading "Use Control Charts to Determine Process Stability"
Posted by Jay Arthur in QI Macros.
