Help & support

Everything you need to get started, and quick fixes for the most common problems. Still stuck? Write to [email protected].

Get started in one minute

  1. Install ExplainStats from the Google Workspace Marketplace (see how).
  2. In any spreadsheet, open Extensions › ExplainStats › Open ExplainStats. The sidebar opens on the right.
  3. No data at hand? Choose Extensions › ExplainStats › Insert sample data to get example datasets and a step-by-step guide.
  4. In the sidebar, pick a tool (or the which-test Assistant), select your data in the sheet, click Use selection, then Run.
  5. The results appear in a new sheet, with a plain-language interpretation under the table.

The language of the sidebar can be changed with the selector at the top of the sidebar (English, Français, Español, Português).

How to lay out your data

  • Put each variable in its own column, with a short name in the first row, and keep the box Labels in first row ticked.
  • To compare groups, either put each group in its own column (one column per group), or use two columns: one with the group name and one with the values.
  • For a chi-square test, select a table of counts with the row and column names.
  • Empty cells are ignored. Text in a numeric column is reported, not silently used.

Common problems

The sidebar does not open, or keeps asking for authorisation

This usually happens when you are signed in to several Google accounts in the same browser: Google Sheets add-ons don't always work in that case. Open the spreadsheet in a private window signed in to one account only, or sign out of all accounts and sign in first with the one that installed ExplainStats.

The ExplainStats menu is missing

Reload the spreadsheet. If it is still missing, check Extensions › Add-ons › Manage add-ons. On a school or company account, your administrator may need to allow the add-on.

“We are sorry, but you do not have access to this Addon. Please contact your Organization's administrator”

This message comes from Google, before ExplainStats even starts. Your Google account belongs to a school or a company, and its administrator has not allowed ExplainStats yet: Google blocks Marketplace add-ons that are not allowed, and does so by default for students marked as under 18. Neither you nor we can change this from our side; only the administrator can.

What to do: send this message to your IT administrator (or ask your teacher to send it):

Hello, I would like to use the Google Sheets add-on ExplainStats (statistical tests explained in plain language) for my classes. Could you allow it in the Google Admin console? It takes a few minutes: https://explainstats.com/institutions/admin-guide/ What it can access: https://explainstats.com/institutions/data-sheet/ Thank you!

“Select a range first” or no data found

Click in the sheet and select the cells that hold your data (including the header row if Labels in first row is ticked), then click Use selection in the sidebar again.

My numbers are treated as text

Check that the numbers use the decimal separator of your spreadsheet's locale (File › Settings › Locale), and that the cells contain no spaces or units such as “kg” or “%” typed as text.

My results differ from another program

Check that you ran the same test with the same options: Welch or equal-variance t-test, one or two tails, the same significance level. Quartiles and percentiles also have several definitions.

Exam mode: what it does and does not do

Exam mode hides the explanations, the assistant, the steps and the report text in the spreadsheet where you turn it on, and in every copy of that spreadsheet. It does not lock the data: a student who copies the values into a new spreadsheet gets the explanations back. Use it as you would a calculator policy, inside a supervised exam. After 5 wrong PINs, the spreadsheet refuses new attempts for 15 minutes. Turning exam mode on is a Pro (teacher) feature; turning it off only needs the PIN.

Exam mode: I forgot the PIN

The PIN can't be recovered: only a protected fingerprint of it is stored in the spreadsheet. Copy your data (values only) into a new spreadsheet, which will not be in exam mode.

Guides

Step-by-step guides for the most common analyses: t-test, ANOVA, regression, chi-square, correlation, which test to use, and more.

Contact

Found a bug or have an idea? Email [email protected]. Tell us which tool you used and what you expected, and never send personal or confidential data. A small example with made-up numbers is perfect.