Latest "Excel" Posts

Bad at Math?

At the IHI 28th Forum in Orlando, one visitor to our exhibit booth said: “I’m bad at math.” She was worried about needing to learn formulas. I hear this same concern from most people thrust into quality improvement. I told her: “You don’t need to know formulas. You just need to know how to select […]

Posted by Jay Arthur in Excel, QI Macros, Six Sigma.

Data Visualization and Exploration In Excel

You can use Excel’s data formatting, commenting and filtering tools to help visualize and clarify your data. Highlighting: Select cells and click on Home-Fill Color to highlight cells: Commenting: To add comments to any cell, click on Data-Insert Comment: Subset: To select a subset of your data, click on Data-Filter and select the desired content: Excel will simplify […]

Posted by Jay Arthur in Excel, Six Sigma.

What’s Wrong with the New Excel 2016’s Box and Whisker Plot?

Microsoft added a box and whisker plot to Excel 2016, but it’s not everything you might hope for. Here’s an Excel 2016 box and whisker plot: You might notice that the whiskers have a crossbar on the end. It seems to have a spare “x” in the middle of each box and it’s a little hard […]

Posted by Jay Arthur in Excel, QI Macros, Six Sigma, Statistics.