OptiseekStatistics, Solver and Goal Seek for Google Sheets, laid out like Excel and checked against reference statistics software

Optiseek brings the three analysis tools people miss most when they move from Excel to Google Sheets: the data analysis toolpak, Solver and Goal Seek. Results are written into your sheet as tables laid out the way Excel lays them out, so textbook steps and class handouts line up.

Statistics (22 analyses). Descriptive statistics, histogram with chart and Pareto table, rank and percentile, correlation and covariance matrices, t-tests (paired, equal and unequal variances, one sample), two-sample z-test, F-test, chi-square test of independence, ANOVA (single factor, two-factor with and without replication), linear regression with residuals and confidence intervals, logistic regression with odds ratios, moving average, exponential smoothing, Fourier analysis, sampling and random numbers with a seed.

What you get

• Excel-style Analysis ToolPak in Sheets: 22 analyses (descriptive statistics, histogram, t, z, F and chi-square tests, ANOVA, linear and logistic regression, correlation, covariance, moving average, exponential smoothing, Fourier, sampling, random numbers)
• Every statistic checked against SciPy, statsmodels and NIST reference values
• Goal Seek that converges in a few recalculations, to full precision, plus Seek every row
• Solver for linear, integer and nonlinear models, with any formula (SUM, lookups) in the model
• Answer and Sensitivity reports (shadow prices, reduced costs, allowable ranges)
• Runs inside your spreadsheet: no data leaves Google