Blog

Learn about Statistical PERT
Normal Edition

Beta Blog

Learn about Statistical PERT
Beta Edition

Statistical PERT® (SPERT®) is a stochastic estimation technique that lets anyone create probabilistic estimates for bell-shaped uncertainties – for free!

May 28, 2017 – “Stop Predicting, Start Forecasting” is the presentation I will give on Friday, June 9, 2017, at South Florida’s premier event for project professionals, the PMI South Florida Chapter‘s Professional Development Day!  Learn the difference between predicting and forecasting future uncertainties, and why it’s better to forecast than predict the future.  Can’t attend my presentation that day?  You can still download my whitepaper that I wrote for the University of Maryland’s 2017 Project Management Symposium: “Stop Predicting, Start Forecasting.”

March 28, 2017 – “Stop Predicting, Start Forecasting” is the presentation I will give on Thursday, May 4, 2017, at the University of Maryland’s 2017 Project Management Symposium in College Park, Maryland.  This presentation will explore the difference between predicting and forecasting uncertain, future outcomes.  We’ll examine why meteorologists are called “weather forecasters” (not “weather predictors”) and see how project managers can, like meteorologists, better align stakeholder expectations and improve decision-making through forecasting.  UMD’s Project Management Symposium is the premier project management event in the Washington DC metro area, and brings presenters and attendees together for a two-day symposium exploring project management topics in five different tracks, including Agile/IT and Integrated Program Management.  If you can’t attend this UMD’s Symposium, you can still download and read my Symposium whitepaper, “Stop Predicting, Start Forecasting.”

March 24, 2017Read a whitepaper on Soothsayer™.  Soothsayer is a freely-licensed, Excel-based, probabilistic, estimation technique for creating a dynamic, right-sized, contingency reserve for either schedule or cost.  Use Soothsayer to develop a project contingency for risks when doing risk analysis, or to add a right-sized buffer in a project schedule or budget based upon the reliability of each task duration or cost estimate.  AACE® International will publish this whitepaper in its Transactions for the 2017 AACE® International Annual Meeting, held this year in Orlando, Florida.  After reading the whitepaper, try downloading and using Soothsayer™ for Project Risk Analysis.

March 1, 2017 – Released Version 1 for Statistical PERT® Beta Edition (and Version 2.2 of Statistical PERT® Normal Edition).  The Beta Edition release is the first production release of Statistical PERT that uses Microsoft Excel’s two beta distribution functions, BETA.DIST and BETA.INV.  The beta distribution can model a wide range of bell-shaped uncertainties, even if they are severely skewed, making the Beta Edition the most flexible way to model project uncertainties.  The new Version 2.2 of the Normal Edition adds a new Beginners tab that makes it even easier to understand and use Statistical PERT.  Read the press release that announces Version 1 of Statistical PERT® Beta Edition.

February 8, 2017 – Released Version 2.1 for Statistical PERT® Normal Edition (and Release Candidate 1 of Statistical PERT® Beta Edition).  This version includes a new “SPERT® Normal (Mixed entry)” worksheet that allows for manually-entered 3-point estimates plus global and individual heuristics for generating minimum and maximum point-estimates.  This offers estimators the greatest amount of flexibility for creating 3-point estimates.  Use global heuristics to generate minimum and maximum point-estimates, or override the global heuristic for any row with either manually-entered, minimum and/or maximum values, or select a row-specific percentage adjustment to the Most Likely outcome to create a unique minimum and/or maximum point-estimates.

January 12, 2017 – Released minor version 2.0.2 to Statistical PERT® Normal Edition (and 0.6 Build 3 of Statistical PERT® Beta Edition).  Later in 1Q 2017, a new version will include a new “SPERT® Normal (Mixed entry)” worksheet that will allow for both manually-entered 3-point estimates and both global and individual heuristics for generating minimum and maximum point-estimates.

January 6, 2017Project Summit / Business Analyst World Conference in Dallas
Learn about Agile Transformation, Risk Analysis, and Statistical PERT at the upcoming Project Summit / Business Analysis World conference coming to Dallas, February 6 and 7, 2017. On Monday, February 6, I will present, ‘Start an Agile Transformation (When You’re Not Sitting in the C-Suite).’ And on Tuesday, February 7, I will present, ‘Protect Your Project by Soothsaying the Risk Register.’ Along the way, I’ll be sharing Statistical PERT with conference attendees, too. Join me – now just one month away!

January 4, 2017 – SPERT® Mobile for Excel® Mobile, Version 1.0.1 Released
SPERT® Mobile is a special adaptation of Statistical PERT for smartphone and tablet users.  SPERT® Mobile uses the normal distribution functions of Excel to easily make probabilistic estimates.  This specially-sized Excel template displays great on smaller screen sizes.  This minor update adds a little better formatting and cell editing.

January 2, 2017 – Statistical PERT® Normal Edition, Version 2 Released
The newest version of Statistical PERT lets you easily make probabilistic estimates using just a single value (most likely) estimate for any uncertainty with bell-shaped risk properties, like:  task duration, work effort, expenses, revenue, agile story points, project portfolios, event attendance and more.  Improved formatting lets you choose whether to see the left-side or right-side area under the bell-curve.  This new version is now branded as the “Normal Edition” of Statistical PERT, indicating that it uses Excel’s two normal distribution functions, NORM.DIST and NORM.INV, and to distinguish it from the Beta Edition.  A new development version of the Beta Edition, which uses Excel’s two beta distribution functions, BETA.DIST and BETA.INV, is also available.

December 23, 2016What’s New in Version 2, SPERT Comparison with RiskPERT
Want to know what’s new in the upcoming Version 2 release of Statistical PERT – Normal Edition?  Check out this blog post.  Want to see how Statistical PERT compares with Palisade’s @Risk risk analysis tool?  Read this blog post.  Statistical PERT – Normal Edition Version 2 and Statistical PERT – Beta Edition Version 0.6 will both be released on Monday, January 2, 2017.

December 19, 2016PMBA Conference in Dallas – February 2017
Learn about Agile Transformation, Risk Analysis, and Statistical PERT at the upcoming Project Summit / Business Analysis World conference coming to Dallas, February 6 and 7, 2017. On Monday, February 6, I will present, ‘Start an Agile Transformation (When You’re Not Sitting in the C-Suite).’ And on Tuesday, February 7, I will present, ‘Protect Your Project by Soothsaying the Risk Register.’ Along the way, I’ll be sharing Statistical PERT with conference attendees, too. Join me!

December 12, 2016Statistical PERT – Beta Edition Version 0.5 Build 1 released
This is a development build of the next edition of Statistical PERT using the beta distribution.  The initial production release of the Statistical PERT – Beta Edition should be available in early 2017.  The December build hides columns and makes formatting changes to prepare for the production release next year.  Download SPERT-Beta Version 0.5 Build 1 now!

Also, Statistical PERT – Normal Edition, Version 2.0 is announced, and it, too, will be available for downloading in early 2017. Read about all these exciting changes for Statistical PERT here.

November 5, 2016Statistical PERT – Beta Edition Version 0.4 Build 2 released
This is a development build of the next edition of Statistical PERT using the beta distribution.  The initial production release of the Statistical PERT – Beta Edition should be available in early 2017.  The November build adds a pie chart to show the user-specified confidence interval, and the same data validation for the three-point estimate as used in the latest release of the Statistical PERT – Normal Edition.  Download SPERT-Beta Version 0.4 Build 2 now!

October 23, 2016Statistical PERT is on Twitter!
If you want to keep informed about the latest updates and new releases of Statistical PERT, including the 2017 release of Statistical PERT – Beta Edition, follow this website on Twitter (@statisticalpert).  The Statistical PERT website doesn’t require you to share any personal information, register, or create an account before downloading any of the Statistical PERT Excel templates and example workbooks.  So, if you want to stay informed about future changes to Statistical PERT, just follow Statistical PERT on Twitter.

October 12, 2016Palisade’s 2016 Risk Conference in New Orleans
I’ll be attending Palisade’s biggest risk management event of the year in New Orleans, November 1 & 2.  Statistical PERT’s development was greatly helped by comparing its results with Monte Carlo simulations using Palisade’s Excel add-in program, @Risk7.  If you’re attending this event, contact me and let’s connect!

October 11, 2016New Statistical PERT YouTube channel, 1st video published
Today is launch-day for the Statistical PERT YouTube channel!  The first, 16-minute video answers the question, “Why Use Statistical PERT?”  Look for more videos soon to learn much more Statistical PERT and how to create probabilistic estimates and forecasts for your projects.

October 10, 2016Interview with popular PM blogger, Elizabeth Harrin published
Elizabeth publishes a popular blog entitled, A Girl’s Guide to Project Management.  Elizabeth has been blogging about project management topics for many years, and her visually appealing blog is one of the best I’ve seen, as is her content and writing style.  Oh, and despite its name, the site is perfectly suited for male project managers, too.  😉

October 7, 2016Statistical PERT – Beta Edition Version 0.3 Build 2 released
This is a development build of the next edition of Statistical PERT using the beta distribution.  The initial production release of the Statistical PERT – Beta Edition should be available in early 2017.  Download SPERT-Beta Version 0.3 Build 2 now!

October 4, 2016Version 1.4 Released!  This new version makes it easy to create probabilistic confidence intervals for easier range forecasting.  And new pie charts show, visually, what uncertainty looks like.  Try downloading a template today!  Click here to learn more about Version 1.4.

September 20, 2016SPERT comes to the 2016 PMI Global Congress – North America!  The 2016 PMI Global Congress is less than a week away! Spend part of your conference day learning when, why and how to use Statistical PERT on your projects by attending a 90-minute presentation, Easily Estimate Projects Using Statistical PERT, on Monday, September 26, 2016, from 3:15PM – 4:45PM.  Download the PMI whitepaper and presentation here.

September 16, 2016Download all SPERT files securely!  Starting today, all connections to this site will use Secure Socket Layer (SSL) to encrypt your connection.  Whether you’re browsing or downloading, you’ll enjoy the utmost in privacy and confidence when you use the Statistical PERT website!

September 12, 2016SPERT™ Mobile is released!
This is special version of Statistical PERT for mobile device users.  This simplified SPERT spreadsheet puts the ease and power of Statistical PERT estimation into your hands, wherever you go.  The spreadsheet format lets mobile iPhone and Android users easily see and interact with a simple SPERT spreadsheet.  To use this special version of Statistical PERT on your smartphone, you must install Excel Mobile on your mobile device.  Visit the iTunes store or Google Play to download a free copy of Excel Mobile.

September 10, 2016Statistical PERT Version 1.3 for Estimating Tasks is released!
This version offers a new way to specify a confidence interval for all tasks, and see a pie chart of the resulting confidence interval.  Also, there is a Quick Start PDF download available to quickly learn how to use and modify any Statistical PERT spreadsheet.

September 5, 2016Statistical PERT – Beta Edition Version 0.2 Build 5 released
This is a development build of the next edition of Statistical PERT using the beta distribution.  The initial production release of the Statistical PERT – Beta Edition should be available in early 2017.  Download SPERT-Beta Version 0.2 Build 5 now!

August 29, 2016“Soothsay Your Risk Register” on ProjectManagement.com

August 22, 2016“Risk Management Starts Sooner Than You Think” on ProjectManagement.com

July 29, 2016Check out my Statistical PERT presentation details at the 2016 PMI Global Congress – North America

June 16, 2016 – The AACE Int’l Annual Meeting is days away!  Visit me there to learn about Statistical PERT!

June 4, 2016 – Attend my seminar on Statistical PERT at the 2016 PMI Global Congress – North America!

April 30, 2016 – See Statistical PERT in action at the 2016 AACE Annual Meeting in Toronto this June

February 20, 2016 – See Statistical PERT in action at the 2016 Restoration Industry Association conference

October 26, 2015“Evaluating Benefits:  Get Statistical (Part 3)” on ProjectManagement.com

October 19, 2015“Evaluating Benefits:  Get Statistical (Part 2)” on ProjectManagement.com

October 12, 2015“Evaluating Benefits:  Get Statistical (Part 1)” on ProjectManagement.com

October 6, 2015New Statistical PERT template released for annual portfolio planning

October 2, 2015 – Statistical PERT example workbooks and templates are compatible with Excel 2016

September 15, 2015“Introducing Statistical PERT” on ProjectManagement.com

September 14, 2015Statistical PERT – Beta Edition Announcement

September 9, 2015“How Statistical PERT Gives Programmers Confident Estimates” on Pluralsight’s Blog

SPERT_HD_Page_Logo