Tutorials

Learn BESHStatNG through practical, workbook-based tutorials for real Excel workflows.

This section is designed for researchers, analysts, teachers, students, and biomedical users who want to run statistical analyses directly in Excel and understand both the workflow and the interpretation of the results.

The tutorials focus on methods that are already implemented in the latest BESHStatNG version and documented in the online help. Each tutorial is built around a realistic use case, a clear sequence of steps, and a downloadable example workbook that you can reuse in your own work.

If you find a bug while working through a tutorial or workbook example, please report it on the GitHub issue tracker. Include the tutorial page, the workbook or formula you used, your BESHStatNG version, and the exact step where the problem occurred. This helps keep examples, documentation, and the add-in itself aligned.

What you will find here

Each tutorial is designed to be practical and easy to follow.

A typical tutorial includes:

  • a short practical introduction
  • a screenshot-first walkthrough
  • a downloadable workbook example
  • a guide to interpreting the output
  • notes on how the results compare with R or standard statistical references

The goal is not only to show where to click, but also to help you understand which method to use, how to set it up correctly, and how to explain the results.

For a broader overview of how BESHStatNG methods are checked against reference outputs, tutorial workbooks, and test cases, see our validation page.

Recommended starting point

If you are new to BESHStatNG, start with:

  1. Survival analysis in Excel
  2. Method comparison and agreement in Excel
  3. Regression and UDF workflows in Excel
  4. UDF Cookbook

These three tracks show the strongest and most distinctive parts of the current BESHStatNG feature set.

Method comparison and agreement in Excel

Use BESHStatNG to compare measurement methods, evaluate agreement, and assess reliability directly in Excel.

This tutorial track covers workflows such as:

  • Passing–Bablok regression
  • Deming regression
  • Weighted Deming regression
  • Bland–Altman plots
  • Lin’s concordance correlation coefficient
  • Cohen’s kappa and weighted kappa
  • intraclass correlation coefficients

These methods are especially useful for laboratory data, assay comparison, device comparison, inter-rater agreement, and validation studies. Go to Tutorial.

Survival analysis in Excel

Run practical time-to-event analyses in Excel with BESHStatNG.

This tutorial track includes:

  • Kaplan–Meier plots
  • log-rank tests
  • Cox regression

These tutorials are designed for biomedical, clinical, and applied research workflows where survival curves, group comparisons, and hazard models are needed in an Excel-first environment. Go to Tutorial.

Regression and UDF workflows in Excel

Build regression workflows directly in Excel, either through the ribbon dialogs or with worksheet formulas.

This tutorial track includes:

  • multiple linear regression
  • generalized linear models
  • negative binomial regression
  • zero-inflated Poisson regression
  • generalized estimating equations
  • formula-based model fitting with worksheet UDFs

These tutorials are ideal for users who want reproducible workbook-based analysis and reusable model templates. Go to Tutorial.

Looking for copy-paste worksheet formulas rather than a full step-by-step tutorial? The BESHStatNG UDF Cookbook gives you practical Excel-ready examples for chart data, handle-based model workflows, and reusable workbook templates, with links to the full online help and a downloadable companion workbook. It is a good starting point when you want to move from ribbon-driven analysis to formula-based statistical workflows in Excel. Open the UDF Cookbook

Multivariate analysis in Excel

Explore structure in multivariable datasets with Excel-based multivariate tools.

This tutorial track includes:

  • principal component analysis
  • factor analysis
  • correspondence analysis
  • multiple correspondence analysis
  • k-means clustering
  • hierarchical clustering
  • discriminant analysis

These tutorials are useful for exploratory analysis, teaching, dimension reduction, and pattern discovery in structured datasets. Go to Tutorial.

Sample size planning in Excel

Plan studies and compare design assumptions before collecting data.

This tutorial track includes:

  • sample size for paired t-tests
  • unpaired t-tests (including superiority, non-inferiority, equivalence)
  • single proportion
  • independent proportions (including superiority, non-inferiority, equivalence)
  • log-rank tests
  • Cox regression
  • intraclass correlation (ICC)
  • Bland–Altman agreement studies

These tutorials are useful for study planning, protocol preparation, teaching, and quick scenario analysis inside Excel. Go to Tutorial.

ROC analysis in Excel

Learn how to perform ROC analysis in Excel with BESH Stat NG using both the GUI workflow and the UDF workflow. This tutorial uses a real diagnostic dataset and explains ROC curves, AUC, confidence intervals, threshold selection, and practical interpretation of sensitivity and specificity.

This tutorial track includes:

  • real-world diagnostic example
  • step-by-step GUI workflow
  • reproducible Excel UDF workflow
  • ROC curve and AUC interpretation
  • cut-off table with sensitivity and specificity
  • downloadable workbook template

Open the ROC analysis tutorial

Multinomial and ordinal outcome workflows in Excel

Learn how to fit multinomial and ordinal logistic regression models in Excel with BESH Stat NG using both the GUI workflow and the UDF workflow. This tutorial uses real clinical-style example data and shows how to model multiclass nominal outcomes and ordered severity outcomes, interpret coefficients and cutpoints, and build reproducible workbook-based regression workflows.

Go to Tutorial.

Repeated-measures analysis in Excel

Learn how to analyse repeated-measures data in Excel with BESH Stat NG using a real longitudinal clinical-trial example. This tutorial compares repeated-measures ANOVA, Friedman, Skillings–Mack, MMRM, and a companion GEE workflow, with a strong focus on when MMRM is the preferred method for continuous repeated outcomes with missing visits.

This tutorial track includes:

  • repeated-measures ANOVA and Friedman
  • incomplete-block reasoning and Skillings–Mack
  • MMRM as the flagship longitudinal method
  • between-within and Kenward–Roger inference
  • a companion GEE example for repeated binary outcomes

Go to Tutorial.

Formula-driven workbook templates with UDFs in Excel

Learn how to build formula-driven workbook templates in Excel with BESH Stat NG using reusable worksheet UDF workflows instead of one-off output sheets. This tutorial shows how to structure transparent, update-friendly templates for ROC analysis, multinomial logistic regression, and ordinal logistic regression, with visible control blocks, live spill outputs, and reusable workbook logic.

This tutorial track includes:

  • reusable workbook design patterns
  • ROC template workflow
  • multinomial regression template workflow
  • ordinal regression template workflow
  • guidance for adapting templates to new studies
  • notes on dynamic-array Excel and older non-spill versions

Go to Tutorial.

Worked examples for biomedical and teaching use cases in Excel

Explore worked biomedical examples in Excel with BESH Stat NG using reusable worksheet-based workflows for binary GLM, multinomial logistic regression, and ordinal logistic regression. This tutorial shows how real clinical-style datasets can be used both for practical analysis and for teaching model interpretation, workbook structure, and transparent UDF-based workflows.

This tutorial track includes:

  • binary GLM clinical risk modeling
  • multiclass diagnosis with multinomial regression
  • ordered severity grading with ordinal regression
  • workbook-based teaching flow and reuse
  • compatibility notes for older non-spill Excel versions

Go to Tutorial.

Binary classifier reporting in Excel

Learn how to report a binary classifier in Excel with BESH Stat NG using a practical workflow built around holdout validation, threshold analysis, ROC, calibration, and Brier score. This tutorial shows how to move beyond coefficient tables and evaluate classifier performance in a way that is more useful for students, junior researchers, and applied biomedical users.

This tutorial track includes:

  • binomial GLM classifier fitting
  • holdout-set evaluation
  • confusion-matrix reporting
  • threshold comparison
  • ROC and AUC interpretation
  • calibration and Brier score

Go to Tutorial.

Calibration and threshold selection in Excel

Learn how to evaluate calibration and threshold choice in Excel with BESH Stat NG using a practical workflow built around holdout validation, threshold comparison, ROC, calibration tables, and Brier score. This tutorial is designed for students and junior researchers and shows how to move from a fitted binary model to a more thoughtful interpretation of discrimination, probability quality, and operating-point selection.

This tutorial track includes:

  • binomial GLM holdout reporting
  • confusion-matrix interpretation
  • threshold comparison across operating points
  • ROC and AUC interpretation
  • calibration assessment
  • Brier score and probability-quality reporting

Go to Tutorial.

Explore the documentation

For full method details, options, assumptions, and formulas, see the online BESHStatNG help.