App Icon
Statistical analysis in Google Sheets, with functions matching the Analysis ToolPak in desktop Excel.
Works with:
2,164,525
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.
Additional information
PricingNot available
Privacy policy
Terms of service
XLMiner Analysis ToolPak will ask for the permissions shown below. Learn more
XLMiner Analysis ToolPak will need access to your Google account
This will allow XLMiner Analysis ToolPak to :
Display and run third-party web content in prompts and sidebars inside Google applications
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Picture
A User of XLMiner Analysis ToolPak
March 15, 2015
Topically it looks exactly like what I need, but it doesn't seem to be appearing. Is there not yet support for the new Google Drive or should that not stop it from working? EDIT: I guess the new google sheets isnt the problem. I have no idea why this isn't working for me. Tried on other computers as well, same result. Add on is completely blank. Could use some support.
Is this review helpful?
Yes
No
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Picture
A User of XLMiner Analysis ToolPak
February 23, 2015
Linear Regression formula does not always calculate as commanded. I've checked and rechecked, and this is not the result of user error.
Is this review helpful?
Yes
No
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Picture
A User of XLMiner Analysis ToolPak
March 16, 2015
Worked great for the descriptive statistics function I needed. Thanks for porting this to Google Sheets!
Is this review helpful?
Yes
No
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Picture
A User of XLMiner Analysis ToolPak
November 1, 2018
I tried using it for descriptive statistics and it didn't work.
Is this review helpful?
Yes
No
1-10 of 47
Search
Clear search
Close search
Google apps
Main menu