App Icon
Frontline Systems Inc.
•  2,008,442
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:
Profile Picture
Jeffrey Martin
April 15, 2021
Doesn't work, it hasn't been updated for ages
Is this review helpful?
Yes
No
Profile Picture
Aurick Yudha Nagara
April 12, 2021
great wow
Is this review helpful?
Yes
No
Profile Picture
Connor McSherry
April 10, 2021
I have been using this add-on for years and haven't had any issue
Is this review helpful?
Yes
No
Profile Picture
JUSTINE ELISE SARMIENTO
April 5, 2021
This is really helpful and is very convenient once you get the hang of navigating and using all of the functions!
Is this review helpful?
Yes
No
Profile Picture
Ernst-Joerg Oberhoessel
March 1, 2021
This is to confirm that this add-on still exists and is working! I was very worried about all the negative reviews stating that it would not connect. FYI: I am using a regular free Gmail account, and it works (I used only the basics)
Is this review helpful?
Yes
No
Profile Picture
TMU Faculty Dr.Chanchal Chawla
February 16, 2021
Not working on google sheets
Is this review helpful?
Yes
No
Profile Pciture
Wei Sheng
March 16, 2021
Hey, if you find this add-on not working, you can try searching and installing the Logic Sheet Google Sheets add-on, which offers free statistics functions including ANOVA, correlation, covariance, and descriptive statistics, and more. Thanks!
Profile Picture
lucas delap
February 4, 2021
It does open, and it does work
Is this review helpful?
Yes
No
Profile Picture
Zayne James
January 28, 2021
Bingus
Is this review helpful?
Yes
No
Profile Picture
CHAIMA MOUDEN
January 28, 2021
does not work
Is this review helpful?
Yes
No
Profile Picture
jesus alonso redondo
January 15, 2021
ok. Conforme con la aplicacion. Nada que objetar
Is this review helpful?
Yes
No
1-10 of 42
Additional information
Frontline Systems Inc.
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu