Easily Estimate Projects Using Statistics and Excel

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

Watch for a brand-new Pluralsight course this January, 2019

Quickly Align Expectations,
Make Better Decisions.

Why use Statistical PERT®?

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

  1. How can I quickly align the expectations of other people?
  2. How can decision-makers make better decisions about future uncertainties?

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

In projects, there are many uncertainties, such as the duration of the project, the cost of the project, and what the project will deliver.  Decision-makers must approve project schedules, budgets and scope, but these can all involve uncertain, future outcomes.  Usually, some outcomes are more likely than others.

In agile organizations, agile teams forecast when future capabilities may become available to the 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 professionals can align the expectations of sponsors, team members, and other stakeholders with respect to proposed project schedules and budgets (and for agile projects, project releases).  Decision-makers can know how much risk is involved with project estimates, so approved estimates align with the decision-makers’ tolerance for risk.

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 uncertainties having many possible outcomes.  Then, decision-makers can choose project estimates that have the right risk-reward combination.

All Statistical PERT example workbooks and templates are FREE.

What is Statistical PERT?

Statistical PERT® is a freely licensed, stochastic (that is, 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 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 the 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 multipliers 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)