Most of the time when you run statistics, you want to use statistical software (or a free tool like R). These tools are built to do calculations like t-tests, chi-square tests, correlations, and so on. Excel isn’t meant for data analysis. But that doesn’t mean you can’t do it. Unfortunately, Excel’s statistical functions aren’t always intuitive. And they usually give you esoteric results. So instead of using stats functions, we’re going to use the go-to Excel statistics add-in: the Data Analysis Toolpak. The Toolpak, despite its rather unfortunate spelling, includes a wide range of useful statistics functionality. Let’s see what...
Read the full article: How to Do Basic Data Analysis in Excel
from MakeUseOf http://ift.tt/2EenoDp
via IFTTT
0 comments: