StatTools

Beyond Basic Statistics in Excel

Advanced Statistical Analysis and Forecasting

A New Statistics and Forecasting Toolset for your Spreadsheet

StatTools covers commonly used statistical procedures, and offers the capability to add new, custom analyses to Microsoft Excel. 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. Over 30 wide-ranging statistical procedures plus 9 built-in data utilities include forecasts, time series, descriptive statistics, normality tests, group comparisons, correlation, regression analysis, quality control, nonparametric tests, and more.

Overview

First, define your data in StatTools. Then, perform any of over 30 different types of analysis on your data set, depending on your situation. StatTools provides a comprehensive and intuitive data set and variable manager right in Excel. Data sets and variables can reside in different workbooks, allowing you to organize 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. Plus, you can define variables that span multiple worksheets. Once your data sets have been defined, choose a procedure from the StatTools menu or write your own, custom procedure.

• Works with Microsoft Excel
• Statistics calculations update automatically between dataset and reports
• View multiple scatter plots between variables in a single report
• A comprehensive and intuitive data set and variable manager
• Goes beyond the basics provided by Excel

Explore the functionality of each part of the StatTools software ribbon. Learn how the features work and improve efficiency in your decision tree models.

How StatTools Is Used

StatTools enables endless applications, including:

• Sales forecasting
• Portfolio management
• New product analysis
• Polling and strategic planning
• Draft picks and odds setting