Visit Pluralsight to watch my course that explains how to use Statistical PERT!

brand-new Pluralsight course released March 2019

Quickly Align Expectations,
Make Better Decisions.

Why use Statistical PERT®?

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

  1. How can I quickly align the expectations of other people about uncertain, future outcomes?
  2. 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 kinds 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® (2010 / 2013 / 2016 / 2019 / Office 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 around 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 (2010 / 2013 / 2016 / 2019 / Office 365). There are two editions of Statistical PERT:  Normal Edition and Beta 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).  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.

Both editions of Statistical PERT are extremely easy to use.  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 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. (Click here to see samples of this comparison).   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)

SPERT_HD_Page_Logo