When It’s Easier to Open Data in Minitab than in Excel
On the Minitab Blog, we’ve often discussed getting data into Minitab from Excel. Here's a small sampling, in case you currently have data in Excel:
- Minitab and Excel: Making the (Data) Connection
- Linking Minitab to Excel to Get Answers Fast
- 3 Tips for Importing Excel Data into Minitab
But if your data is not in Excel to begin with, taking it into Excel to prepare it for entry into Minitab isn’t necessarily the best step. Minitab makes it easy to work with data in formats like txt, dat, and csv so that you don’t have to use more than one program.
For example, take the results of a recent study about using a wearable sensor to measure how well human subjects could move from a sitting to a standing position (Lummel et al., 2016). The data are publically available in csv format, but with an interesting twist. Although csv traditionally stands for “comma-separated values,” this data set uses semicolons as the separator between values in different variables.
If you open the data set in Excel, you’ll get something like this:
Because all of the data are opened in column A, they’re not ready to analyze. You could change all of the semi-colons to commas and reopen the data set...but it wouldn’t help. You could write formulas to separate the columns out yourself, but that’s at least 1 formula per variable, and there are 30 variables in this data set.
But if you’re planning to analyze the data in Minitab, fixing the data in Excel is unnecessary. In Minitab, you just have to do is identify that the data have column names and what the value separator is:
In this case, Minitab offers more flexibility in the data that you work with than Excel does. And once all of your data are in their correct columns, you can begin the analysis that will help you to make better decisions. Minitab makes sure that your data’s ready in just a few seconds.
For general overviews of some other ways to get data into Minitab, check out Import data into Minitab from the Minitab Support Center.
Lummel, MSc R.C. van (McRoberts BV); Walgaard, MSc S. (McRoberts BV); Ainsworth, E. (McRoberts BV) (2016): The Instrumented Sit-to-Stand Test (iSTS) has greater clinical relevance than the Manually Recorded Sit-to-Stand Test in Older Adults. DANS. http://dx.doi.org/10.17026/dans-zcp-kuj7
Rob C van Lummel, Walgaard, S., Maier, A. B., Ainsworth, E., Beek, P. J., & Jaap H van Dieën. (2016). The instrumented sit-to-stand test (iSTS) has greater clinical relevance than the manually recorded sit-to-stand test in older adults. PLoS One, 11(7), e0157968. doi:10.1371/journal.pone.0157968