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.
개발자:
정보 업데이트:2026년 10월 26일
호환 기기:
8천+
개요
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.
추가정보
가격무료
개발자
비사업자
지원
개인정보처리방침
서비스 약관
ALS Stats에서 아래에 표시된 권한을 요청합니다. 자세히 알아보기
ALS Stats에서 Google 계정에 액세스해야 함
이렇게 하면 ALS Stats에서 다음 작업을 할 수 있습니다.
애플리케이션 설치 시 사용한 스프레드시트 조회 및 관리
Google 애플리케이션 내 메시지 및 사이드바에 외부 웹 콘텐츠를 표시하고 실행합니다.
기본 Google 계정의 이메일 주소 확인
개인정보(공개로 설정한 개인정보 포함) 보기
리뷰
언어:
정렬 기준:
Google에서는 리뷰나 평점을 확인하지 않습니다. 리뷰에 대해 자세히 알아보기
댓글 없음
검색
검색어 지우기
검색 닫기
Google 앱
기본 메뉴