Beyond Basic Statistics in Excel

Advanced Statistical Analysis and Forecasting

Solver for Excel 2011 for Mac matches the functionality and user interface of Solver for Excel 2010 for Windows. Excel workbooks containing Solver models and VBA macros controlling Solver can be created in Windows and used on the Mac, and vice versa. This free Mac application is an intellectual property of Microsoft. The program lies within Productivity Tools, more precisely Office Tools. The most popular versions among Microsoft Excel for Mac users are 14.0, 12.3 and 10.1. This program's bundle is identified as com.microsoft.Excel.

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.

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.

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:

An add-in enhances or works with Office 2011 for Mac software in some way. Add-ins are sometimes called plug-ins or add-ons. Here are three examples of excellent commercial-quality add-ins that work with Mac Office:

• EndNote (www.endnote.com): A high-end bibliography product for Microsoft Word.

• MathType (www.dessci.com/en/products/MathType_Mac): The full version of Equation Editor that’s included in Office. It lets you put mathematical symbols in Word, Excel, and PowerPoint.

• TurningPoint (www.turningtechnologies.com): Use clickers to capture audience responses in real time and present the results on PowerPoint slides. This software is used in classrooms, quiz shows, marketing studies, and more.

Many add-ins made for Office for Windows can work on your Mac, so be sure to check their system requirements. Almost all add-ins can be made Mac-compatible with a little effort, but you may have to request the developer of a nonfunctioning add-in to make that extra effort.

You can put add-ins anywhere in Finder. If you want to make an add-in available to all Mac OS X user accounts on a computer, put them into Applications:Microsoft Office 14:Office:Add-Ins. The Documents folder is a good place to put add-ins to be used by a particular OS X user account.

A few commercially produced add-ins are installed using the Mac OS X installer program. Because making an installer is an art of its own and takes extra time and effort on the add-in developer’s part, you install most add-ins manually using the Add-Ins dialog in Office.

A Word add-in is a template file that contains VBA (Visual Basic Editor) code. You can add such a template to the Templates and Add-Ins dialog. In PowerPoint and Excel, an add-in has a special file extension and is not necessarily a template.

To open the Add-Ins dialog, here’s what you do:

• Word: Choose Tools→Templates and Add-Ins.

• Excel and PowerPoint: Choose Tools→Add-Ins.

• Word, Excel, and PowerPoint: Click the Developer tab on the Ribbon and then click Add-Ins→Add-Ins.

When you have the Add-Ins dialog open, you can do the following simple tasks to add, remove, load, and unload add-ins:

• Load: Same as selecting the check box next to the add-in’s name. Loading also runs the add-in. (Available only in Excel and PowerPoint.)

• Unload: Same as deselecting an add-in’s check box. Unloading disables the add-in. (Available only in Excel and PowerPoint.)

• Add: Click to open the Choose a File browser, where you can browse to an add-in template in Finder and add your add-in to the list.

• Remove: Click to remove the selected add-in from the list.

In Word, when you select an add-in’s check box or click the Add button, you load the template, thereby making the VBA routines that it has available globally within all open documents in Word. A loaded template is called a global template. Revisit the Templates and Add-Ins dialog to re-load your template(s). To disable an add-in, deselect its check box or click the Remove button.

Decision Tools For Excel Mac 2011 Freeze Top Row

Excel and PowerPoint add-ins are also loaded and unloaded using check boxes. When you close Excel or PowerPoint, add-ins that were loaded at closing reload themselves when you reopen the application.