Statistical PERT® Beta Edition
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