StatFill: Statistics & Data Analysis Tools

StatFill is an add-on for Google Sheets™ that writes statistics tables from your data, laid out like the tables of the Analysis ToolPak in Microsoft Excel: the same row labels, order and statistics, so course instructions and answer keys read the same.

Descriptive Statistics, Histogram and Correlation.
t-Tests: paired, two-sample with equal variances, and with unequal variances.
Anova: Single Factor.
Regression, with residuals, standard residuals and the probability table.
Checked numbers: StatFill computes its own t and F distributions, and every table is checked against R and high-precision reference values before each version.
Your data stays as it is: each table goes to a new sheet or an Output Range you choose, never over the data it analyzes, and never over filled cells without asking. StatFill only reaches the spreadsheet you use it in.

Where Excel’s tool leaves a choice undocumented, StatFill’s is this: with no Bin Range, a histogram uses ⌈√n⌉ equal-width bins from the minimum to the maximum; give a Bin Range for Excel’s exact bins.

Plans

Free: 3 analyses in total per Google account. Creating the sample data uses none.
StatFill: $9 once per Google account for unlimited analyses. No subscription. Refunds within 14 days. See the terms.

Install it from the Google Workspace™ Marketplace, then open it from Extensions > StatFill in any spreadsheet.

Add-on will not open or uses the wrong Google account?

Microsoft, Excel and Analysis ToolPak are trademarks of Microsoft Corporation. StatFill is not affiliated with, sponsored or endorsed by Microsoft.