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.
Oleh:
Listingan diperbarui:26 Oktober 2026
Berfungsi dengan:
8 rb+
Ringkasan
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.
Informasi tambahan
HargaTanpa biaya
Developer
Non-pedagang
Dukungan
Kebijakan privasi
Persyaratan layanan
ALS Stats akan meminta agar izin ditampilkan di bawah ini. Pelajari lebih lanjut
ALS Stats akan memerlukan akses ke Akun Google Anda
Hal ini akan mengizinkan ALS Stats untuk:
Melihat dan mengelola spreadsheet tempat aplikasi ini dipasang
Menampilkan dan menjalankan konten web pihak ketiga pada perintah dan sidebar di dalam aplikasi Google
Melihat alamat email Akun Google primer Anda
Melihat info pribadi Anda, termasuk info pribadi Anda yang tersedia untuk publik
Ulasan
Bahasa:
Urutkan menurut:
Google tidak memverifikasi ulasan atau rating. Pelajari ulasan lebih lanjut
Tidak ada komentar
Telusuri
Hapus penelusuran
Tutup penelusuran
Aplikasi Google
Menu utama