Attend my next free monthly webinar and learn how to make probabilistic estimates using Statistical PERT®
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?
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 will model 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.
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)
The Art of Data-driven Forecasting
(2021 University of Maryland Project Management Symposium whitepaper)
make better decisions
Watch a 16-minute
It’s just 3 steps when
using a SPERT template!
A 2016 PMI
A 2017 UMD
A 2019 UMD
A 2020 UMD
A 2021 UMD