Meet StatPlus:mac LE — a free edition of StatPlus:mac Professional developed by AnalystSoft. If you are using a Mac and Microsoft Excel 2004–2019 for Mac or Apple Numbers for daily analytical and statistical purposes, StatPlus:mac LE is exactly what you need to get started! Get a powerful statistical tool for free – now with a set of new essential features - without leaving Excel.
Analysis Toolpak for Mac. This handy add-on replaces Microsoft Analysis Toolpak in Excel 2008-2019 for Mac. It features a detailed migration guide for users switching from Analysis Toolpak to StatPlus:mac and has the Excel interface you already know! StatPlus:mac LE is fully compatible with Excel 2004—2019 and is the Microsoft recommended. Analysis Toolpak for Mac. This handy add-on replaces Microsoft Analysis Toolpak in Excel 2008-2019 for Mac. It features a detailed migration guide for users switching from Analysis Toolpak to StatPlus:mac and has the Excel interface you already know! StatPlus:mac LE is fully compatible with Excel 2004—2019 and is the Microsoft recommended. Download Toolpak Excel, free download toolpak excel software downloads. If you're using Excel for Mac, in the file menu go to Tools Excel Add-ins. In the Add-Ins box, check the Analysis ToolPak check box, and then click OK. If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it. The Analysis ToolPak in Excel 2010. Steps for a user to manually install Analysis ToolPak in Excel: Click on File ribbon. Click on Options. From Options, select Add-Ins. Select Analysis ToolPak and click on Go button. You can see 4 Add-Ins options are available, check the Analysis ToolPak. Click on OK button. In the Add-ins available box, select the Analysis ToolPak - VBA check box. Note: The Analysis ToolPak is not available for Excel for Mac 2011. See I can't find the Analysis ToolPak in Excel for Mac 2011 for more information. Follow these steps to load the Analysis ToolPak in Excel 2016 for Mac: Click the Tools menu, and then click Excel Add-ins.
Try the free version now and find out why - statistically - most people stop looking for any other tools once they find StatPlus:mac!
FREE DOWNLOADCOMPARE TO PRO
By installing this software you accept all the terms and conditions of the end user license agreement provided here.
No matter if you are an experienced user migrating from a familiar toolset or a novice exploring the capabilities of the new software, StatPlus:mac LE gives you an easily configured workspace with a vast array of tools. This free application demonstrates qualities typically only available in costly specialized suites – consistency and accuracy of results, reliability, plenty of data analysis models and tools, various data types, graphs, charts and much, much more.
Analysis Toolpak for Mac
This handy add-on replaces Microsoft Analysis Toolpak in Excel 2008-2019 for Mac. It features a detailed migration guide for users switching from Analysis Toolpak to StatPlus:mac and has the Excel interface you already know! StatPlus:mac LE is fully compatible with Excel 2004—2019 and is the Microsoft recommended replacement of its own Analysis Toolpak module.
Upgrade to Pro
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).
Compare Features or Upgrade To PRO
Register For More Benefits
Free Excel Analysis Toolpak Download
Register now with no obligation and learn more! As a registered customer you will be able to access to latest versions of StatPlus:mac LE and documentation, get basic support and even win free upgrade to Pro version.
Free For Your Project
StatPlus:mac LE is free of charge with no hidden catch - there are no ads, time limits or variable/cases count limits. Should you have any questions, please feel free to contact our Support Team.
Standard Solution
Universities, scientific centers, public agencies and research institutes worldwide have already chosen StatPlus:mac as a standard statistical tool and are now reaping the benefits of it versatility, reliability, speed and compatibility with the popular Microsoft Office environment.
Requirements
StatPlus:mac requires macOS 10.9 or newer (v6 requires 10.7+). macOS 11 Big Sur is supported. StatPlus:mac supports Microsoft Excel for Mac (supported versions: 2004, 2008, 2011, 2016, 2019; Office 365 for Mac v16) and Apple Numbers v3/4/5 as a data source. StatPlus:mac does not require Internet connection (except for optional auto-update feature).
Looking For More?
Upgrade now to Pro version and get over 70 features and multi-platform compatibility. StatPlus:mac is most affordable solution for data analysis on Mac with Excel. 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.
Free or Premium? Features Comparison — StatPlus:mac Pro vs. LE
- Only in StatPlus:mac Pro.
- Available in free LE version.
- 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.
- 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.
- Hierarchical Clustering and K-Means.
- 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.
Tutorials
Find out how to use StatPlus:mac. Tutorials for current version v6 coming soon.
If it’s in the Add-Ins Available box, make sure Analysis tool pack is checked and hit OK to activate. Allow it to install if necessary. Follow these steps to load the Analysis ToolPak in Excel 2016 for Mac: Click the Tools menu, and then click Excel Add-ins. In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK. How To Enable the Data Analysis Toolpak in Excel (Windows & Mac) The Excel Data Analysis toolpak should be enabled by default on every lab computer and computer available for checkout from the library. However, someone may have gone through and disabled the Toolpak for whatever reason, or the.
As the article suggests, today we will learn how to add Analysis ToolPak in Excel For Mac and Windows PCs. So let's get started.
The Analysis ToolPak is an add-on in Microsoft Excel. By default, this add-in is not installed in Excel.
To install Analysis toolpak in Excel for Mac, follow below steps. Goto tools or Insert menu. Locate Add-Ins and Click on it. You’ll be prompted to choose from available add-ins. Select Analysis Toolpak. Excel Analysis Toolpak for Mac If your a student such as myself and use a Mac, you have probably run into a few complications in certain course work. To save you sometime researching your different options, I have found a few different ways you can access the Excel Analysis Toolpak on your Mac. Cause: Excel 2011 does not include the Analysis ToolPak. Solution: Download StatPlus:mac LE for free from AnalystSoft, and then use StatPlus:mac LE with Excel 2011. That last link used to include loads of comments from disgruntled Office for Mac users, but Microsoft seems to have removed comment functionality from that help center article.
Analysis toolPak of excel contains very helpful tools for statistical, financial, and engineering data analysis.
How to Add Analysis ToolPak to Excel 2016 in Windows?
To install the Analysis toolPak in Excel 2016 follow these steps.
- Click on file.
- Click on option. You’ll see the excel options dialogue box.
- Click on Add-Ins. It is on the left, second option from the bottom.
- Locate Analysis ToolPack and click on it.
- In the bottom, you must be able to see manage drop down. Select Excel-Add-ins and click on Go button.
- All available Add-ins will be shown to you. Select Analysis Toolpak and click OK.
Analysis ToolPak is added now. You can see it in the Data tab in the rightmost corner.
How to Add Analysis ToolPak in Excel 2016 for Mac?
To install Analysis toolpak in Excel for Mac, follow below steps.
- Goto tools or Insert menu.
- Locate Add-Ins and Click on it.
- You’ll be prompted to choose from available add-ins. Select Analysis Toolpak.
- Click Ok.
Analysis Toolpak is added. Goto data tab. In the rightmost corner you’ll find Analysis Toolpak waiting for you.
Analysis Toolpak has a number of useful statical tools that we will explore in our that we have explored in analysis tutorials.
The Analysis ToolPak in Excel 2010
Steps for a user to manually install Analysis ToolPak in Excel:
- Click on File ribbon
- Click on Options
- From Options, select Add-Ins
- Select Analysis ToolPak and click on Go button
- You can see 4 Add-Ins options are available, check the Analysis ToolPak
- Click on OK button
- When you check Data ribbon, this time you will see Data Analysis option appears in Analysis Group.
- When you click on Data Analysis, you will find the dialog box as shown below:
There are a total of 19 options available in the Data Analysis:
1. Anova: Single Factor
2. Anova: Two-Factor with Replication
3. Anova: Two-Factor without Replication
4. Correlation
5. Covariance
6. Descriptive Statistics
7. Exponential Smoothing
8. F-Test Two Sample for Variance
9. Fourier Analysis
10. Histogram
11. Moving Average
12. Random Number Generation
13. Rank and Percentile
14. Regression
15. Sampling
16. t-Test: Paired Two Sample for Means
17. t-Test: Two-Sample Assuming Equal Variances
18. t-Test: Two-Sample Assuming Unequal Variances
19. Z-Test: Two-Samples for Mean
An add-in is simply a hidden tool that adds new features in Microsoft Excel 2010 and 2013.
Related Articles:
Popular Articles:
How to Use the Analysis ToolPak in Excel 2019
You would use this tool if you want more statistical analysis on your data. Excel 2019 isn't made for hardcore statistics. It's more of a simple data storage and analysis application based on formulas you create. Complex formulas can be difficult to create in Excel, and there is no reason to recreate what has already been done using the Analysis Toolpak. The Toolpak is mainly used by statisticians that want to perform calculations for t-tests, chi-square tests and correlations. With Excel, a non-statistician can perform these actions without knowing the formulas to create them. Even a statistician can take advantage of these tools by saving time writing formulas for complex analysis.
The Analysis Toolpak has several tools. Some are more commonly used than others, and some of them are better understood by laymen that just need simple analysis. The common ones that are closer to basic analysis will be explained in this article.
Installing the Analysis Toolpak
Installing the Analysis Toolpak is similar to installing the Solver tool. With your spreadsheet file open, click the 'File' tab, which brings you to a window where you can set configurations on your global Excel interface. Click the 'Options' button located in the left-bottom corner.
(Options button)
A window opens where you can configure Excel preferences including add-ins. Click the 'Add-Ins' in the left panel.
(Excel 2019 configuration window)
The 'Add-ins' window shows the currently installed add-ins, but it's also the place where you can install new plugins. In the 'Manage' section, make sure the 'Excel Add-ins' option is selected, and then click the 'Go' button. A window opens where you choose the add-in that you want to install.
(Add-ins install choices)
If you already installed the Solver add-in, you'll see that it's checked. To install the Analysis Toolpack tool, check the box next to its name and click 'OK.' If it's already installed, the tool will have a checkmark next to it. If it's already installed, you can click 'Cancel' to close the window as well.
It takes only a few seconds for the Analysis Toolpak tool to install, and when Excel is finished installing it, you're returned to the main Excel interface. Return to the worksheet that contains your data, and you're now ready to use the tool for analysis.
Using the Analysis Toolpak
After installing the tool, the button to use it is found in the same location as the Solver tool. Click the 'Data' tab in the main Excel interface, and the 'Data Analysis' button can be found in the 'Analyze' section of the menu.
How To Get The Tool Analysis Toolpak For Excel Machining
(Data Analysis button)
Clicking the 'Data Analysis' button opens a window where all analysis tools are shown. You choose one of these tools, and then a new window will open that asks you to enter configurations specific to the chosen tool.
(Choose a tool)
When you look in the list of tools, you might wonder which one to choose. The one you choose depends on your goals and the information that you want to analyze. After a description of common tools, then you can make a decision on the tool that is best for your spreadsheet and goals.
Descriptive Statistics: The Descriptive Statistics tool is probably the simplest and easily understood option for viewers who need to get a mean, median, variance and standard deviation. It also offers a variety of other statistic options, but these values are the most common users are interested in when they are looking for information from worksheet data.
The mean is the average value. It's a statistician's way of explaining the average. The median is the middle value in a set of numbers. Standard deviation explains how spread apart numbers are from the mean. It's a way to get an average with values that are close to this average to give you an idea of what is standard vs values that stand as outliers. Variance is related to standard deviation as standard deviation is the square root of variance. Variance is the squared value of the average of all values.
You can get a better idea of these values looking at an example. The example spreadsheet has a list of values that represent membership fees for the month of February. You can get an average from these numbers, a median and get an idea of what days are outliers using the Descriptive Statistics tool.
Click the 'Descriptive Statistics' option in the Analysis Toolpak list of tools and click 'OK.' A window opens where you configure the tool.
(Descriptive Statistics configuration)
Download Analysis Toolpak Excel Mac
The Descriptive Statistics tool requires an input range and the location of where you want to display output. The cell range that contains the total amount of revenue made for each day will be analyzed. This cell range should be entered in the 'Input Range' text box. These values are organized as a column, so the default 'Grouped By' value of 'Columns' can be left as is. If you have values in a row of cells, this value would be switched to 'Rows.'
This column of values has a header cell, so check the box labeled 'Labels in First Row' so that the Analysis Toolpak tool knows to treat it as a header and not part of the data. The 'Output Range' option lets you choose a range of cells where the tool will give you output after its analysis. You'll need at least 2 columns to print out a summary, so make sure the output range has enough room for Excel to print out results.
Finally, check the box labeled 'Summary' statistics to get a brief summary of your analyzed data. Then click the 'Confidence Level for Mean' and leave the default value at '95,' which is already filled out for you. After you are done configuring the tool, click 'OK' and Excel takes a few seconds to analyze data and display it in the output cell range that you specified in the configuration window.
(Descriptive Statistics report)
Analys32.xll
The report gives you values for several statistical data points. The mean is the average and usually the most important value in this report that most reviewers are looking for. The average in this report is about 18.5, which means that the average revenue for the data range is $18.50 for the month.
Median and Mode in this report are the same number. The median is the middle value in the list of values. The Mode is the value that appears the most in the list of values. The standard deviation helps you identify outliers. You add the standard deviation to the mean, and then subtract the standard deviation value to the mean. This gives you a range of values that you can identify as standard revenue for the month of February.
The minimum and maximum are the highs and lows in your data range. The sum value is just the added values to give you a total, and the count is the number of values within the range. Use this Analysis Toolpak tool to get basic statistic information from your data, and it's one of the easiest tools to you. It's the most used of all the tools because it's simple data that can be easily understand by business owners.
The t-Test Tool
A t-test is beneficial when you want to compare two sample data points. In Excel 2019, it's useful when you want to compare two columns or two rows. For instance, you might want to compare values before and after an event or before and after a marketing campaign.
In the example spreadsheet, there are two columns with different revenue. The sliding fee column displays revenue based on the amount of revenue affecting the payment fee. The 'New Revenue' is an altered version of revenue based on goal tools. You can do a comparison between the two columns using a t-test. You could write your own formula and set up each cell individually and manually, or you can use Excel's Analysis Toolpak tool.
Click the 'Data Analysis' button to open a window with a list of tool choices.
(Analysis Toolkit options)
How To Get The Tool Analysis Toolpak For Excel Machine
Choose the tool named 't-Test: Paired Two Sample for Means' and then click the 'OK' button. This selection opens a new configuration window where you set up the tool to work with your data.
(T-Test configuration)
The 'Input' section contains input text boxes where you choose the two columns to compare. In this example, the sliding fee column will be compared to the new revenue column to determine the basic difference between the two. Enter the cell range for the first column in the 'Variable 1 Range' text box. Then, enter the second cell range in the input text box labeled 'Variable 2 Range.'
Change the 'Output options' section to the 'Output range' option so that you can see the report results in the same worksheet. After you are finished configuring the t-test tool, click the 'OK' button to run the analysis. It only takes a few seconds for Excel to generate the report and display it in the selected output cells.
(T-Test results)
The most important output to get out of this report is the mean value. This value lets you see the average difference between the two columns. Using the comparison, you can determine which section has the best average between the two and lets you determine which column of values have the best output for your decision-making results.
Take note of the 'P(T<=t) one-tail' value. This is your P value. If this value is less than .05, then your values are significantly different and possibly unrelated, so you should choose different cell range values to work with your analysis.
The ANOVA Tool
The ANOVA tools in Excel 2019 analyze variance. Variance is important in statistics because it determines outliers in data and gives you a bigger picture of relevant data. The ANOVA tool lets you identify if there is a relationship between two sets of data. For this example, the ANOVA single factor tool will be used, but you can use ANOVA tools for two-factor analysis similar to a t-test. The two-factor version of the ANOVA tool checks two independent variables, and you can indicate that you want to use a tool with or without replication. For simple analysis of two dependent variables, you use single factor. Take note that single factor is for dependent variables and any two-factor tools are used on independent variables.
Click the 'Data Analysis' button again. The same window opens where you choose a tool. Choose 'ANOVA: Single Factor' and a new configuration window displays. Webex tool for mac. This window is where you configure the tool's input to determine the report results.
(ANOVA configuration)
In the configuration window, you choose an input range. This range should be two adjacent columns. The sample spreadsheet has columns of revenue based on membership fees. Because they are dependent, this analysis tool is best for this worksheet data. Choose one of the column cell ranges, and then leave the 'Columns' option in the 'Grouped By' section.
Change the 'Output options' section to the 'Output Range' open and choose the cells where you want to display your output. After you are finished configuring your tool settings, click the 'OK' button to run the report. Excel runs the report quickly when you only have a few values to analyze. The result is displayed in the selected output cells.
(ANOVA report)
The summary section displays a comparison chart of the two columns, but the value to take note of is the P value. Again, if this value is below .05, then you have unrelated data and these values should be adjusted. You would then need to choose a different set of records, select them and re-run the ANOVA report.
How To Get The Tool Analysis Toolpak For Excel Macros
The Analysis Toolpak has numerous other reports, but these tools are the most common and most useful for users who are looking for some quick analysis on data. You can test other tools by selecting them in the data analysis tool selection window, configuring values located in your spreadsheet and running a new report.