Maio Apps

XLMiner Analysis ToolPak not working in Google Sheets?

It opens with only a Help button, or not at all. You are not doing anything wrong. Here is what is going on and what to use instead.

Get Sidestat, the free replacement

What is happening

XLMiner Analysis ToolPak was the add-on most statistics classes used for t-tests, ANOVA and regression in Google Sheets. Since about March 2026, most people who open it see only a Help button and no tools. Almost every review on its Marketplace page since then says the same thing, and the listing has not been updated since May 2024.

The add-on is not something you broke. It stopped working for most people at about the same time, in the middle of a school year, which is why so many students are searching for this right now.

Quick checks (two minutes)

These rarely bring it back, but they rule out the simple causes:

  1. Reload the sheet, then open Extensions and look for the add-on there.
  2. Sign out of other Google accounts in the browser, or open the sheet in a private window.
  3. Remove the add-on (Extensions > Add-ons > Manage add-ons) and install it again.

If you still see only a Help button, it is the add-on, not your setup.

What to use instead

1. Sidestat (free, works inside Google Sheets)

Sidestat has the same 19 Analysis ToolPak tools plus logistic regression, with the same names and the same output layout. If your course handout or textbook shows XLMiner or Excel screens, you can follow it step by step. Every result is checked against an independent statistics library before release.

Install Sidestat

2. Excel's Analysis ToolPak (if you have Excel on a computer)

The original. In desktop Excel, turn it on in File > Options > Add-ins. It is not available in Excel for the web.

3. Sheets functions (for one number at a time)

Google Sheets has functions such as T.TEST, CORREL, LINEST and STDEV.S. They give single values, not the full output tables your assignment may ask for.

Run the same analysis with Sidestat

  1. Install Sidestat from the link above. It is free and needs no sign-up.
  2. In your sheet, open Extensions > Sidestat > Start.
  3. Pick the tool, for example t-Test: Two-Sample Assuming Equal Variances.
  4. Select your data ranges, set Alpha, and press OK. The output lands in a new sheet.

Same tool names you know

ToolIn Sidestat
Anova: Single FactorYes, same name
Anova: Two-Factor With / Without ReplicationYes, same names
Correlation, CovarianceYes
Descriptive StatisticsYes, with a confidence level for the mean
Exponential Smoothing, Moving AverageYes
F-Test Two-Sample for VariancesYes
Fourier AnalysisYes
HistogramYes, with Pareto order and cumulative percentages
Random Number Generation, Rank and Percentile, SamplingYes
RegressionYes, one or more X variables
t-Test: Paired, Equal Variances, Unequal VariancesYes, all three
z-Test: Two Sample for MeansYes
Logistic RegressionYes, extra, with odds ratios

Questions

Is Sidestat free?

Yes. All 20 tools are free. Sidestat Pro adds a plain-English explanation of each result and an APA sentence ready to paste into a report, for $24 a year. You never need Pro to get the numbers.

Does it work with a school Google account?

Usually. Some schools block add-ons for student accounts. If the install button is greyed out, ask your school's IT team, or use a personal Google account with a copy of the sheet.

Does it read or keep my data?

Sidestat only works on the spreadsheet you have open and does not send your data anywhere. The details are in the privacy policy.

Will I get the same numbers as Excel?

The tools follow Excel's Analysis ToolPak formulas and layout. If you ever see a difference, write to support@maioapps.com and we will check it.