Google Sheets™ add-on
Survey statistics in Google Sheets™ that keep up with your responses
Run t-tests, ANOVA, correlations, reliability and regression with one formula. The report updates as responses come in.
From Google Forms™ responses to results you can defend
Your responses land in a sheet. Four steps turn them into numbers you can put in a thesis, an article or a report — each step is one formula.
1. Prepare the answers
Recode scales and text answers into numbers, reverse items, compute scores.
STATS_RECODERecode values by rule bins (ranges) or exact matches, or reverse a scale. New values can be numbers or text.
STATS_COMPUTECreates new columns from a text query.
2. Check your scale
Cronbach’s alpha shows whether the questions of one scale measure the same thing.
STATS_ALPHAComputes Cronbach’s Alpha — a measure of internal consistency (reliability) for a set of items, such as Likert-type questions.
3. Describe
Means, standard deviations, medians and frequencies of every question at once.
STATS_DESCRIPTIVEColumn-wise descriptive statistics with flexible metric selection and optional column filtering.
STATS_FREQUENCIESCalculates frequencies for chosen columns.
4. Compare and relate
Differences between groups, links between variables, and what predicts a yes-or-no outcome.
STATS_ANOVAOne-way ANOVA: each selected column is a group. Classic (Student) or Welch ANOVA, chosen by welch (auto by default), with homogeneity of variances and post-hoc comparisons.
STATS_INDEPENDENTIndependent-samples t-test for two groups: the two selected columns are the groups.
STATS_PEARSONPearson correlation (r).
STATS_LOGISTICBinary logistic regression with optional ridge regularization (lambda >= 0).
Where survey analysis usually breaks
New responses mean starting over
Select whole columns (
A:F) and pick questions by header name ("q1,q2,q3") or by pattern ("/^q/"). Each new response from Google Forms™ lands in the range, and the report recalculates by itself.Tutorials send you to another program
Your responses are already in Google Sheets™, and the analysis runs there too — no export, no second program, no copying results back.
Numbers everywhere — but what do I write?
Every report function has a page on this site that explains each number in plain language and gives the line for your report. In the add-on: Extensions › ALS Stats › Functions list, then Link to documentation.
Your supervisor needs to see the work
It is a Google Sheets™ file: share it with your supervisor or co-authors and open it wherever you sign in to Google. The formulas stay in the cells, so anyone can see how each result was produced.
Why you can trust the numbers
- 4,000+ automated testsBehind every formula.
- Your data stays in your spreadsheetThe add-on can access only the file you use it in.
- FreeNo sign-up, no subscription.
Questions before you install
Is it free?
Yes. All 31 functions are free to use.
Does my data leave my spreadsheet?
No. The formulas run inside Google Sheets™, and the add-on can access only the spreadsheet you use it in.
Why does it ask for these permissions?
To show its menu and sidebars in Sheets, to read and write the current spreadsheet, and to know which Google account is using it. It cannot open your other files.
Does it work with a school or work account?
Yes, if your administrator allows it. Some Google Workspace domains accept only approved add-ons; then ask your administrator to allow ALS Stats.
How accurate are the results?
More than 4,000 automated tests check the statistics. The page of each report function shows how its numbers are computed.
Start in three steps
- Install ALS Stats from the Google Workspace Marketplace.
- Open your responses sheet. If the formulas do not calculate, choose Extensions › ALS Stats › Activate in this file.
- Type a formula, for example
=STATS_DESCRIPTIVE(A1:D100, "mean,std,median"), and the report appears below it.
Install ALS Stats from Google Workspace Marketplace (opens in a new tab)