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.
Nhà phát triển:
Đã cập nhật trang thông tin:26 tháng 10, 2026
Hoạt động với:
8 N+
Tổng quan
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.
Thông tin bổ sung
GiáKhông tính phí
Nhà phát triển
Không phải bên giao dịch
Hỗ trợ
Chính sách quyền riêng tư
Điều khoản dịch vụ
ALS Stats sẽ yêu cầu các quyền như trình bày bên dưới. Tìm hiểu thêm
ALS Stats sẽ cần có quyền truy cập vào Tài khoản Google của bạn
Điều này sẽ cho phép ALS Stats:
Xem và quản lý bảng tính mà ứng dụng này đã được cài đặt bên trong
Hiển thị và chạy nội dung web bên thứ ba trong lời nhắc và thanh bên ở trong các ứng dụng của Google
Xem địa chỉ email chính cho Tài khoản Google của bạn
Xem thông tin cá nhân của bạn, bao gồm mọi thông tin cá nhân mà bạn đã đăng công khai
Bài đánh giá
Ngôn ngữ:
Sắp xếp theo:
Google không xác minh bài đánh giá hoặc điểm xếp hạng. Tìm hiểu thêm về bài đánh giá
Không có nhận xét nào
Tìm kiếm
Xóa nội dung tìm kiếm
Đóng tìm kiếm
Các ứng dụng của Google
Trình đơn chính