App Icon
Statistical analysis in Google Sheets, with functions matching the Analysis ToolPak in desktop Excel.
Works with:
2,766,671
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
Developer
Trader status unspecified
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:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
ルリ
February 3, 2023
for some reason it doesnt work. only works on very small data at least for me but for some reason it works on my friend with literally same dataset. tried to uninstall and reinstall. still same problem
Is this review helpful?
Yes
No
Profile Picture
Tim Schmelmer
January 28, 2023
This is working super-well. Just having issues trying to get the plots to show up.
Is this review helpful?
Yes
No
Profile Picture
John Elder
January 11, 2023
Works reasonably well for small datasets. The input fields are very fiddly, so make sure that you actually have the right range selected. It bogs down when you start getting into n>50 or so, and I imagine it would be completely useless and possibly crash if n>200. If you're working with datasets that big, spring for a real statistics package. That said, it works well for my high school students' projects that have relatively small sample sizes.
Is this review helpful?
Yes
No
Profile Picture
Louis Gabriel Alcantara Dimaranan
February 7, 2023
Its Broken after one day of use, tried reinstalling it and it didn't work, doesn't work with others as well. Complete trash
Is this review helpful?
Yes
No
Profile Picture
Muhamad Ridho Maulana Mustaqim
May 3, 2022
It worked on smaller data, it doesn't (or maybe real slow) with big one. I think they need to add "loading" screen when clicking "Ok" button so that we know that it's processing something.
Is this review helpful?
Yes
No
Profile Picture
Mauricio Bernardo da Silva
September 20, 2022
Totally unreliable. Most requests don't work (they don't return anything).
Is this review helpful?
Yes
No
Profile Picture
Kaitlyn Griswold
September 19, 2022
Worst Science program ever, worked once and then immediately stopped working for my entire classand I, do not use this program if you want to get an A on your science paper. I can't believe Frontline Systems Inc would ever release such a poorly programmed tool/ extension, this company has lost my trust from here on out, I will never buy another product from this god-forsaken company.
Is this review helpful?
Yes
No
Profile Picture
Felipe Andres Peña Rincon
February 25, 2023
Crash after n=280.
Is this review helpful?
Yes
No
Profile Picture
Rahman Malik Azis
May 29, 2022
idk why this tool just cant process my data, garbage 1/10
Is this review helpful?
Yes
No
Profile Picture
Insert Name
December 20, 2022
Linear Regression stopped working after a few uses
Is this review helpful?
Yes
No
1-10 of 57
Search
Clear search
Close search
Google apps
Main menu