Help & Support
Send Feedback
XLMiner Analysis ToolPak
Statistical analysis in Google Sheets, with functions matching the Analysis ToolPak in desktop Excel.
1,889,513 users
Works with
Install
Overview
```With the XLMiner Analysis ToolPak Add-on, you can easily perform statistical analyses of the same types available in the Analysis ToolPak add-in that has been part of Microsoft Excel for over 20 years, and has been featured in large numbers of textbooks, videos, statistics courses and the like.

The add-on provides all 19 interactive functions included in the Excel Analysis ToolPak, plus a 20th function often requested by users, logistic regression.  Sidebar input fields and output on the spreadsheet will be very familiar to Excel Analysis ToolPak users.

The 20 functions are:
ANOVA: Single Factor
ANOVA: Two-Factor with Replication
ANOVA: Two-Factor without Replication
Correlation
Covariance
Descriptive Statistics
Exponential Smoothing
F-Test Two-Sample for Variances
Fourier Analysis
Histogram
Linear Regression
Logistic Regression
Moving Average
Random Number Generation
Rank and Percentile
Sampling
t-Test: Paired Two-Sample for Means
t-Test: Two-Sample Assuming Equal Variances
t-Test: Two-Sample Assuming Unequal Variances
z-Test: Paired Two-Sample for Means

Results will generally match the Excel Analysis ToolPak, as seen in many textbooks, screen images and videos.  The add-on's Random Number Generation function uses the Mersenne Twister algorithm.
```
Reviews
A User of XLMiner Analysis ToolPak
May 3, 2019
I really need help, I put in the data, filled in one factor anova box, and still I don't see anova test.
A user of XLMiner Analysis ToolPak
February 5, 2020
I am having the same problem - the sign in with google is temporarily disabled for this app and I am trying to do a high school project with my students with a multivariable regression analysis - any hope??
A user of XLMiner Analysis ToolPak
February 1, 2020
Have the same problem "Sign in with Google temporarily disabled for this app". Can somebody anwser this query?
A user of XLMiner Analysis ToolPak
December 17, 2019
Also attempting ANOVA analysis. I can't even install the extension with the following: "Sign in with Google temporarily disabled for this app - This app has not been verified yet by Google in order to use Google Sign In."
Tony Gozdz
December 14, 2018
I'm using the add-on to create histograms--it works, but there are two issues: the cell entry is, so to speak, peculiar (try it to see what I mean...), and the utility runs slower than an IBM PC in 1983... It took 30 s to bin 2000 data points; it takes a second in Excel.
A User of XLMiner Analysis ToolPak
November 1, 2018
I tried using it for descriptive statistics and it didn't work.
A user of XLMiner Analysis ToolPak
December 3, 2018
It does simple linear regression and multiple linear regression but does not calculate R-squared value. Any thoughts?
A User of XLMiner Analysis ToolPak
September 15, 2018
Attempted to use the regression tool multiple times yet it never once worked. I uninstalled and reinstalled multiple times and it never output any results or any indication that an error occurred.
A User of XLMiner Analysis ToolPak
April 17, 2018
The regression tool worked once...then wouldn't work. I deleted the add on, and re added it. It again worked one time, then stopped. I guess it is a one use application? I tried deleting and re-adding again, but it didn't work. I had to dust off a copy of Excel 2007. Please make this work so I can leave Microsoft forever.
A User of XLMiner Analysis ToolPak
March 29, 2018
I used for linear regression, it seemed to work a couple of times but it was always super slow then it stopped working altogether and I don't know why.
A User of XLMiner Analysis ToolPak
February 19, 2018
I'm using xlminer for multi-variable linear regression. The tool doesn't provide any feedback to indicate whether it is calculating or doing nothing, making the tool very difficult to work with. For example, if I change something and want to re-calcuate, do I need to close the side bar and restart the tool from scratch? Because I can't tell if clicking on the 'ok' button is just really slow or isn't doing anything at all. Also, the tool is very slow. I'm working on less than 150 rows.
A User of XLMiner Analysis ToolPak
June 2, 2017
Is there a row limit for this addon? Using the t-test I get results for 500 values but after that I get no output at all.
A User of XLMiner Analysis ToolPak
June 13, 2016
The functions I've used - ANOVA and t-test - have worked extremely well. The interface is simple and intuitive.
A User of XLMiner Analysis ToolPak
May 20, 2016
Liked it. Sometimes encounter a problem where t F-test does not compute.. at all. Other tests works fine.
A user of XLMiner Analysis ToolPak
December 13, 2019
IT'S UNVERIFIED
1-10 of 18