Discover Excel’s Data Analysis Toolpak
People ask me if QI Macros can generate random samples or do sampling and I say no. Excel’s Data Analysis Toolpak can already do that. Discover how:
Download my free ebook, Agile Process Innovation – Hacking Lean Six Sigma for Results.
“Hi, I’m Jay Arthur, author of “Lean Six Sigma Demystified” and QI Macros [software].
“People call in sometimes and say, ‘Do you have a tool in QI Macros to do random samples of data?’ I say, ‘No, because that’s already built into Excel. I try not to do anything Excel really does naturally.’ Most people are unaware that there’s a Data Analysis Tool Pack and you can add that into Excel and you can do things like create sample data with plus or minus so many standard deviations.


