The ribbon interface in Excel 2007, 2010, 2013, 2016, 2019 and 365 has distributed and grouped menus and toolbars under different tabs. While this grouping is convenient, some users find it difficult to locate specific commands, earlier found in the tools menu, across different tabs. StatPlus:mac Pro allows Microsoft Excel for Mac users to perform all forms of data analysis from the very basics to complex analysis, including as non-parametric and regression analysis, survival analysis, and a wide variety of other methods. Pro users are entitled to receive unlimited priority support during one year (and even on weekends).
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 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 TrialOverview
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.
Product Resources
Explore examples and tutorials on how to make StatTools work best for you.
- Watch Video
- Watch Video
- Inside the DecisionTools Suite - NeuralTools & StatToolsWatch Webinar
- Why be Normal? Selecting the Best Distribution ModelsWatch 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:
800-432-7475 toll-free US/Canada
607-277-8001 fax
But what if you work for a math-heavy industry, pharmacology, medicine or sociology, and complex statistical analysis is part of your daily routine? Did you find a user-friendly data analysis tool that works on your Mac?
StatPlus:mac turns your copy of Microsoft Excel for Mac (2004 - 2019) or Apple Numbers into a powerful statistical tool without making you learn another software or part with extraordinary amounts of money. You'll use the familiar interface to perform complex analysis and calculations, enabling you to concentrate on analyzing the results rather than figuring out how to achieve them.
Upgrade Your Spreadsheet
Turn Microsoft Excel or Apple Numbers into a powerful statistical package with StatPlus:mac and perform data analysis on a Mac in the familiar environment. Stop wasting your time learning new tools and try StatPlus:mac right away.
70+ Features
StatPlus:mac allows Mac users to perform all forms of data analysis from the very basics to complex analysis, including non-parametric and regression analysis, survival and time series analysis, and a wide variety of other methods. Version 7 includes standalone spreadsheet and can be used without Microsoft Excel or Apple Numbers installed.
Multi-platform
StatPlus:mac is available for both Mac and PC platforms (PC version includes standalone and Excel add-in versions) at no extra charge. Save learning time and costs for your mixed PC and Mac environment.
Free Trial
We have free trial that gives you an opportunity to evaluate the software before you purchase it. Should you have any questions during the trial period, please feel free to contact our Support Team.
Affordable
StatPlus:mac is most affordable solution for data analysis on Mac (with Excel and Numbers support). You will benefit from the reduced learning curve and attractive pricing while enjoying the benefits of precise routines and calculations. Mac/PC license is permanent, there is no renewal charges.
Mac Excel Download
Requirements
StatPlus:mac requires macOS 10.9-10.15 (macOS Catalina is supported; v5 requires 10.5+). StatPlus:mac supports Microsoft Excel for Mac (supported versions: 2004, 2008, 2011, 2016, 2019) and Apple Numbers v3/v4/v5 as a data source. StatPlus:mac does not require Internet connection (except for optional auto-update feature).
Product Resources
Explore examples and tutorials on how to make StatTools work best for you.
- Watch Video
- Watch Video
- Inside the DecisionTools Suite - NeuralTools & StatToolsWatch Webinar
- Why be Normal? Selecting the Best Distribution ModelsWatch 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:
800-432-7475 toll-free US/Canada
607-277-8001 fax
But what if you work for a math-heavy industry, pharmacology, medicine or sociology, and complex statistical analysis is part of your daily routine? Did you find a user-friendly data analysis tool that works on your Mac?
StatPlus:mac turns your copy of Microsoft Excel for Mac (2004 - 2019) or Apple Numbers into a powerful statistical tool without making you learn another software or part with extraordinary amounts of money. You'll use the familiar interface to perform complex analysis and calculations, enabling you to concentrate on analyzing the results rather than figuring out how to achieve them.
Upgrade Your Spreadsheet
Turn Microsoft Excel or Apple Numbers into a powerful statistical package with StatPlus:mac and perform data analysis on a Mac in the familiar environment. Stop wasting your time learning new tools and try StatPlus:mac right away.
70+ Features
StatPlus:mac allows Mac users to perform all forms of data analysis from the very basics to complex analysis, including non-parametric and regression analysis, survival and time series analysis, and a wide variety of other methods. Version 7 includes standalone spreadsheet and can be used without Microsoft Excel or Apple Numbers installed.
Multi-platform
StatPlus:mac is available for both Mac and PC platforms (PC version includes standalone and Excel add-in versions) at no extra charge. Save learning time and costs for your mixed PC and Mac environment.
Free Trial
We have free trial that gives you an opportunity to evaluate the software before you purchase it. Should you have any questions during the trial period, please feel free to contact our Support Team.
Affordable
StatPlus:mac is most affordable solution for data analysis on Mac (with Excel and Numbers support). You will benefit from the reduced learning curve and attractive pricing while enjoying the benefits of precise routines and calculations. Mac/PC license is permanent, there is no renewal charges.
Mac Excel Download
Requirements
StatPlus:mac requires macOS 10.9-10.15 (macOS Catalina is supported; v5 requires 10.5+). StatPlus:mac supports Microsoft Excel for Mac (supported versions: 2004, 2008, 2011, 2016, 2019) and Apple Numbers v3/v4/v5 as a data source. StatPlus:mac does not require Internet connection (except for optional auto-update feature).
Statistical features list
Stattools For Mac Excel 2016
- Pro Features
- Standalone spreadsheet with Excel (XLS and XLSX), OpenOffice/LibreOffce Calc (ODS) and text documents support.
- 'Add-in' mode for Excel 2004, 2008, 2011, 2016 and 2019.
- 'Add-in' mode for Apple Numbers v3, v4 and v5.
- Priority support.
- Permanent license and free major upgrades during the maintenance period.
- Access to Windows version.
- Options to emulate Excel Analysis ToolPak results and migration guide for users switching from Analysis ToolPak.
- Basic Statistics
- Detailed descriptive statistics.
- One-sample t-test.
- Two-sample t-test.
- Two-sample t-test for summarized data.
- Fisher F-test.
- One-sample and two-sample z-tests.
- Correlation analysis and covariance.
- Normality tests (Jarque-Bera, Shapiro-Wilk, Shapiro-Francia, Cramer-von Mises, Anderson-Darling, Kolmogorov-Smirnov, D'Agostino's tests).
- Cross-tabulation and Chi-square.
- Frequency tables analysis (for discrete and continuous variables).
- Multiple definitions for computing quantile statistics.
- Analysis of Variance (ANOVA)
- One-way and two-way ANOVA (with and without replications).
- Three-way analysis of variance.
- Post-hoc comparisons - Bonferroni, Tukey-Kramer, Tukey B, Tukey HSD, Neuman-Keuls, Dunnett.
- General Linear Models (GLM) ANOVA.
- Within subjects ANOVA and mixed models.
- Multivariate Analysis
- Principal component analysis (PCA).
- Factor analysis (FA).
- Discriminant function analysis.
- Nonparametric Statistics
- 2x2 tables analysis (Chi-square, Yates Chi-square, Exact Fisher Test, etc.).
- Rank and percentile.
- Chi-square test.
- Rank correlations (Kendall Tau, Spearman R, Gamma, Fechner).
- Comparing independent samples
Mann-Whitney U Test, Kolmogorov-Smirnov test, Wald-Wolfowitz Runs Test, Rosenbaum Criterion. Kruskal-Wallis ANOVA and Median test. - Comparing dependent samples
Wilcoxon Matched Pairs Test, Sign Test, Friedman ANOVA, Kendall's W (coefficient of concordance). - Cochran's Q Test.
Excel Stattools Add In
- Regression Analysis
- Multivariate linear regression (residuals analysis, collinearity diagnostics, confidence and prediction bands).
- Weighted least squares (WLS) regression.
- Logistic regression.
- Stepwise (forward and backward) regression.
- Polynomial regression.
- Curve fitting.
- Tests for heteroscedasticity: Breusch–Pagan test (BPG), Harvey test, Glejser test, Engle's ARCH test (Lagrange multiplier) and White test.
- Time Series Analysis
- Data processing.
- Fourier analysis.
- Smoothing.
- Moving average.
- Analysis.
- Autocorrelation (ACF and PACF).
- Interrupted time series analysis.
- Unit root tests - Dickey–Fuller, Augmented Dickey–Fuller (ADF test), Phillips–Perron (PP test), Kwiatkowski–Phillips–Schmidt–Shin (KPSS test).
- Survival Analysis
- Life tables.
- Kaplan-Meier (log rank test, hazard ratios).
- Cox proportional-hazards regression.
- Probit-analysis (Finney and LPM).
LD values (LD50/ED50 and others), cumulative coefficient calculation. - Receiver operating characteristic curves analysis (ROC analysis).
AUC methods - DeLong's, Hanley and McNeil's. Report includes: AUC (with confidence intervals), curve coordinates, performance indicators - sensitivity and specificity (with confidence intervals), accuracy, positive and negative predictive values, Youden's J (Youden's index), Precision-Recall plot. - Comparing ROC curves.
- Data Processing
- Sampling (random, periodic, conditional).
- Random numbers generation.
- Standardization.
- Stack/unstack operations.
- Matrix operations.
- Statistical Charts
- Histogram
- Scatterplot.
- Box plot.
- Stem-and-leaf plot.
- Bland-Altman plot.
- Bland-Altman plot with multiple measurements per subject.
- Quantile-quantile Q-Q plots for different distributions.
- Control charts - X-bar, R-chart, S-chart, IMR-chart, P-chart, C-chart, U-chart, CUSUM-chart.
