Statistics in Google Sheets: step-by-step guides
How to run and report the most common statistical tests in Google Sheets, with formulas you can copy and a faster way with ExplainStats.
How to do a t-test in Google Sheets
Run a t-test in Google Sheets with T.TEST: which type to choose, how to get t, df, Cohen's d and the confidence interval, and how to report it. Worked examples.
Read the guide →ANOVAHow to run a one-way ANOVA in Google Sheets
Google Sheets has no ANOVA function. Build the full one-way ANOVA table with DEVSQ and F.DIST.RT, get eta squared, check assumptions and report it.
Read the guide →RegressionHow to do linear regression in Google Sheets
Run a linear regression in Google Sheets with SLOPE, INTERCEPT, RSQ and LINEST. Get the p-value, confidence interval and prediction, then report it.
Read the guide →CorrelationHow to calculate a correlation and its p-value in Google Sheets
Calculate Pearson's r in Google Sheets with CORREL, get its p-value and confidence interval, run a Spearman correlation with ranks, and report the result.
Read the guide →Chi-squareHow to do a chi-square test in Google Sheets
Run a chi-square test of independence in Google Sheets: build the expected table, use CHISQ.TEST, get the χ² value, Cramér's V and the APA write-up.
Read the guide →DescriptiveDescriptive statistics in Google Sheets
Every descriptive statistic in Google Sheets in one table: mean, median, mode, standard deviation, standard error, quartiles, skewness, kurtosis and confidence interval.
Read the guide →NormalityHow to test for normality in Google Sheets (Shapiro-Wilk)
Google Sheets has no normality test. Here is the full Shapiro-Wilk test with formulas (Royston's method, same result as SciPy and R), plus a Q-Q plot.
Read the guide →Non-parametricHow to do a Mann-Whitney U test in Google Sheets
Run a Mann-Whitney U test (Wilcoxon rank-sum) in Google Sheets with RANK.AVG and SUMIF: U, z, p-value, effect size and APA reporting, with a worked example.
Read the guide →Choosing a testWhich statistical test should I use?
Pick the right statistical test in four questions: t-test, ANOVA, Mann-Whitney, chi-square, correlation or regression. One table, clear rules, examples.
Read the guide →Analysis ToolPakAnalysis ToolPak in Google Sheets: what to use instead
Google Sheets has no Analysis ToolPak. Here is the Sheets formula for every ToolPak tool, and the add-on options to get the same output tables.
Read the guide →