Download

Use a free SPERT® Excel template.

Estimate. Align. Decide.

Do you need to make an important decision about the future?

Do you need to choose from different investment choices or new product development ideas?

Maybe you just need to align stakeholder expectations on schedule and cost for something you’re building or wanting to build?

If so, then download Statistical PERT® now – it’s free!

If you can render a subjective judgment about any bell-shaped uncertainty – and you have access to Microsoft Excel® (2010 / 2013 / 2016 / 2019 / Microsoft 365) – you can use the Statistical Program Evaluation and Review Technique (Statistical PERT® , or just SPERT®).  Statistical PERT lets anyone create a probabilistic estimate or forecast using the built-in functions of Microsoft Excel.  Statistical PERT requires only two inputs to provide an infinite number of probabilistic estimates for the future.  Here’s all you do:

  1. Create a 3-point estimate for a bell-shaped uncertainty, like task duration, project expense, or user story count
  2. Render a subjective judgment about how likely the most likely outcome really is
  3. Select any probabilistic planning estimate, or make a risk-based forecast

That’s it!

Choose a cost estimate or task duration that has a very low probability of being exceeded — or cut that estimate and assume more risk that your budget or schedule won’t be enough.  Forecast an agile product’s likely release date, or what features will likely be included by a hard delivery date.  Forecast revenue.  Estimate entire projects and create project schedules with timelines that perfectly fit your risk tolerance.  Play what-if scenarios to see how choosing different inputs into the model will affect the resulting probabilities.

You make the final call!  Using Statistical PERT, you now have a variety of probabilistic estimates at your fingertips to make the best choice.

Statistical PERT® templates and example workbooks are Excel files that use standard, built-in Excel functions to forecast the future.  There is nothing to buy, nothing to install, no macros, no advertising, no adware, and no registration required!

There are two, production-ready editions of Statistical PERT:  Normal Edition and Beta Edition.

  • The Normal Edition uses Excel’s two normal distribution functions, NORM.DIST and NORM.INV
  • The Beta Edition uses Excel’s two beta distribution functions, BETA.DIST and BETA.INV
  • Both editions of Statistical PERT are very easy to use

The Normal Edition is easier for a user to customize, whereas the Beta Edition is better suited to modeling a wider range of bell-shaped uncertainties, including uncertainties that are moderately-to-heavily skewed.  Both editions are freely licensed under the GNU General Public License, and both editions are ad-free and macro-free.  Download Statistical PERT® example workbooks or templates now, and try using both editions of Statistical PERT!

Plus, there are two NEW editions of Statistical PERT family that are in active development and will be production-ready soon: Bootstrap Edition (late 2020) and Lognormal Edition (early 2021).

  • The Bootstrap Edition uses statistical bootstrapping to create forecasts for agile teams using their historical records.  The Bootstrap Edition has one worksheet for Scrum teams and another for Kanban teams.
  • The Lognormal Edition uses Excel’s two lognormal distribution functions, LOGNORM.DIST and LOGNORM.INV
  • Both of these new editions of Statistical PERT are also very easy to use, too!
  • You can download development-build versions of these two editions under the “Bonus Downloads” section on this site’s downloads page.

Important Notice:  This site’s Terms of Agreement & Privacy Policy page was last updated on September 13, 2020  Please read over this site’s Terms of Agreement, Warranty Disclaimer, and Privacy Policy before downloading or using any files from this site.

SPERT_HD_Page_Logo

Statistical PERT®, SPERT®, Estimation Made Easy® - © 2015-2020 by William W. Davis, MSPM, PMP. All rights reserved.