StatTools
StatTools gives the industry-standard data analysis tool - Microsoft Excel - a new, powerful statistics toolset! StatTools is a Microsoft Excel statistics add-in, so you analyse data in Excel and work in the familiar Microsoft Office environment. StatTools brings you the best of two worlds: Microsoft Office ease-of-use, and robust statistical power. Plus, StatTools is developed by Palisade Corporation, the world leader in analytical solutions that add-in to Microsoft Excel.
Excel Ease of Use
StatTools is a true add-in to Microsoft Excel, integrating completely with your spreadsheet. Browse, define, analyse - while never leaving Excel. StatTools replaces Excel's built-in statistics functions with its own calculations. The accuracy of Excel's built-in statistics calculations has often been questioned, so StatTools doesn't use them. All StatTools functions are true Excel functions, and behave exactly as native Excel functions do. StatTools calculations are optimised through the use of C++ .DLLs, not macro calculations.
How StatTools Works
StatTools covers the most commonly used statistical procedures, and offers unprecedented capabilities for adding new, custom analyses. Over 30 wide-ranging statistical procedures plus 9 built-in data utilities include forecasts, descriptive statistics, normality tests, group comparisons, correlation, regression analysis, quality control, nonparametric tests, and more.
StatTools features live, "hot-linked" statistics calculations. Change a value in your dataset and your statistics report automatically updates. There is no need to manually re-run your analyses.
The Best in Data Management
StatTools provides a comprehensive data set and variable manager right in Excel, just as you would expect from a stand-alone statistics package. You can define any number of data sets, each with the variables you want to analyse, directly from your data in Excel. StatTools intelligently assesses your blocks of data, suggesting variable names and locations for you. Your data sets and variables can reside in different workbooks, allowing you to organise your data as you see fit. Run statistical analyses that refer to your variables, instead of re-selecting your data over and over again in Excel. StatTools fully supports the expanded worksheet size in Excel 2007. Plus, you can define variables that span multiple worksheets.
Excel Developer Kit (XDK)
StatTools includes a complete, object-oriented, programming interface-the Excel Developer Kit (XDK). Custom statistical procedures may be added using Excel's built-in VBA programming language. Utilise StatTools's built-in data management, charting and reporting tools.
Two Editions to Meet Your Needs
StatTools comes in Professional and Industrial editions. The Industrial edition of StatTools adds the following features:
Expanded data sets - Define variables that span multiple worksheets. The Professional edition allows 10,000 data points for a single variable.
Nonparametric tests - Nonparametric tests are statistical procedures which can be used to make successful inferences when there is little available data.
StatTools Features & Benefits
| Features | Benefits |
| New statistics in Excel | Replaces questionable Excel functions and perform wide range of analyses |
| Seamless integration with Excel | Never leave your spreadsheet; get up to speed quickly |
| Live updating when input data changes | Statistical reports and charts always reflect latest data |
| Intelligent data management | Quick definition of data sets; management of multiple data sets |
| Capacity for large data sets; support for Excel 2007 worksheet size | No limits on amount of data to analyse |
| Excel-based reporting and charting | Full customisation capabilities on all StatTools reports |
| Excel data access | Import data from virtually any source into Excel |
| Save results in Excel workbooks | Share StatTools reports with any Excel user, even if they don't have StatTools |
| Excel Developer Kit (XDK) | Programming interface lets you define custom procedures in StatTools using Excel VBA |
Part of the DecisionTools Suite
StatTools is available by itself or as part of the DecisionTools Suite, Palisade's complete risk and decision analysis toolkit. The DecisionTools Suite includes @RISK for risk analysis with Monte Carlo simulation, NeuralTools for predictions using neural networks, Evolver for optimisation, PrecisionTree for decision trees, and more. StatTools is fully compatible with all DecisionTools programs and can be combined with them for greater insight and analysis.
100% Excel
StatTools calculations are performed 100% within Excel,supported by Palisade sampling and statistics proven inover twenty years of use. Palisade does not attempt to rewrite Excel in an external recalculator to gain speed. Asingle recalculation from an unsupported or poorly reproduced macro or function can dramatically change your results. Where will it occur, and when? Get accurate results using StatTools!
Compatibility: StatTools is compatible with Excel versions 2000 through 2007.
Read more about StatTools at www.palisade.com.