Stattools Excel Mac Download



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. Trusted Windows (PC) download StatTools 6.0.290.11. Virus-free and 100% clean download. Get StatTools alternative downloads.

  1. Stattools Excel Mac Download Free
  2. How To Use Stattools Excel
  3. Where Is Stattools In Excel
  4. Stattools 7
  5. Stattools Excel Mac Download Version

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

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

Stattools Excel Mac Download

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.

Stattools Excel Mac DownloadDownload

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

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.

Stattools Excel Mac Download Free

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.

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.

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

Skip to end of metadataGo to start of metadata

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. VirtualBox allows the MacOS to run a Windows system on top of their computer. This is not permanent and should only be used when the user opens the VirtualBox application to run the restricted programs. VirtualBox is a free virtual machine provided by Oracle that is available for faculty, staff, and students to use.


The following instructions are for the installation of VirtualBox on a Mac:

Prior to installing, make sure you have:

  • ~30 GB of free space
  • ~45 minutes for complete installation


First, install VirtualBox application:

How To Use Stattools Excel

  1. Go to https://www.virtualbox.org/wiki/Downloads
  2. Under 'VirtualBox platform packages', click 'OS hosts'.
    1. This will download the base VirtualBox application
  3. Under 'VirtualBox Oracle VM Extension Pack', click 'All supported platforms'
    1. This will download the VB extension pack
  4. Locate the 2 downloaded files in your folder, and open the first file VirtualBox-6.1.10-138449-OSX.dmg
    1. It will open a drive window, click 'VirtualBox.pkg
    2. Proceed with the installation by clicking through to Agree
    3. *** If you get an error that says Installation Failed, follow these steps:
      1. Open up System Preferences
      2. Click on the Security & Privacy icon
      3. Hopefully you’ll see a message saying System software from developer “Oracle America, Inc.” was blocked from loading.
      4. If you do see the message, click the lock icon in the bottom left of the window
      5. Enter your Mac password
      6. Then click the Allow button
      7. Try the installation again
  5. Locate the second file and open Oracle_VM_VirtualBox_Extension_Pack-6.1.10.vbox-extpack
    1. Double-clicking the file will automatically open the VirtualBox application
    2. Either click 'install' or 'upgrade'
    3. Allow the extension pack to install and once you're done, it should look like this

Now that you have VirtualBox installed, you need to install the OVA file that allows Windows 10 to be run with VirtualBox:


  1. Go to https://utexas.app.box.com/v/msb-student-vms
  2. Login with your EID and Password
  3. Click the 3 dots to the right of the Windows10-2004.ova file and click Download
  4. Once the file finishes downloading, locate the file and double-click to open. **Do not delete the OVA file from your computer
  5. Make sure these settings are selected and click Import
  6. Let the installer run and once it is done you can open VirtualBox


Next, we want to change some settings so we can view the window in full screen:

  1. Open VirtualBox from your Launchpad or list of applications
  2. Select Windows2004 from the left side
  3. Click the green Start arrow
  4. Windows will power up
  5. Navigate to the toolbar at the top of the screen and select Device
  6. Click Insert Guest Additions CD Image...
  7. Open file explorer from the taskbar at the bottom > This PC
  8. Double-click CD Drive (D:) VirtualBox Guest Additions
  9. Click Next>and follow through with the installation
  10. Select to Reboot Now at the end of the installer
  11. Once the Windows system reboots, navigate to the toolbar at the top of the screen
  12. Click View > Full-Screen Mode


Next, we will create shared folders. This will allow you to share the same folder such as 'Downloads' between the Mac side and Windows side. This will allow you to download files into your MacOS in a folder and access it from the Windows VirtualBox and vice versa.

  1. Navigate to the toolbar at the top of the screen, click Devices > Shared Folders > Shared Folder Settings
  2. Click the Folder with a plus sign on the right
  3. Click the drop-down arrow next to Folder Path and click Other
  4. Choose the folder from your Mac that you would like to share
  5. Once the folder is chosen, check the boxes Auto-Mount and Make Permanent
  6. Click Ok
  7. To access the shared folder, go to File Explorer > This PC and the shared folder will be a Z or Y drive


The following steps are to install Microsoft Office onto the Windows interface:

  1. Open Microsoft Edge
  2. Go to office365.austin.utexas.edu
  3. Select Office 365 Portal
  4. Sign in with your EID and Password. Authenticate with DUO if asked to.
  5. Once logged on, click Install Office > Office 365 Apps

  6. Click Run when asked to download file and wait for Office to install

If you need Decision Tools to run these following Excel Add-ons (@Risk, StatTools, PrecisionTree, TopRank, etc.) follow these steps:

  1. In VirtualBox, open Microsoft Edge
  2. Go to https://utexas.box.com/v/dtsinstaller
  3. Login with your EID and password
  4. Click Download and allow the file to Run
  5. Open DTS_Installer.exe
  6. Click Install and allow the installation to run
  7. The installer will suddenly close when the progress bar is close to the end. Wait a few moments and a second installer will pop up
  8. Click OK and select Next through the installation without changing any settings to finish the installation
  9. The Decision Tools icons will now show up on your desktop or you can find them by looking in the Start Menu under Palisade Decision Tools
  10. Double-click the program you are looking for and Excel will automatically open. The add-on will be available at the top. *Make sure to not have excel open already


Where Is Stattools In Excel

When you are done using VirtualBox, make sure to always shut it down completely. Navigate cursor to top left corner to hit the red close button and select Power Off Machine. Click Ok.



FREQUENTLY ASKED QUESTIONS:

  • Can I use the Windows VirtualBox to install video games or other Windows-specific programs?
    • You can at your discretion, but it is highly not recommended. It will be slow and almost impossible to use.
  • Why is it so slow?
    • VirtualBox is a free program from Oracle, therefore it is not the fastest machine to use-- especially if you are on a MacBook Air or something that has a lower RAM. It is recommended that when you are using the Windows side that you don't switch back and forth between viewing the Mac system and the Windows system (even to answer iMessages). This can cause it to move slower.
  • Can I uninstall VirtualBox when I'm done using it for a class?
    • Yes, you can uninstall from your computer by following these steps:
      • Open the VirtualBox program
      • Right-click on Windows2004 on the left side
      • Click Remove > Delete all files
      • Allow VirtualBox to finish deleting the file
      • Once that's removed, go to your Applications folder (Cmd+Shift+A while on the Desktop)
      • Drag and drop VirtualBox to the trashcan
  • Are there any other options to use @Risk, PrecisionTree, or other Windows specific programs if I don't want to install this big program?
    • The computers in the MOD Lab and NRG all have these applications available for use.

Stattools 7


Stattools Excel Mac Download Version

If you have any other questions or need help with the installation, please contact the McCombs Service Desk at 512-232-6616 or submit a help ticket at https://www.mccombs.utexas.edu/tech