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 replacementXLMiner 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.
These rarely bring it back, but they rule out the simple causes:
If you still see only a Help button, it is the add-on, not your setup.
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.
The original. In desktop Excel, turn it on in File > Options > Add-ins. It is not available in Excel for the web.
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.
| Tool | In Sidestat |
|---|---|
| Anova: Single Factor | Yes, same name |
| Anova: Two-Factor With / Without Replication | Yes, same names |
| Correlation, Covariance | Yes |
| Descriptive Statistics | Yes, with a confidence level for the mean |
| Exponential Smoothing, Moving Average | Yes |
| F-Test Two-Sample for Variances | Yes |
| Fourier Analysis | Yes |
| Histogram | Yes, with Pareto order and cumulative percentages |
| Random Number Generation, Rank and Percentile, Sampling | Yes |
| Regression | Yes, one or more X variables |
| t-Test: Paired, Equal Variances, Unequal Variances | Yes, all three |
| z-Test: Two Sample for Means | Yes |
| Logistic Regression | Yes, extra, with odds ratios |
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.
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.
Sidestat only works on the spreadsheet you have open and does not send your data anywhere. The details are in the privacy policy.
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.