### Free Webinar!

Attend my next free monthly webinar and learn how to make probabilistic estimates using Statistical PERT®

### Mission, Vision, Values

Find out why I created this website

## Quickly Align Expectations,

Make Better Decisions.

Why use **Statistical PERT®**?

Statistical PERT (SPERT®) is an estimation technique that tackles these two problems:

- How can I quickly align the expectations of other people about uncertain, future outcomes?
- How can decision-makers make better decisions
*today*to secure better outcomes*tomorrow*?

*Watch a 16-minute video, Why Use Statistical PERT? on the Statistical PERT YouTube channel.*

In traditional projects, there are many uncertainties, such as the duration and cost of the project. Decision-makers must approve project schedules and budgets, but there is uncertainty surrounding these project constraints.

In agile organizations, product owners and agile teams forecast when future features and capabilities may become available to the sponsoring organization and its customers.

These are the kind of uncertainties that Statistical PERT models using the built-in functions of Microsoft Excel.

With Statistical PERT, project managers, product owners and other business professionals can align stakeholder expectations with respect to proposed schedules and budgets (traditional approach) and product release dates (agile approach). Decision-makers can know how much risk is involved with project and product estimates, so estimates align with the decision-makers’ tolerance for risk.

Beyond projects and new product development, Statistical PERT offers estimators a way to model many other, bell-shaped uncertainties, too, such as event attendance, or when the Washington DC cherry blossoms will be at their peak.

Statistical PERT is a simple, effective technique to communicate confidence and risk about uncertain matters. Using built-in statistical functions in Microsoft Excel, Statistical PERT gives any estimator an easy and powerful way to model project and product uncertainties. From those estimates, decision-makers can make better, more informed decisions *today* to secure better outcomes *tomorrow*.

All Statistical PERT example workbooks and templates are FREE.

## What is Statistical PERT?

**Statistical PERT®** is a freely licensed, probabilistic estimation technique for use with Microsoft Excel® (2016 / 2019 / 2021 / Microsoft 365).

Nearly every professional project manager is familiar with the Program Evaluation and Review Technique (PERT) to create a risk-adjusted estimate using a minimum, maximum and most likely outcome for any bell-shaped uncertainty. The PERT formula to estimate the *mean* (that is, the *average* or *expected result*) is:

(Minimum + 4(Most Likely) + Maximum) / 6

Credentialed project managers from the Project Management Institute memorize this formula in preparation for the Project Management Professional (PMP®) examination.

**Statistical** Program Evaluation and Review Technique (**Statistical PERT®** or, **SPERT®**) starts with this PERT formula to estimate the *mean* for a normal, bell-shaped probability distribution. Then, Statistical PERT uses the estimator’s subjective judgment about *how likely* the most likely outcome really is to adjust the standard deviation for the normal (or beta) curve. By doing this, Statistical PERT will create greater certainty around the mean when an estimator indicates high confidence in the most likely outcome. Conversely, Statistical PERT will create greater uncertainty away from the mean when an estimator indicates low confidence in the most likely outcome (this situation occurs when, for example, an estimator has little knowledge about a particular uncertainty, so the most likely outcome is more of a best-guess about that uncertainty).

Statistical PERT uses the built-in statistical functions of Microsoft Excel. There are no Excel add-in programs to install, no macros to worry about, nothing to buy, and nothing to register. The free, downloadable Statistical PERT templates and example workbooks can be modified and redistributed according to the GNU General Public License by the Free Software Foundation.

Statistical PERT uses Excel functions that come with Microsoft Excel (2016 / 2019 / 2021 / Microsoft 365). There are now four editions of Statistical PERT: Normal Edition, Beta Edition, Lognormal Edition, and the Bootstrap Edition. The *Normal Edition* uses the STDEV.P, NORM.DIST and NORM.INV functions. The *Beta Edition* uses BETA.DIST and BETA.INV (along with the NORM.DIST and NORM.INV functions). The *Lognormal Edition *uses the LOGNORM.DIST and LOGNORM.INV functions. The *Bootstrap Edition* uses PERCENTRANK, PERCENTILE, along with several other advanced Excel functions. Older versions of Excel are compatible with Statistical PERT concepts, but not the free, downloadable Excel templates.

Statistical PERT® Normal Edition uses ratio scale modifiers to modify the standard deviation of a normal curve. This lets Statistical PERT work with any bell-shaped uncertainty that can be estimated using a 3-point estimate for minimum, maximum and most likely outcomes.

Statistical PERT® Beta Edition uses ratio scaling to determine the mean and standard deviation, but it also performs analysis on the implied shape of the bell-shaped curve to select the two shape parameters for use with the beta distribution functions of Excel.

Statistical PERT® Lognormal Edition uses either the most likely (mode) point-estimate or the mean (average) to create a 3-point estimate and build a bell-shaped curve using the lognormal distribution. The lognormal distribution easily models many uncertainties common in business and project management.

Statistical PERT® Bootstrap Edition uses statistical bootstrapping, which is a simulation technique, to create a probabilistic, delivery date forecast for agile teams using Scrum or Kanban.

All four editions of Statistical PERT are extremely easy to use. For instance, for the *Normal Edition*, simply create a 3-point estimate for any bell-shaped uncertainty, then render a subjective judgment about* how likely* the most likely outcome really is. The *Normal Edition* template comes pre-calibrated so stating Medium Confidence in the most likely outcome will result in probabilities that are similar to a Monte Carlo simulation using the RiskPERT function in Palisade’s @Risk Excel add-in program. Choosing other opinions will increase or decrease the calculated standard deviation for an uncertainty, and the probabilities will re-calculate accordingly.

Want to learn more? Download free brochures and whitepapers:

Why Use Statistical PERT? (PDF brochure)

What Is Statistical PERT? (whitepaper)

Easily Estimate Projects Using Statistical PERT

(2016 PMI Global Congress whitepaper)

Easily Estimate Projects Using Statistical PERT

(2016 PMI Global Congress presentation)

Stop Predicting, Start Forecasting

(2017 University of Maryland Project Management Symposium whitepaper)

Capturing Costs and Value of Research Products

**A United States Census Bureau Whitepaper**

(2019 University of Maryland Project Management Symposium)

How to Forecast Answers to Your Toughest Agile Questions

(2020 University of Maryland Project Management Symposium whitepaper)

**New!** The Art of Data-driven Forecasting

(2021 University of Maryland Project Management Symposium whitepaper)

### Why Use Statistical PERT?

Align expectations,

make better decisions

### Why Use Statistical PERT?

Watch a 16-minute

YouTube video

### What Is Statistical PERT?

Learn the

SPERT basics

### The Five Steps of Statistical PERT

It’s just 3 steps when

using a SPERT template!

A 2016 PMI

Global Congress

whitepaper

### 2016 PMI Global Congress

Download the

2016 PMI

Global Congress

presentation

### Stop Predicting, Start Forecasting

A 2017 UMD

Project Management

Symposium

Whitepaper

### Learn How the U.S. Census Bureau Uses Statistical PERT

A 2019 UMD

Project Management

Symposium

Whitepaper

### Learn How to Create an Agile Forecast

A 2020 UMD

Project Management

Symposium

Whitepaper

### The Art of Data-Driven Forecasting

A 2021 UMD

Project Management

Symposium

Whitepaper