XLMiner Analysis ToolPak - Google Workspace Marketplace

Statistical analysis in Google Sheets, with functions matching the Analysis ToolPak in desktop Excel.

By:

Works with:

2M+

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

Support

ReportFlag as inappropriate

Reviews

Language:

Sort by:

Google doesn't verify reviews or ratings. Learn more about reviews

Chuck Becker

February 14, 2024

Doing simple descriptive statistics on a single column of integers, I got it to work for something less than 5000 rows. But it fails (without any sort of error message) on data sets larger than that, unless the calculation time increases exponentially. I had high hopes for this because as little analysis as I do, it's not easy to remain fluent in R. I'm not sure this is very useful in GSheets.

Is this review helpful?

Yes

Josh Gossett

March 5, 2024

it doesn't work

Is this review helpful?

Yes

AFRIN FOWMITHA S

September 11, 2023

WAIT I STILL DIDN'T WORK IN IT LET ME RATE AFTERWARDS

Is this review helpful?

Yes

Stephanie Mohammad

May 17, 2023

Wanted to use for my intro stats class. Close, but not clean enough to use for class. Degrees of freedom calculation is wrong in t-Test: Two-Sample Assuming Unequal Variances option. (n1+n2-3 instead of n1-n2-2). Could you fix this? Or can I adjust something as a user?

Is this review helpful?

Yes

Daria Simonova

November 23, 2023

Does not work

Is this review helpful?

Yes

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

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

ルリ

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

Ralph Gardner

August 29, 2023

Exponential Smoothing works for 3000 observations. Doesn't have instructions that I could find.

Is this review helpful?

Yes

Jude Watt

February 12, 2024

poop

Is this review helpful?

Yes

1-10 of 65

Clear search

Close search

Google apps

Main menu