![]() ![]() The process for Excel 20 is essentially the same (although all screen shots come from Excel 2010). To do any real data analysis in Excel you’ll want to activate the Analysis ToolPak. (Take a look at Part 3 for more basic but less useful statistical tools, as well as miscellaneous tools like Fourier Analysis, moving averages, exponential smoothing, random number generation, sampling, and rank and percentile.) How to Get Data Analysis in Excel 2010 or 2013 (If you’re looking for info on statistical tests for Excel, click here to check out Part 2.) This whole post should take 20 to 40 minutes. ![]() Next, we’ll talk about regression analysis ( the real thing, including multiple variables, not just fitting a line to a graph). In part 1 of this series on data analysis in Excel, I’m going to tell you how to do that. Statistical analysis in Excel is a huge pain unless you know how to enable the Analysis Toolpak.
0 Comments
Leave a Reply. |