Sumquill brings the data analysis tools from Excel's Analysis ToolPak to Google Sheets™, with Solver and Goal Seek in the same sidebar: regression, ANOVA, t-tests, descriptive statistics, histograms, correlation and more.

If your statistics course assigns Analysis ToolPak problems and you work in Google Sheets™, Sumquill writes the same tables Excel does (SUMMARY OUTPUT, ANOVA, the t-Test layouts), so your numbers line up with the textbook and the answer key. Students use it for linear and multiple regression, one-way and two-way ANOVA and paired t-tests; analysts use Solver for linear programming and Goal Seek for what-if questions.

DATA ANALYSIS TOOLS (output goes to a new sheet or to a range you pick)
• Descriptive Statistics: mean, standard error, median, mode, standard deviation, variance, kurtosis, skewness, range, min, max, sum, count, Kth largest/smallest, confidence level
• Histogram with automatic or custom bins, Pareto order, cumulative %, chart
• t-Tests: paired, two-sample equal variances, two-sample unequal variances (Welch)
• z-Test for two means, F-Test for two variances
• ANOVA: single factor (one-way), two-factor with replication, two-factor without replication
• Regression: linear and multiple regression, with the ANOVA table, coefficients, standard errors, t stats, p-values, confidence intervals, R², residuals, standardized residuals and normal probability output; optional zero intercept
• Correlation and covariance matrices
• Moving Average and Exponential Smoothing, with standard errors and charts
• Rank and Percentile, Sampling (random or periodic), Random Number Generation (uniform, normal, Bernoulli, binomial, Poisson, patterned, discrete), with an optional seed for repeatable results
• Tests, ANOVA and regression also add a one-line plain-English conclusion ("…is statistically significant (p = 0.0002 < 0.05)")

SOLVER
• Set an objective cell to Max, Min or a target value by changing variable cells, subject to constraints (<=, >=, =, integer, binary), the way Excel Solver works
• Simplex LP for linear programming models, with branch and bound for integer and binary variables
• A nonlinear method (Nelder–Mead with penalties) for small smooth models
• Shows progress, has a Stop button, puts your original values back on request, and can write an Answer Report sheet
• Reads a linear model with about one recalculation per variable cell (batched reads and writes), not thousands of trial values

GOAL SEEK
• Set a formula cell to a value by changing one input cell. Secant steps with a bracketing fallback usually finish in under ten trials, with one-click Undo

ACCURACY
The statistics are checked against NIST Statistical Reference Datasets (Longley regression, the SiRstv and SmLs ANOVA sets, the NumAcc univariate sets) and against SciPy reference values. The Solver is checked on standard textbook LPs and integer programs with known optima.

PRIVACY
Sumquill works only in the spreadsheet you open it in. It sends no spreadsheet data anywhere: its only outside call is the Pro license check with Gumroad.

PRICING
Free: Descriptive Statistics, Histogram, Correlation, Goal Seek, and Solver up to 10 variables.
Sumquill Pro: everything else, $3.99/month, $29/year or $49 once (lifetime). Students can also buy a $15 semester pass.

Sumquill is an independent product and isn't affiliated with Microsoft. Excel is a trademark of Microsoft Corporation.

Google Sheets™ is a trademark of Google LLC.