Frontline Systems Inc.
•  1,494,968
Overview
Statistical analysis in Google Sheets, with functions matching the Analysis ToolPak in desktop Excel.
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
Language:
Sort by:
Charles Guise-Brown
July 24, 2020
Yes
No
A user of XLMiner Analysis ToolPak
August 4, 2020
Still disabled -- I need this add-on for my online course with Wharton via Coursera. Please address!
A user of XLMiner Analysis ToolPak
August 2, 2020
I could really make use of this Add On but having the same issue as everyone else... Sign in with Google temporarily disabled. I'd hate to go back to Excel to enable ANOVA features.
A user of XLMiner Analysis ToolPak
August 1, 2020
I am as well, how do we get in touch with google?
A user of XLMiner Analysis ToolPak
July 30, 2020
I am having the same problem
A user of XLMiner Analysis ToolPak
July 29, 2020
Same issue here too!
A user of XLMiner Analysis ToolPak
July 29, 2020
Same issue here. I am trying to install this addon but Google denies it to me.
A User of XLMiner Analysis ToolPak
July 22, 2020
I loved this add-on as it made Google Sheets almost as versatile as Excel. PLEASE verify this add-on as this is the only tool with which I could do linear regression in Google sheets.
Yes
No
A user of XLMiner Analysis ToolPak
July 24, 2020
I was really counting on this tool for my classes this fall! It gets me to 90% of what I need students to do for lab and everyone has easy access. GOOGLE PLEASE VERIFY!
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.
Yes
No
A user of XLMiner Analysis ToolPak
July 22, 2020
A user of XLMiner Analysis ToolPak
July 19, 2020
A user of XLMiner Analysis ToolPak
July 8, 2020
No verification since April 2020? What's going on here? Google - why don't you offer a Google Analysis ToolPack in this case?
A user of XLMiner Analysis ToolPak
July 7, 2020
Ditto. Can't install since it's not verified.
A user of XLMiner Analysis ToolPak
July 5, 2020
Hello this app has STILL not been verified by google. Please fix! This is an essential add-on for people in finance or economics, especially if they don't have excel. Please fix!
A user of XLMiner Analysis ToolPak
July 2, 2020
Hey man can you please verify this, I had an important submission.
A user of XLMiner Analysis ToolPak
June 27, 2020
I don't quite know why, but I am unable to download this extension.
A user of XLMiner Analysis ToolPak
June 23, 2020
HEY GOOGLE! Please verify this app! I haven't had this issue with any other extension I've installed. I tried researching other possible alternatives but to no avail. This is the only extension that will perform data analysis' like anova, paired t-test, descriptive statistics, etc. It meets all of our researcher and statistic needs!
Subhrant Kumar Nag
June 10, 2020
Dear Friends in Google, please verify this Toolpack, or release something sooner
A user of XLMiner Analysis ToolPak
May 31, 2020
Why XLMiner is not verified app , i have Chrome book ,not able to do my stats class sue to absence of app.
A user of XLMiner Analysis ToolPak
May 27, 2020
A user of XLMiner Analysis ToolPak
May 19, 2020
Same here, hey Google verify the app, users here complaining
A user of XLMiner Analysis ToolPak
May 19, 2020
A user of XLMiner Analysis ToolPak
May 16, 2020
A user of XLMiner Analysis ToolPak
May 8, 2020
A user of XLMiner Analysis ToolPak
May 5, 2020
A user of XLMiner Analysis ToolPak
May 1, 2020
A user of XLMiner Analysis ToolPak
April 20, 2020
A user of XLMiner Analysis ToolPak
April 19, 2020
I hope this able to work for me. I may be able to use this for my class. I am taking a Statistics class for my current term in Grad School. The only thing is, I am getting an error message saying "not verified by Google." I really hope you can verify this expeditiously so I can use this add-on for my class this term!
A user of XLMiner Analysis ToolPak
April 14, 2020
NOT VERIFIED BY GOOGLE SORT THIS OUT ASAP
A user of XLMiner Analysis ToolPak
April 13, 2020
A user of XLMiner Analysis ToolPak
April 5, 2020
A user of XLMiner Analysis ToolPak
April 5, 2020
I had an online chat with Frontier . They told me Google is holding app back since Dec 2019.... Need to hound Google to get this back......If they found a problem with this app then why do they still have it on the list....???
A user of XLMiner Analysis ToolPak
April 4, 2020
A user of XLMiner Analysis ToolPak
March 30, 2020
I too am getting error "Sign in with Google temporarily disabled for this app" and "This app has not been verified yet by Google in order to use Google Sign In." When will this be fixed? I need this for a school project. Thanks.
A user of XLMiner Analysis ToolPak
March 15, 2020
A user of XLMiner Analysis ToolPak
March 9, 2020
A user of XLMiner Analysis ToolPak
March 1, 2020
Try it with microsoft office excel online. It works there
A user of XLMiner Analysis ToolPak
February 28, 2020
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.
Yes
No
A User of XLMiner Analysis ToolPak
November 1, 2018
I tried using it for descriptive statistics and it didn't work.
Yes
No
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.
Yes
No
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.
Yes
No
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.
Yes
No
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.
Yes
No
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.