Have you ever found yourself switching back and forth between a Microsoft Excel file and Minitab Statistical Software just to complete a single analysis? Which software will give me the accurate results I need quickly?
I decided to put a few important factors to the test—workflow, organization, quality focus, and help. The review below provides my own two cents on which software seems to work best in a different situations.
Microsoft Excel is a general spreadsheet software program. It is great for compiling, sorting and highlighting large amounts of data. However, it does not do as well when zeroing in on specific mathematical functions — especially in statistics. The work flow for creating graphs and advanced statistical calculations can be cumbersome.
For example, let’s say we are a pizza shop trying to determine how good we are at meeting our promise of delivering pizzas in 30 minutes or less, and comparing the results during peak and off-peak hours. In Excel, we must first summarize the data we have for Peak and Off-peak delivery times before we can create the graph.
In Minitab, we can create a Bar Chart directly from the raw data in the worksheet. Just a couple of clicks, and Minitab has the results. No need to take the added step of summing the count data ourselves. These common calculations are embedded in Minitab’s statistical and graphical analysis tools. Just try creating a Pareto Chart in Excel…I dare you!
When we begin working with a new dataset, we often need to create several different types of graphs and statistical output to get a sense of the shape and distribution of the data. Excel stores all graphs and formula results directly in the worksheet, and reflects exactly the data in the worksheet at the moment.
However, suppose you need to take a deep dive into the data and end up creating 20, 30 or 100 graphs. How can you easily sort through them all? Or change some of the data in the worksheet to compare results? How would you create a snapshot of the original graph without overwriting with the new data?
Just like Excel, Minitab allows you to tile or cascade different worksheets and graphs but the window can get pretty cluttered when you have a lot of reports. The solution in Minitab is to use the Navigator (learn more about the Minitab interface). It allows you to toggle between worksheets, graphs and statistical output. Individual reports are displayed in a list so that you can easily select the one you want to bring to the front.
Additionally, when data in a Minitab worksheet is changed or added, the graphs and statistical output do not automatically update, thereby preserving your analysis history. Check out Minitab’s options for setting graphs to Automatically Update.
While you can create pivot tables and highlight cells in Excel, Minitab’s focus is on statistics with an emphasis on quality improvement tools. This is most evident in Minitab’s Assistant menu. The Assistant menu pulls out the six main tools used in quality improvement projects: Measurement Systems Analysis (which includes Gage R&R and Attribute Agreement Analysis), Capability Analysis (including Cpk and Ppk), Graphing, Hypothesis Tests, Regression, and Control Charting. Once a menu category is chosen, the Assistant walks you through the analysis using decision trees, guidelines, and easy to understand diagnostics and reports.
In addition to the Assistant menu, Minitab also leverages common industry standards such as the AIAG standards for SPC in manufacturing and validation for pharmaceutical and medical device companies.
The help options in Excel are useful for understanding the necessary steps to complete a particular task. Unfortunately, Excel does not answer the question “Why?” Why would I choose a particular statistical analysis over another? Why am I receiving this error message? What do the results of my analysis tell me? There are myriad Excel help forums and many people contributing “answers.” How can you be sure the information you are getting is valid?
Minitab has been generating statistical output for quality professionals for 50 years (we're older than Microsoft!). Our developers and statisticians are experts in making sure Minitab provides the right answer every time and in such a way that non-statisticians can understand it. Minitab offers many additional resources, including trained statisticians on our Technical Support team, instructor-led training and e-learning to name a few.