A/B Test Calculator
Enter sample sizes and conversion rates for control and variant. Get statistical significance, confidence interval, and required sample size for detecting effect. Proper two-proportion z-test.
Preview & Download →Data Analysis Templates
Templates for the analytical thinking side of Excel. Regression, cohort analysis, A/B testing, Pareto charts, Monte Carlo simulations — real statistical work in workbook form.
📌 Analyst-grade tools: These templates go beyond spreadsheets-as-tables. Real statistical calculations, proper hypothesis testing, clear methodology notes, and interpretation guidance. Include sample datasets so you can learn the technique before applying to your own data.
Featured templates
Cohort Analysis Template
Retention analysis with cohort-by-cohort breakdown. Colored heatmap shows retention curves. Configurable for weekly, monthly, or quarterly cohorts. Includes LTV projection.
Preview & Download →All data analysis templates
Regression Analysis
Linear regression with residuals, R², p-values, confidence intervals. Multi-variate support. Auto-generated scatter plot with fitted line and prediction band.
Preview & Download →Statistical Hypothesis Testing
t-test, chi-squared, ANOVA in one workbook. Enter your data, choose your test, get p-values and interpretation. Includes normality checks.
Preview & Download →Time Series Forecasting
Forecast future values using exponential smoothing, moving averages, and Excel's FORECAST.ETS. Includes seasonality detection and confidence bands.
Preview & Download →Monte Carlo Simulation
Run 1,000+ iterations of your model with random inputs. See probability distribution of outcomes. Ideal for risk analysis, project planning, financial projections.
Preview & Download →ABC Analysis
Classify inventory, customers, or products into A/B/C tiers based on Pareto principle. Auto-calculates cumulative percentages and thresholds. Visualizes as bar chart.
Preview & Download →Pareto Chart Template
80/20 rule visualization. Bar chart of individual values with cumulative percentage line. Auto-sorts and highlights the vital few vs trivial many.
Preview & Download →Break-Even Analysis
Calculate break-even point in units and revenue. Sensitivity analysis on price, variable cost, and fixed cost. Visualizes contribution margin.
Preview & Download →Sensitivity Analysis
Two-variable data table analysis. See how output changes across ranges of two inputs. Tornado chart for single-variable sensitivity. Critical for financial modeling.
Preview & Download →Funnel Analysis Template
Multi-step conversion funnel with drop-off analysis. Identifies weakest step and calculates potential lift from improvement. Visualized funnel chart.
Preview & Download →SWOT Analysis Template
Structured Strengths / Weaknesses / Opportunities / Threats matrix. Formatted for team workshops. Includes scoring and prioritization sheets.
Preview & Download →What's inside every analysis template
- Methodology sheet — clear explanation of what the analysis does and when to use it
- Sample dataset — realistic example so you understand the technique first
- Formula documentation — every calculation explained in plain English
- Interpretation guide — how to read the results and what they mean
- Caveats and assumptions — when the analysis is appropriate and when it isn't
- Auto-generated visualizations — appropriate chart for each analysis type
- Configurable parameters — significance levels, confidence intervals, iterations
Frequently asked questions
Are these templates rigorous enough for real analysis?
Yes — the statistical templates use proper methodology (correct test formulas, appropriate assumptions, honest confidence intervals). They're suitable for business analysis, product experiments, and internal reports. For academic publication, you'd want to also validate in R or Python.
Do I need the Analysis ToolPak add-in?
Some templates use it, most don't. Where it's needed, the template's instructions guide you through enabling it (File → Options → Add-ins → Manage Excel Add-ins → check Analysis ToolPak). Templates that need it are marked in the meta tags.
Can I trust the p-values from Excel?
For standard tests (t-test, chi-squared, F-test, z-test) — yes, Excel's implementations are accurate. Edge cases with very small samples or extreme distributions may differ slightly from R/SciPy. For business decisions, the difference is negligible.
How do I know which analysis to use?
Each template's methodology sheet describes when it's appropriate. Quick guide: comparing two groups → t-test. Multiple groups → ANOVA. Categorical relationships → chi-squared. Continuous outcome vs predictors → regression. Repeated observations → cohort or time series.
Can Monte Carlo really run in Excel?
Yes — Excel 365 recalculates fast enough for 10,000-iteration simulations. Older Excel versions can handle 1,000 comfortably. For higher volumes or complex models, Python-in-Excel or a proper simulation tool is better.
Custom analysis templates in seconds.
Describe your analysis — "chi-squared test for whether region affects churn rate" — and get the template with correct formulas and interpretation notes.
Get the Add-in →