StatPakGuides
Step-by-step guides with worked examples. Every number on these pages is computed by StatPak.
- How to get the Data Analysis ToolPak in Google SheetsGoogle Sheets has no built-in Analysis ToolPak. Here is how to get Excel-style Data Analysis (regression, ANOVA, t-tests, histograms) in Sheets, and which old add-ons stopped working in 2026.
- How to run a regression in Google SheetsStep-by-step multiple linear regression in Google Sheets: R squared, coefficients, p-values and confidence intervals, using LINEST or the Data Analysis Regression tool.
- How to do a one-way ANOVA in Google SheetsRun a single-factor ANOVA in Google Sheets and read the F statistic, p-value and F crit. Worked example with the Excel-style ANOVA table.
- How to do a t-test in Google SheetsPaired and two-sample t-tests in Google Sheets with T.TEST and the Excel-style t-Test output: t Stat, p-values, critical values and degrees of freedom.
- Descriptive statistics in Google SheetsGet a full descriptive statistics summary in Google Sheets: mean, standard error, median, mode, standard deviation, variance, kurtosis, skewness, range and confidence level.
- How to make a frequency table and histogram in Google SheetsCount values into bins with FREQUENCY or the Histogram tool in Google Sheets, with cumulative percentages and a Pareto (sorted) option.
- How to make a correlation matrix in Google SheetsBuild a correlation matrix for several variables in Google Sheets with CORREL or the Correlation tool, and read the coefficients correctly.
- Goal Seek in Google SheetsHow to use Goal Seek in Google Sheets to find a loan payment, break-even volume or required growth rate, and what to do when the Goal Seek add-on is slow or broken.
- How to use Solver in Google SheetsSolve optimisation problems in Google Sheets: maximise profit or minimise cost subject to constraints, with integer and binary variables. Worked product-mix example.
- XLMiner Analysis ToolPak not working? Here is the fixIf XLMiner Analysis ToolPak, Goal Seek or OpenSolver only shows "Help" in the Extensions menu, the add-on was broken by Google retiring the Rhino runtime in 2026. Here is what to use instead.