excel not loading data analysis toolpak 2016

It is powerful, it has a very simple user interface, and it is very easy to learn. 1 The advantages of StatTools should be apparent to users of our books. Then around the year 2000, Palisade Corporation licensed StatPro from me and transformed it into the current StatTools add-in. Therefore, in the mid-1990s, I wrote my own Excel statistical add-in, called StatPro, and it was actually the basis for the statistical sections in early editions of our books. Frankly, I didn t think it was up to the job. At the time, this left only one option, Analysis ToolPak, for the statistical analysis. As Excel grew in importance in the 1990s, our students voiced strong opinions that we should perform all quantitative analysis, including statistical analysis, in Excel. This is somewhat curious, given Microsoft s increasing attention to data analysis, but for whatever reasons, Microsoft has decided to focus on other data analysis features and keep Analysis ToolPak as is. Admittedly, Microsoft has recently revised many of Excel s statistical functions to make them more accurate numerically and to provide a more consistent naming convention, but the functionality and user interface of Analysis ToolPak have changed hardly at all.

Indeed, its current form is almost identical to its form then. Since the early days of Excel at least 20 years ago Analysis ToolPak has been part of Excel. Given that Analysis ToolPak is freely available in Excel, it is worth asking why the data analysis sections of our books are based on StatTools, not Analysis ToolPak. In contrast, Analysis ToolPak is bundled with Excel, so it is free for anyone who owns Excel.

Although StatTools is provided for free to users of our books, it must be purchased separately by companies that want to use it. The document is aimed at users who prefer a free alternative to Palisade s StatTools add-in. Christian Albright, September 2013 Introduction This document illustrates the use of Excel s Analysis ToolPak add-in for data analysis. 1 Using Excel s Analysis ToolPak Add-In S.

Excel not loading data analysis toolpak 2016