Tabellab

Data analysis and statistics courses in Excel

Statistics is the part of data analysis that tells you whether a pattern is real.

Data Analysis & Statistics courses (10)

$9.90Intermediate

Bayesian Statistics in Excel: Priors, Posteriors & Bayesian A/B Tests

Bayes' theorem, step-by-step updating, grid posteriors, Beta-Binomial, prior sensitivity, P(B > A) and expected loss, then exact credible intervals, priors from expert guesses, posterior predictive checks, Bayes tables and Bayes factors, Gamma-Poisson counts, normal means, empirical Bayes shrinkage, daily monitoring, three-variant tests, mixture priors and a launch dashboard: 20 hands-on labs with an online plant shop, every cell checked instantly.

20 lessons · 20 labs

$9.90Intermediate

Business Statistics & Regression in Excel

Standard error, confidence intervals, hypothesis tests, two-group comparisons, correlation and regression, then paired tests, slope and correlation tests, prediction intervals, outliers, LINEST, binomial and Poisson counts, Durbin-Watson, multicollinearity, log models and F-tests: 20 labs on realistic business data.

20 lessons · 20 labs

$9.90Beginner

Tourism Statistics by the Numbers: Arrivals vs Overnight Stays, Length of Stay, Bed & Room Occupancy, Seasonality Indices and Regional Reports

Read and build tourism statistics like a regional analyst in 20 hands-on labs. You will turn arrivals and nights into average length of stay, compute bed and room occupancy, build seasonality indices, compare regions year over year, measure tourism intensity and project next season, then go further with plausibility checks, cross-tables, estimates for missing reports, length-of-stay bands, mix effects, seasonal adjustment, rolling 12-month totals, index series, capacity versus occupancy, spending and levy scenarios and a final dashboard, with every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

ANOVA & Experimental Design in Excel: One-Way, Two-Way & Post-Hoc Tests

Design and analyse experiments in Excel in 20 graded labs: group means, DEVSQ sums of squares, the one-way ANOVA table, effect sizes, Levene, Tukey and Bonferroni, randomised blocks and factorials, then unequal groups, Welch's ANOVA, confidence intervals, planned contrasts, Scheffé, trend analysis, simple effects, Latin squares, ANCOVA, variance components and log transforms, every cell checked instantly.

20 lessons · 20 labs

$9.90Intermediate

Nonparametric Statistics: Rank Tests, Spearman & Bootstrap

Ranks and ties, Mann-Whitney U, Wilcoxon signed-rank, Kruskal-Wallis, Spearman, the sign test and the bootstrap, then tie corrections, effect sizes, Hodges-Lehmann, Dunn's post-hoc test, Friedman, Kendall's tau, permutation tests, median intervals, Mood's test, Kolmogorov-Smirnov and the runs test: 21 hands-on labs with a food-delivery start-up.

21 lessons · 21 labs

$9.90Intermediate

Polling & Survey Sampling: Margin of Error, Weighting & Poll Averages

Margins of error with NORM.S.INV, sample sizes, the finite population correction, stratified allocation, post-stratification weights, Kish's design effect, weighted poll averages and the margin of a lead, then changes between polls, undecided voters, likely-voter models, response rates, Wilson intervals, systematic and PPS samples, quota tracking, mean scores with t, house effects, panel turnover and a poll release dashboard: 20 graded labs on one fictional city referendum.

20 lessons · 20 labs

$9.90Intermediate

Regression Analysis for Business in Excel

From scatter plot to model diagnostics: least squares by hand, R², t- and F-tests, prediction intervals, LINEST with several drivers, dummies and interactions, quadratic terms, VIF, influential points, heteroscedasticity and autocorrelation checks, hold-out validation and a site-selection dashboard, in 21 hands-on labs on one retailer's data. Every cell checked instantly.

21 lessons · 21 labs

$9.90Intermediate

Survey & Customer Feedback Analysis in Excel

Response rates, Likert scales, NPS, cross-tabs, weighting, margins of error, significance tests, data cleaning, multi-select, grids, effort scores, reliability, tracking and Pareto: 20 hands-on labs on one customer survey, every cell checked instantly.

20 lessons · 20 labs

$9.90Intermediate

Prioritisation Surveys: Ranking Questions, Best–Worst Scaling, TURF Reach & Kano Categories

Find out what customers want most: ranking scores, top-3 and head-to-head results, best–worst counts, ratio scores and standard errors, design checks, TURF reach including greedy, weighted and sensitivity runs, Kano categories and quadrants, and a final prioritisation dashboard – 20 hands-on labs, with every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Survey Weighting: Post-Stratification, Raking (IPF) & Design Effects

Compare sample and population margins, build base weights from selection probabilities, adjust for nonresponse, post-stratify, rake (IPF) to two and three margins and check convergence, collapse sparse cells, trim weights in rounds, diagnose the weight spread, compute weighted estimates, cross-tabs, medians and jackknife standard errors, measure Kish's design effect and margins of error, compare schemes against a benchmark and finish with a weighting dashboard: 20 graded labs on one fictional transit survey. Synthetic data for practice.

20 lessons · 20 labs

Statistics is the part of data analysis that tells you whether a pattern is real. These courses teach it inside Excel, so you can follow every calculation: regression for business decisions, ANOVA and experimental design, Bayesian updating, nonparametric tests, and the survey methods of sampling, weighting and polling. Concepts are introduced with small data sets before moving to realistic ones, and you check each result against the formulas you built.

This topic hub gathers 10 Data Analysis & Statistics courses from Data & Analytics: 1 beginner, 9 intermediate. Most courses have about 20 hands-on labs, a final exam and a certificate, and the first lesson of every course is free. Searches this hub is built for: regression analysis excel; anova in excel; bayesian statistics excel; survey sampling weighting.

Frequently asked questions

Which Data Analysis & Statistics course should I start with?

Start with “Business Statistics & Regression in Excel”. It is the most central course in this topic at intermediate level. Then move on to the more specialised courses in the list above.

How much do the Data Analysis & Statistics courses cost?

Every course costs a one-time $9.90, with no subscription, and the first lesson of each course is free so you can try it before buying. Each course ends with a final exam and a certificate.

How are the Data Analysis & Statistics courses taught?

Each course is a series of hands-on labs in a built-in spreadsheet that checks your formulas as you type, with short explanations alongside. You need only a web browser; nothing to install. Examples use fictional data and are for learning, not professional advice.

Open your first lab in under a minute

Pick a course, pay once and start right away. Your progress is saved in your account.

Browse the courses