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

Related Content

People who downloaded this item also downloaded . . .

Premium Content
PMI Membership
$129 /year
(plus $10 application fee)
Sign up to download this deliverable and get unlimited access to our library of webinars, time-saving templates and more.
PMI Membership perks include job opportunities, local chapters, respected publications, and standards.   Learn more
Already a PMI Member? Log in now.



Reviews (7)

Login/join to subscribe

"Education is the ability to listen to almost anything without losing your temper."

- Robert Frost