Google Workspace Marketplace
Recode and compute data from Google Forms™ responses on the fly with formulas in Google Sheets™ and export an SPSS syntax with alpha, tests and more.
Por:
Informações atualizadas:26 de outubro de 2026
Compatível com:
8 mil+
Visão geral
Prepare your data once — it stays ready while responses come in. Tests, regressions, correlations and descriptives update with every new response. Results are checked against R (stats, psych, car) and Python (SciPy, statsmodels); 4,700+ automated tests. Export to SPSS: data and syntax with clear compatibility notes.

31 formulas — from data preparation to models:
• Prepare data: recode, compute new columns, z-scores, normalization, moving averages, split a column by groups.
• Describe: descriptive statistics, frequencies with value labels, confidence intervals, normality test.
• Compare groups: one-sample, paired and independent t-tests; one-way and Welch ANOVA with post-hoc comparisons; Mann–Whitney, Wilcoxon and Kruskal–Wallis tests.
• Relationships: Pearson, Spearman, Kendall and partial correlations; crosstabs, chi-square and Cramér's V.
• Scales: Cronbach's alpha, alpha if item deleted.
• Models: multiple hierarchical regression with interactions (moderation), logistic regression, bootstrap confidence intervals.
• In one go: STATS_ANALYZE runs many analyses with one formula.

Export to SPSS whenever you need it
If you know the routine — waiting for the form to close, then a long preparation: exporting to Excel, working with the raw data, importing into SPSS and describing every column by hand — ALS Stats has a nice bonus for you. From the very first responses you can write the formulas that prepare your data; they recalculate with every new response, and the result exports straight to SPSS data and syntax files.

Results take shape before your eyes
Wouldn't it be interesting to see what your survey shows before it ends? Here you see it from the first responses. Every new response recalculates the reports: you watch the means and effect sizes change and see how much sample size matters — at 20 responses, at 50, at 100.

Formulas instead of menus
The more tests in your work, the more often you go through the SPSS menus: Analyze › Compare Means › One-Way ANOVA, find and move the columns, open Options and Post Hoc, then look for the right table in the output window. In ALS Stats a test is a line in a cell: =STATS_ANOVA(A:F,"q1,q2,q3"), and the report appears right below it: the test, assumption checks, effect sizes, post-hoc comparisons. And formulas nest: recode the answers, reverse the negatively worded items and compute the scale score — in one line.

Your supervisor sees your work any time
Yes, your supervisor wants to see how you got your numbers — but you don't have to export files and send version after version. Your supervisor opens the same spreadsheet by link at any time and sees the current reports, and the cells show what was calculated and how.

Every number in the report explained
Sound familiar: a table with F, df, p and η² in front of you, and no idea what to write in your paper and how? On als-stats.net every report is fully explained: what each value means, in plain language, and a ready line for your report — https://als-stats.net/functions/

And that's only part of what you'll find in ALS Stats: alpha if item deleted to find the weak question, recoding all Likert answers at once — and much more.

Start in three steps
1. Install ALS Stats.
2. Open your responses sheet. If the formulas do not calculate, choose Extensions › ALS Stats › Activate in this file.
3. Type =STATS_FREQUENCIES(A:F,"q1,q2") — the answers to each question appear below it, with counts and percentages.

Google Sheets™ and Google Forms™ are trademarks of Google LLC. SPSS is a trademark of IBM Corp.
Informações adicionais
PreçosSem custo financeiro
Desenvolvedor
Não empreendedor
Suporte
Política de Privacidade
Termos de Serviço
O ALS Stats pedirá as permissões abaixo. Saiba mais
O ALS Stats precisará de acesso à sua Conta do Google
Isso permite que o ALS Stats faça o seguinte:
Ver e gerenciar planilhas nas quais este aplicativo foi instalado
Exiba e execute conteúdo da Web de terceiros em prompts e barras laterais dentro dos aplicativos do Google
Ver o endereço de e-mail principal da sua Conta do Google
Ver suas informações pessoais, inclusive aquelas que você disponibilizou publicamente
Comentários
Idioma:
Ordenar por:
O Google não verifica avaliações nem classificações. Saiba mais sobre as avaliações
Nenhum comentário
Pesquisa
Limpar pesquisa
Fechar pesquisa
Google Apps
Menu principal