Stattools For Excel 2007

broken image


  1. Stattools 7
  2. Stattools Excel 2016
  3. Stattools Free
  4. Excel Xp

I got the same problem, when I tried to open RealStat-2007 file before Excel, then Excel stopped working; when I open Excel first and press Alt-TI, RealStat-2007 is on the list of addins, then I checked Analysis Tool Pak, Solvers and RealStat-2007, the same problem happened again. Excel 2007: The Data Analysis add-in should appear at right-end of Data menu as Data Analysis. Click the Microsoft Office Button, and then click Excel Options. Click Add-Ins, and then in the Manage box, select Excel. XLSTAT is a powerful yet flexible Excel data analysis add-on that allows users to analyze, customize and share results within Microsoft Excel. With over 240 standard to advanced statistical features available, XLSTAT is the preferred tool for statistical analysis in businesses and universities, large and small, and for 100,000+ users in over. The 5.7 version of StatTools for Excel is available as a free download on our website. This software was originally created by Palisade Corporation. The most popular versions among the program users are 5.7, 5.0 and 1.1. The software relates to Office Tools. StatTools.exe is the default file name to indicate the StatTools for Excel installer.

Beyond Basic Statistics in Excel

Advanced Statistical Analysis and Forecasting


Part of the DecisionTools Suite

My students are delighted with StatTools. They find it easy to learn and easy to use.

Stattools For Excel 2007

StatTools does the time series autocorrelation in a user-friendly way that is quick and easy. You know you got it right the first time…StatTools did what I needed without the time and expense of a heavy-duty stats package.

A New Statistics and Forecasting Toolset for your Spreadsheet

For

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.

We wanted a statistical analysis package that worked in Excel. StatTools fits the bill and provides robust and accurate analysis.

Get Started With A Free Trial

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

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

Customer Success Stories

Learn how StatTools has helped decision makers make informed predictions.

Pace University
View Info
Richmond Hospital System
View Info
Curtin University of Technology
View Info
CalPoly
View Info

Product Resources

Explore examples and tutorials on how to make StatTools work best for you.

  • Watch Video
  • Watch Video
  • Inside the DecisionTools Suite - NeuralTools & StatTools
    Watch Webinar
  • Why be Normal? Selecting the Best Distribution Models
    Watch Webinar

Features To Meet Your Needs

New statistics in Excel

StatTools replaces questionable Excel functions and performs wide range of analyses.

Custom Statistical Procedures

Build your own procedures in Excel, plus full customization of all StatTools reports.

Live Updating When Input Data Changes

With StatTools, your statistical reports and charts always reflect latest data

Intelligent Data Management

StatTools allows for quick definition of data sets and management of multiple data sets.

Capacity For Large Data Sets

StatTools Industrial has no limits on amount of data to analyze. (The Professional edition provides 10,000 data points per variable.).

Included with The DecisionTools Suite

Included with The DecisionTools Suite

The DecisionTools Suite

The complete risk and decision analysis toolkit, including @RISK, PrecisionTree, TopRank, NeuralTools, StatTools, Evolver, RISKOptimizer.

Additional Benefits

Subscription

Your software subscription has you fully covered.

  • Free upgrades when new software versions are released
  • Full access to Technical Support

Support

Technical Supportis available to help with installation, operational problems, or errors.

  • Included with subscription
  • Phone, web, or email

Customizable

Leverage the power ofStatToolsin your own custom application with Palisade Custom Development.

Next Steps

Maintenance

Palisade maintenance plans are designed to cover you when new software versions are released, or if you require help operating the software or resolving errors. Software updates are often released to keep current with changes in Windows, or in Excel or other host applications. Updates may also include bug fixes or minor product enhancements. Major version upgrades are released when new significant new features and/or interface changes are made to the software. Major version upgrades may also include updates to host application compatibility. Technical support is also included with Palisade maintenance. Whether through self-support using our Knowledgebase, via e-mail, or on the phone, Palisade is here to help with installation, operational problems, or error messages.

Benefits of Palisade Maintenance Plans

Free technical support via hotline or email. Technical Support hours are Monday – Friday, 4:00am – 5:00pm (New York time zone). Technical support is available for software installation, resolving software errors, assisting with software operation, and limited model de-bugging. Technical support is not designed for building spreadsheet models from scratch, extensive model de-bugging, or software training. These services may be obtained from our Training and Consulting department.

  • Free full version upgrades.
  • Unlimited number of incidents for 12 months.
  • Unlimited, 24-hour access to Palisade's online technical support KnowledgeBase—the same source used by Palisade technical support staff. A quick check of the KnowledgeBase often solves the problem in just a few minutes.
  • Guaranteed 24 hour or next business day technical support response time.
  • Free software maintenance updates & patches, including bug fixes & Windows/Office compatibility updates.
  • Access to the Palisade online HelpDesk 24 hours per day, so you can submit new incidents and check the status of open problems.

Easy to Order

A full year of maintenance is included when you purchase your software. Shortly before your maintenance plan expires, renewal notices are sent via e-mail. If you choose not to renew your maintenance plan, none of the above benefits will be available to you. Lapsed maintenance plans may only be renewed at higher prices and with reinstatement fees.

To order or renew your maintenance plan, contact:

607-277-8000 tel
800-432-7475 toll-free US/Canada
607-277-8001 fax

A New Statistics and Forecasting Toolset for your Spreadsheet

Have you ever needed forecasting, regression, quality control charts, or other statistical analyses beyond the basics that are provided with Excel? Have you ever doubted the accuracy of some of Excel's statistical results? StatTools addresses both of these issues, providing a new, powerful statistics toolset to Excel.

I've worked with Minitab before, and now abandoned it altogether since StatTools is so much better!
Alex Lebedev
Lebedev Consulting
Pretoria, South Africa

StatTools covers the most commonly used statistical procedures, and offers unprecedented capabilities for adding new, custom analyses. 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. 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.

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.

Learn how to get started quickly in StatTools
Watch videos of StatTools features


New in Version 7 – New Analyses, Improved Regression, @RISK Data Viewer

»Update Now

StatTools 7 adds new statistical analyses, streamlines regression processes, and now gives you the ability to view any data set using the same interactive charting engine found in @RISK!

»Learn more about What's New in DecisionTools Suite 7

Kruskal-Wallis Test
This non-parametric test comparing three or more populations has been added in response to customer demand.

Data Viewer
This allows you to view any Excel data set with the same charting engine used to create @RISK graphs and tables. The Data Viewer can pull from any data source -- no simulation needs to be run. With an easy-to-use, intuitive interface, users can simply select any variable to instantly create graphs with Palisade's amazing graphing engine—which can then be manipulated, customized, and used for reporting and sharing. You can create histograms, cumulative charts, trend plots, box plots, and more.


The Data Viewer Summary View, showing thumbnail histograms that can be dragged off for further analysis.

Cluster Analysis
Groups similar items within your data, so that items in the same group are more similar than to those in other groups. This helps the user highlight and quantify differences between data points.

A Dendrogram is part of the Cluster Analysis report; it shows the steps of the process of grouping items based on the degree of similarity.

Principal Component Analysis
Takes large datasets and reduces the dimensionality, eliminating unimportant details while highlighting strong patterns within the data.


The Principal Component Analysis report includes a Score Plot, which represents the input multi-dimensional data in two dimensions (with optional color-coding based on a categorical variable).

Upgraded Regressions
Setting up dummy variables and other manual processes are a thing of the past. Now, you can perform complex regressions in just a single click.

In addition, more complex relationships in data can be analyzed by using non-linear variable transformations. Moreover, the new StatTools regression analysis will handle big data sets faster than before.

Categorical Bar Charts
New, eye-catching bar chart graphs for categorical variables provide a convenient method for showcasing your results.


This Bar Chart shows multiple categorical variables at a glance.

» See StatTools forecast in Excel. Click to view larger graphic.

How StatTools Works

First, you define your data in StatTools. Then, you 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. You can define any number of data sets, each with the variables you want to analyze, 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 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. StatTools fully supports the expanded worksheet size in Excel 2007-2010. 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. To write your own, 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, which allows you to utilize StatTools's built-in data management, charting and reporting tools.





» See StatTools Data Set Manager. Click to view larger graphic.

StatTools Analyses

The statistical procedures available in StatTools come in the following natural groups.

Statistical Inference: This group performs the most common statistical inference procedures of confidence intervals and hypothesis tests.

Versions

Forecasting: StatTools gives you several methods for forecasting a time series variable. You can also deseasonalize the data first, using the ratio-to-moving-averages method and a multiplicative seasonality model. Then use a forecasting method to forecast your deseasonalized data, and finally 'reseasonalize' the forecasts to return to original units.

The outputs include a set of new columns to show the various calculations (for example, the smoothed levels and trends for Holt's method, the seasonal factors from the ratio-to-moving-averages method, and so on), the forecasts, and the forecast errors. Summary measures such as MAE, RMSE and MAPE are also included for tracking the fit of the model to the observed data. Finally, several time series plots are available, including a plot of the original series, a plot of the series with forecasts superimposed, and a plot of the forecast errors. In cases using deseasonalized data, these plots are available for the original and deseasonalized series.

Classification Analysis: StatTools provides both discriminant analysis and logistic regression. Discriminant analysis predicts which of several groups a variable will fall in, and logistic regression is a nonlinear type of regression analysis where the response variable is 0 or 1 for 'failure' or 'success.' You can then estimate the probability of success.

Data Management: This group allows you to manipulate your data set in various ways, either by rearranging the data or by creating new variables. These operations are typically performed before running a statistical analysis.

Summary Analyses: This group allows you to calculate several numerical summary measures for single variables or pairs of variables.

Tests for Normality: Because so many statistical procedures assume that a set of data are normally distributed, it is useful to have methods for checking this assumption. StatTools provides three commonly used checks: Chi-square, Lilliefors, and Q-Q plot.

Regression Analysis: For each of these analyses, the following outputs are given: summary measures of each regression equation run, an ANOVA table for each regression, and a table of estimated regression coefficients and other statistics. In addition, StatTools gives you the option of creating two new variables: the fitted values and residuals. Plus, you can create a number of diagnostic scatterplots.

Quality Control Charts: This set of procedures produces control charts that allow you to see whether a process is in statistical control. Each of the procedures takes time series data and plots them in a control chart. This allows you to see whether the data stay within the control limits on the chart. You can also tell if other nonrandom behavior is present, such as long runs above or below the centerline. Each of these procedures provides the option of using all the data or only part of the data for constructing the chart. Furthermore, each lets you base the control limits on the given data or on limits from previous data.

Nonparametric Tests: Nonparametric tests are statistical procedures which can be used to make successful inferences when there is little available data. They are more robust than many of the widely known parametric hypothesis tests. Nonparametric tests do not always need the parametric assumptions—such as normality—or generalized assumptions regarding the underlying distribution. In most cases, the nonparametric tests are much easier to apply and provide clearer interpretation than traditional parametric tests.

Excel Ease of Use

StatTools is a true add-in to Microsoft Excel, integrating completely with your spreadsheet. Browse, define, analyze – while never leaving Excel. StatTools replaces Excel's built-in statistics functions with its own calculations. All StatTools functions are true Excel functions, and behave exactly as native Excel functions do. StatTools calculations are optimized through the use of C++ .DLLs, not macro calculations.

Stattools For Excel 2007

StatTools does the time series autocorrelation in a user-friendly way that is quick and easy. You know you got it right the first time…StatTools did what I needed without the time and expense of a heavy-duty stats package.

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.

We wanted a statistical analysis package that worked in Excel. StatTools fits the bill and provides robust and accurate analysis.

Get Started With A Free Trial

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

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

Customer Success Stories

Learn how StatTools has helped decision makers make informed predictions.

Pace University
View Info
Richmond Hospital System
View Info
Curtin University of Technology
View Info
CalPoly
View Info

Product Resources

Explore examples and tutorials on how to make StatTools work best for you.

  • Watch Video
  • Watch Video
  • Inside the DecisionTools Suite - NeuralTools & StatTools
    Watch Webinar
  • Why be Normal? Selecting the Best Distribution Models
    Watch Webinar

Features To Meet Your Needs

New statistics in Excel

StatTools replaces questionable Excel functions and performs wide range of analyses.

Custom Statistical Procedures

Build your own procedures in Excel, plus full customization of all StatTools reports.

Live Updating When Input Data Changes

With StatTools, your statistical reports and charts always reflect latest data

Intelligent Data Management

StatTools allows for quick definition of data sets and management of multiple data sets.

Capacity For Large Data Sets

StatTools Industrial has no limits on amount of data to analyze. (The Professional edition provides 10,000 data points per variable.).

Included with The DecisionTools Suite

Included with The DecisionTools Suite

The DecisionTools Suite

The complete risk and decision analysis toolkit, including @RISK, PrecisionTree, TopRank, NeuralTools, StatTools, Evolver, RISKOptimizer.

Additional Benefits

Subscription

Your software subscription has you fully covered.

  • Free upgrades when new software versions are released
  • Full access to Technical Support

Support

Technical Supportis available to help with installation, operational problems, or errors.

  • Included with subscription
  • Phone, web, or email

Customizable

Leverage the power ofStatToolsin your own custom application with Palisade Custom Development.

Next Steps

Maintenance

Palisade maintenance plans are designed to cover you when new software versions are released, or if you require help operating the software or resolving errors. Software updates are often released to keep current with changes in Windows, or in Excel or other host applications. Updates may also include bug fixes or minor product enhancements. Major version upgrades are released when new significant new features and/or interface changes are made to the software. Major version upgrades may also include updates to host application compatibility. Technical support is also included with Palisade maintenance. Whether through self-support using our Knowledgebase, via e-mail, or on the phone, Palisade is here to help with installation, operational problems, or error messages.

Benefits of Palisade Maintenance Plans

Free technical support via hotline or email. Technical Support hours are Monday – Friday, 4:00am – 5:00pm (New York time zone). Technical support is available for software installation, resolving software errors, assisting with software operation, and limited model de-bugging. Technical support is not designed for building spreadsheet models from scratch, extensive model de-bugging, or software training. These services may be obtained from our Training and Consulting department.

  • Free full version upgrades.
  • Unlimited number of incidents for 12 months.
  • Unlimited, 24-hour access to Palisade's online technical support KnowledgeBase—the same source used by Palisade technical support staff. A quick check of the KnowledgeBase often solves the problem in just a few minutes.
  • Guaranteed 24 hour or next business day technical support response time.
  • Free software maintenance updates & patches, including bug fixes & Windows/Office compatibility updates.
  • Access to the Palisade online HelpDesk 24 hours per day, so you can submit new incidents and check the status of open problems.

Easy to Order

A full year of maintenance is included when you purchase your software. Shortly before your maintenance plan expires, renewal notices are sent via e-mail. If you choose not to renew your maintenance plan, none of the above benefits will be available to you. Lapsed maintenance plans may only be renewed at higher prices and with reinstatement fees.

To order or renew your maintenance plan, contact:

607-277-8000 tel
800-432-7475 toll-free US/Canada
607-277-8001 fax

A New Statistics and Forecasting Toolset for your Spreadsheet

Have you ever needed forecasting, regression, quality control charts, or other statistical analyses beyond the basics that are provided with Excel? Have you ever doubted the accuracy of some of Excel's statistical results? StatTools addresses both of these issues, providing a new, powerful statistics toolset to Excel.

I've worked with Minitab before, and now abandoned it altogether since StatTools is so much better!
Alex Lebedev
Lebedev Consulting
Pretoria, South Africa

StatTools covers the most commonly used statistical procedures, and offers unprecedented capabilities for adding new, custom analyses. 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. 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.

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.

Learn how to get started quickly in StatTools
Watch videos of StatTools features


New in Version 7 – New Analyses, Improved Regression, @RISK Data Viewer

»Update Now

StatTools 7 adds new statistical analyses, streamlines regression processes, and now gives you the ability to view any data set using the same interactive charting engine found in @RISK!

»Learn more about What's New in DecisionTools Suite 7

Kruskal-Wallis Test
This non-parametric test comparing three or more populations has been added in response to customer demand.

Data Viewer
This allows you to view any Excel data set with the same charting engine used to create @RISK graphs and tables. The Data Viewer can pull from any data source -- no simulation needs to be run. With an easy-to-use, intuitive interface, users can simply select any variable to instantly create graphs with Palisade's amazing graphing engine—which can then be manipulated, customized, and used for reporting and sharing. You can create histograms, cumulative charts, trend plots, box plots, and more.


The Data Viewer Summary View, showing thumbnail histograms that can be dragged off for further analysis.

Cluster Analysis
Groups similar items within your data, so that items in the same group are more similar than to those in other groups. This helps the user highlight and quantify differences between data points.

A Dendrogram is part of the Cluster Analysis report; it shows the steps of the process of grouping items based on the degree of similarity.

Principal Component Analysis
Takes large datasets and reduces the dimensionality, eliminating unimportant details while highlighting strong patterns within the data.


The Principal Component Analysis report includes a Score Plot, which represents the input multi-dimensional data in two dimensions (with optional color-coding based on a categorical variable).

Upgraded Regressions
Setting up dummy variables and other manual processes are a thing of the past. Now, you can perform complex regressions in just a single click.

In addition, more complex relationships in data can be analyzed by using non-linear variable transformations. Moreover, the new StatTools regression analysis will handle big data sets faster than before.

Categorical Bar Charts
New, eye-catching bar chart graphs for categorical variables provide a convenient method for showcasing your results.


This Bar Chart shows multiple categorical variables at a glance.

» See StatTools forecast in Excel. Click to view larger graphic.

How StatTools Works

First, you define your data in StatTools. Then, you 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. You can define any number of data sets, each with the variables you want to analyze, 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 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. StatTools fully supports the expanded worksheet size in Excel 2007-2010. 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. To write your own, 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, which allows you to utilize StatTools's built-in data management, charting and reporting tools.





» See StatTools Data Set Manager. Click to view larger graphic.

StatTools Analyses

The statistical procedures available in StatTools come in the following natural groups.

Statistical Inference: This group performs the most common statistical inference procedures of confidence intervals and hypothesis tests.

Forecasting: StatTools gives you several methods for forecasting a time series variable. You can also deseasonalize the data first, using the ratio-to-moving-averages method and a multiplicative seasonality model. Then use a forecasting method to forecast your deseasonalized data, and finally 'reseasonalize' the forecasts to return to original units.

The outputs include a set of new columns to show the various calculations (for example, the smoothed levels and trends for Holt's method, the seasonal factors from the ratio-to-moving-averages method, and so on), the forecasts, and the forecast errors. Summary measures such as MAE, RMSE and MAPE are also included for tracking the fit of the model to the observed data. Finally, several time series plots are available, including a plot of the original series, a plot of the series with forecasts superimposed, and a plot of the forecast errors. In cases using deseasonalized data, these plots are available for the original and deseasonalized series.

Classification Analysis: StatTools provides both discriminant analysis and logistic regression. Discriminant analysis predicts which of several groups a variable will fall in, and logistic regression is a nonlinear type of regression analysis where the response variable is 0 or 1 for 'failure' or 'success.' You can then estimate the probability of success.

Data Management: This group allows you to manipulate your data set in various ways, either by rearranging the data or by creating new variables. These operations are typically performed before running a statistical analysis.

Summary Analyses: This group allows you to calculate several numerical summary measures for single variables or pairs of variables.

Tests for Normality: Because so many statistical procedures assume that a set of data are normally distributed, it is useful to have methods for checking this assumption. StatTools provides three commonly used checks: Chi-square, Lilliefors, and Q-Q plot.

Regression Analysis: For each of these analyses, the following outputs are given: summary measures of each regression equation run, an ANOVA table for each regression, and a table of estimated regression coefficients and other statistics. In addition, StatTools gives you the option of creating two new variables: the fitted values and residuals. Plus, you can create a number of diagnostic scatterplots.

Quality Control Charts: This set of procedures produces control charts that allow you to see whether a process is in statistical control. Each of the procedures takes time series data and plots them in a control chart. This allows you to see whether the data stay within the control limits on the chart. You can also tell if other nonrandom behavior is present, such as long runs above or below the centerline. Each of these procedures provides the option of using all the data or only part of the data for constructing the chart. Furthermore, each lets you base the control limits on the given data or on limits from previous data.

Nonparametric Tests: Nonparametric tests are statistical procedures which can be used to make successful inferences when there is little available data. They are more robust than many of the widely known parametric hypothesis tests. Nonparametric tests do not always need the parametric assumptions—such as normality—or generalized assumptions regarding the underlying distribution. In most cases, the nonparametric tests are much easier to apply and provide clearer interpretation than traditional parametric tests.

Excel Ease of Use

StatTools is a true add-in to Microsoft Excel, integrating completely with your spreadsheet. Browse, define, analyze – while never leaving Excel. StatTools replaces Excel's built-in statistics functions with its own calculations. All StatTools functions are true Excel functions, and behave exactly as native Excel functions do. StatTools calculations are optimized through the use of C++ .DLLs, not macro calculations.

Two Editions to Meet Your Needs

StatTools comes in Professional and Industrial editions. The Industrial edition of StatTools adds Expanded Data Sets. With Expanded Data Sets, you can define variables that span multiple worksheets. The Professional edition allows 10,000 data points for a single variable.

Stattools 7

I applaud StatTools' powerful statistical analysis. The mathematics in Excel leave something to be desired. Long ago I re-wrote Excel's statistical functions as add-in macros due to the lack of precision within Excel. After testing a few of my favorite hand-written algorithms (Tinv, NormSdist, Normdist, Norminv, Binomdist, to name a few) against the ones you've included withthe package, our numbers agree to the last digit! At last, someone takes the initiative! Thank you!

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 optimization, 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. For example:

StatTools and @RISK then RISKOptimizer
Combine StatTools with @RISK to assess confidence intervals on simulation results. You can also apply @RISK functions to StatTools time-series forecast results to simulate possible outcomes with more precision than the times-series analysis alone. Run RISKOptimizer on your model using the same @RISK functions in order to find the best combination of factors to maximize your forecasted profits.

»More about The DecisionTools Suite

Save Over 50% When You Buy the Suite
When you buy the DecisionTools Suite, you save over 50% versus buying all components individually. The best analyses at a great price–with the DecisionTools Suite.


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: @RISK and DecisionTools Suite software is compatible with all 32-bit and 64-bit versions of Microsoft Windows XP-10, Excel 2007-2013, and Project 2007-2013.

64-bit Compatible
64-bit technology enables Excel and DecisionTools software to access much more computer memory than ever before. This allows for vastly larger models and greater computational power.

Stattools Excel 2016

Copyright ©2015 Palisade Corporation. All rights reserved.

Stattools Free



Excel Xp






broken image