Sidestat for Google Sheets

The Analysis ToolPak tools, inside Google Sheets, laid out the way Excel lays them out.

Install from the Google Workspace Marketplace

Pick a tool in the sidebar, select your data, press OK. The results land in a new sheet with the same names and the same layout as Excel's Analysis ToolPak, so a course handout or a textbook written for Excel still reads the same.

Tools

Descriptive Statistics, with a confidence level for the mean
t-Test: Paired Two Sample for Means
t-Test: Two-Sample Assuming Equal Variances
t-Test: Two-Sample Assuming Unequal Variances
z-Test: Two Sample for Means
F-Test Two-Sample for Variances
Anova: Single Factor
Anova: Two-Factor With Replication
Anova: Two-Factor Without Replication
Correlation
Covariance
Regression, with one or more X variables
Logistic Regression, with odds ratios
Histogram, with Pareto order and cumulative percentages
Moving Average
Exponential Smoothing
Rank and Percentile
Sampling
Random Number Generation
Fourier Analysis

Every result is checked against an independent statistics library before release.

Plans

Free

Every analysis tool
Output to a new sheet or a range you choose
No account and no sign-up

Sidestat Pro

$0 during early access

A plain-English explanation under every result
An APA-formatted sentence, ready to paste into a report
Effect sizes: Cohen's d, eta squared
Free for everyone during early access, then $24 per year

What Pro adds, on a real result

What this means
Highest average: Art (81.33). Lowest average: Science (73.50).
The group averages do not differ significantly (p = 0.416, not below alpha 0.05), so the data do not show a real difference between the groups.
Eta squared = .11: the groups explain 11.0% of the variation, a medium effect.

APA, ready to paste
A one-way ANOVA found no significant difference between the groups, F(2, 15) = 0.93, p = .416, η² = .11.

Your data

Sidestat runs inside Google Sheets. It reads only the spreadsheet you have open, and only when you press OK. Nothing is sent to a server of ours, because Sidestat does not have one. After early access, Pro will be paid through Lemon Squeezy, which handles the checkout and the receipt.

Support

support@maioapps.com, answered by the person who wrote it.