Pitfalls of Excel

Greg Nelson Analytics Competencies, Healthcare Analytics

We all rely on Excel from time to time. Depending on your job role, you may use it for simple calculations, or more advanced analysis.

This article in the Washington Post points out the dangers of Excel and how common abbreviations in your industry may be misinterpreted as dates or random numbers in Excel.

When you are working with large volumes of data, it can be easy to overlook some of Excel auto-conversion. This auto-conversion could render your analysis invalid. That’s a scary prospect.

Remember that your analysis is only as good as the data that you put into it. We have enough problems getting clean data as it is. Don’t introduce software errors into the equation. Be sure to use a software package that does not perform auto-conversion. 

After all, your data should be as good coming out as it is going in.

Read the source article at The Washington Post