Stattools Excel Mac Download

  

StatTools performs forecasting and statistical analysis in Microsoft Excel. It replaces Excel’s built-in statistics functions with its own, more robust and accurate functions. StatTools covers the most common statistical analyses, and even allows you to build your own custom statistical procedures.

Home → End User Setup → Configuring Excel → Opening Palisade Software Automatically Whenever Excel Opens

Disponible en español:Apertura Del Software Palisade Automáticamente Cada vez que Inicia Excel
Disponível em português:Abrindo Software da Palisade junto com Excel

Download
  1. Numbers lets you build beautiful spreadsheets on a Mac, iPad, or iPhone — or on a PC using iWork for iCloud. And it’s compatible with Apple Pencil.
  2. Download StatTools Kostenlos Thank you for using our software portal. Download the required product from the developer's site for free safely and easily using.
  3. I can't find the Analysis ToolPak in Excel for Mac 2011. There are a few third-party add-ins that provide Analysis ToolPak functionality for Excel 2011. Option 1: Download the XLSTAT add-on statistical software for Mac and use it in Excel 2011. XLSTAT contains more than 200 basic and advanced statistical tools that include all of the Analysis.
  4. Certain programs such as Microsoft Access and Excel Add-Ons (@Risk, StatTools, other Decision Tools) are not compatible for use on a Mac. Faculty, staff, and students who need their computer to run these types of programs for work or a class will need to install Oracle's VirtualBox onto their Mac computer.

Applies to:
@RISK 5.x–8.x
Evolver 5.x–8.x
NeuralTools 5.x–8.x
PrecisionTree 5.x–8.x
RISKOptimizer 5.x only (For 6.x and newer, set @RISK to run automatically, not RISKOptimizer.)
StatTools 5.x–8.x
TopRank 5.x–8.x

There is never a requirement to add our add-ins or toolbars to Excel manually. Ordinarily, you open our software via a desktop shortcut if available, or through the start menu (All Programs or Programs and then Palisade DecisionTools). This can be done when Excel is already running, or when Excel is not running. If Excel is not running, our software will launch Excel automatically.

But some users prefer to double-click on workbooks (.XLS, .XLSX, .XLSM, etc.) to open Excel. In this case you must then start StatTools, @RISK, or our other software tools as a separate step. This article explains how to make any of our software tools open automatically, every time Excel opens. It's also possible to give this treatment to just one Excel workbook, if the workbook has macros enabled; see Setting References in Visual Basic.

Caution: If you plan on opening multiple instances of Excel, please do not configure our software to open automatically. Palisade software is not designed to run simultaneously in multiple instances of Excel, and you will get a message such as 'Object initialized twice.' (It's perfectly okay to have single instances of different Palisade applications running in the same instance of Excel, as long as they all have the same release number. It's also okay to open multiple workbooks, as opposed to multiple instances of Excel; see Using Excel During Simulation or Optimization for the difference.)

Stattools Excel Mac Download Software

Caution: A 5.x release, a 6.x release, 7.x release, and an 8.x release can coexist on the same computer, but they must not run at the same time. If you have one version starting automatically, don't run a different version until you first remove the first version from automatic startup.

For starting @RISK (Evolver, PrecisionTree, ...) automatically with Excel, please select your release below.

With releases 6.1–6.3, 7.x, and 8.x:

  1. Launch the tool that you want to run automatically with Excel.

  2. In Excel 2010, 2013, or 2016, click File » Options » Add-Ins, then at the bottom of the page select 'Manage Excel Add-Ins' and click Go.
    In Excel 2007, click the round Office button, then Excel Options, then Add-Ins, then at the bottom of the page select 'Manage Excel Add-Ins' and click Go.
    In Excel 2003, with Palisade releases 6.x, click Tools » Add-Ins. (Excel 2003 is not compatible with Palisade releases 7.0 and newer.)

  3. You will see your currently running Palisade add-ins listed, along with any others that you have run previously. Put check mark(s) on the one(s) that you want to open automatically.
    Caution: Don't click the Browse button and go searching for add-ins; only the ones listed here are candidates.
    Exception: In 6.x/7.x/8.x, RISKOptimizer is part of @RISK. If you want RISKOptimizer to start every time Excel starts, tick the box for @RISK, not RISKOptimizer.

From now on, when Excel opens, the desired Palisade tool will open automatically with it. This applies when you double-click an Excel workbook or start Excel via a program shortcut.

Stattools Excel Mac Download

If you change your mind later, go back to the Add-Ins list and uncheck the ones that you no longer want to load automatically. You will still be able to load them through the desktop icon or through the Windows Start button.

With release 6.0:

The above procedure will work for Evolver 6.0, NeuralTools 6.0, PrecisionTree 6.0, StatTools 6.0, and TopRank 6.0. However, it is not recommended for @RISK 6.0. @RISK 6.0 had a problem: If the @RISK or RISKOptimizer add-in is checked as described above, @RISK may crash at the end of a simulation that uses multiple CPUs. @RISK releases 6.1.1 and later do not have the problem.

With releases 5.5.1–5.7.1:

  1. Launch the tool that you want to run automatically with Excel.

  2. In Excel 2010 (no newer Excels), click File » Options » Add-Ins, then at the bottom of the page select 'Manage Excel Add-Ins' and click Go.
    In Excel 2007, click the round Office button, then Excel Options, then Add-Ins, then at the bottom of the page select 'Manage Excel Add-Ins' and click Go.
    In Excel 2003 or below, click Tools » Add-Ins.

  3. You will see your currently running Palisade add-ins listed, along with any others that you have run previously. Put check mark(s) on the one(s) that you want to open automatically.
    Caution: Don't click the Browse button and go searching for add-ins; only the ones listed here are candidates.

From now on, when Excel opens, the desired Palisade tool will open automatically with it. This applies when you double-click an Excel workbook or start Excel via a program shortcut.

Stattools Excel Add In Download

If you change your mind later, go back to the Add-Ins list and uncheck the ones that you no longer want to load automatically. You will still be able to load them through the desktop icon or through the Windows Start button.

With release 5.0 or 5.5.0:

  1. Open just Excel (not @RISK).

  2. In Excel 2007, click the round Office button, then Excel Options, then Add-Ins, then at the bottom of the page select 'Manage Excel Add-Ins' and click Go.
    In Excel 2003 or below, click Tools » Add-Ins.

  3. On the Add-Ins dialog, click Browse.

  4. In the window that opens, navigate to your @RISK installation folder. The most likely location is C:Program FilesPalisade or C:Program Files (x86)Palisade, but it's possible that the Palisade software is installed elsewhere.

  5. Select the subfolder and double-click the add-in indicated in the table:

    To open this software automatically with ExcelSelect this folderDouble-click
    this file*    		And the add-ins list will show
    Evolver 5.0 or 5.5Evolver5Evolver.xlaEvolver for Excel 5.0 or Evolver 5.5
    NeuralTools 5.0 or 5.5NeuralTools5NeuralTools.xlaNeuralTools Add-In for Microsoft Excel or NeuralTools 5.5
    PrecisionTree 5.0 or 5.5PrecisionTree5PTree.xlaPrecisionTree 2.0 or 5.5
    @RISK 5.0 or 5.5RISK5Risk.xla@RISK for Excel 5.0 or 5.5
    RISKOptimizer 5.0 or 5.5RISKOptimizer5RISKOpt.xlaEvolver for Excel 5.0 or RISKOptimizer 5.5
    StatTools 5.0 or 5.5StatTools5StatTools.xlaStatTools for Microsoft Excel or StatTools 5.5
    TopRank 5.0 or 5.5TopRank5TopRank.xlaToprank or TopRank 5.5
    *If you don't see the '.xla' file extension, choose the file with this name, right-click it, and select Properties. Verify that the type is Microsoft Office Excel Add-In, cancel the Properties dialog, and double-click the file.

  6. You are now back in the Add-Ins dialog, with a new entry checked, as shown in the last column of the table.

  7. If you wish, you can browse to additional Palisade add-ins to make multiple tools open automatically with Excel. (RISKOptimizer includes Evolver, so you can't open both of them automatically with Excel.) But add only the tools that you really do use almost every time you open Excel; otherwise you will just make Excel open slower for no good purpose.

  8. Click OK, then close Excel (File » Exit).

From now on, when Excel opens the desired Palisade tool will open automatically with it. This applies when you double-click an Excel workbook or start Excel via a program shortcut.

If you change your mind later, go back to the Add-Ins list and uncheck the add-in that you browsed to.

last edited: 2020-03-20

Stattools Free

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

Stattools Excel Mac Download Free

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.

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).

Stattools excel 2016

Statistical features list

  • 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.
  • 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.