Help & Support
Send Feedback
XLMiner Analysis ToolPak
Statistical analysis in Google Sheets, with functions matching the Analysis ToolPak in desktop Excel.
172,519 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.
Please visit the Chrome Web Store if you would like to reply or rate a review for this app.
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.
Submit reply
Cancel
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.
Submit reply
Cancel
A User of XLMiner Analysis ToolPak
November 1, 2018
I tried using it for descriptive statistics and it didn't work.
Submit reply
Cancel
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.
Submit reply
Cancel
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.
Submit reply
Cancel
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.
Submit reply
Cancel
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.
Submit reply
Cancel
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.
Submit reply
Cancel
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.
Submit reply
Cancel
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.
Submit reply
Cancel
1-10 of 18
Additional information
Search
Clear search
Close search
Google apps
Main menu