Single Task Tools

Statistics Tools: t-Test, ANOVA & Regression

This add-on brings the classic data analysis tools to Google Sheets™: descriptive statistics, correlation, covariance, rank and percentile, regression, t-tests, F-test, ANOVA and histograms. Select your data with its headers, pick a tool, and the result appears in a new sheet as a finished table with the same rows and labels as the classic add-in (Analysis ToolPak), in six languages. Free, one permission.

Install it from the Google Workspace Marketplace™, or from Extensions › Add-ons › Get add-ons inside Google Sheets™.

How to use it

  1. Select your data with the headers in the first row.
  2. Open the Extensions menu, find Statistics Tools and pick the tool. The table appears in a new sheet named after the tool; results are fixed values, so change the data and run the tool again when needed.
  3. No data yet? Create example sheet, in the same menu, adds sample columns ready to analyse (Score; Group A, B, C; x, y).

The tools and what to select

Details that matter

Languages

The menus, the tables and the messages follow the language of your Google account: English, Spanish, Portuguese, French, German and Italian, with the labels of the classic add-in in each language. Any other language shows English.

Questions

Does anything leave my spreadsheet?
No. The add-on is a script that runs inside your Google account and only asks for permission to edit the spreadsheet it is open in. No servers of ours, no tracking, no account. See the privacy policy.
Will the numbers match the classic add-in?
Yes for the same data: the formulas are the standard ones and the layout is the same. Statistical software that uses fractional degrees of freedom (R, Python) can differ in the third decimal of the P-value of the unequal-variances t-test.
Can I undo?
Each run creates a new sheet; delete it, or use Ctrl+Z (Cmd+Z on Mac).
Does it work in the mobile app?
No. Google Sheets™ add-ons run in the web version only.

Anything else: support@singletasktools.com.

Analysis ToolPak is a feature of Microsoft Excel. Single Task Tools is not affiliated with Microsoft.