Project Management

Statistical PERT® Beta Edition

By PMI South Florida Chapter

Format: Evaluation Assessment / Evaluation Form

Statistical PERT® (SPERT®) is a freely licensed, probabilistic, estimation technique. Use Statistical PERT to estimate uncertainties that have bell-shaped risk properties, like: task duration, work effort, revenue, expenses, agile story points, project portfolios, event attendance and more. Use in conjunction with the article Getting Beta with Statistical PERT.

Statistical PERT® Beta Edition uses Excel's two beta distribution functions, BETA.DIST and BETA.INV to model uncertainty.  To easily model mild-to-moderately skewed uncertainties, try Statistical PERT® Normal Edition, which uses Excel's two normal distribution functions NORMAL.DIST and NORMAL.INV.

Here's what's new in Version 2:

  • Tri-colored combo charts to show the beta distribution bell-curve
  • Tri-colored pie charts
  • Row-level Sparklines to see implied uncertainty of every row
  • A new Agile Forecast tab to make quick agile release date forecasts

download this deliverable: Download

Related Content

People who downloaded this item also downloaded . . .


Reviews (8)

Login/join to subscribe

"A jury consists of 12 persons chosen to decide who has the better lawyer."

- Robert Frost