Easily Estimate Projects Using Statistics and Excel

Use Microsoft Excel's built-in statistical functions, course template files, and your own project knowledge to easily and confidently estimate project durations, work efforts, costs, agile sprints, and agile releases. Use the Unified Scheduling Method to confidently create a dynamic, right-sized project reserve for traditional projects.
Course info
Rating
(75)
Level
Beginner
Updated
Jul 15, 2015
Duration
4h 51m
Table of contents
Easily Estimate Projects Using Statistics and Excel
Foundational Underpinnings of Statistical PERT
Demonstrate Statistical PERT in Excel
The Unified Scheduling Method (USM)
Statistical PERT for Agile Teams
Description
Course info
Rating
(75)
Level
Beginner
Updated
Jul 15, 2015
Duration
4h 51m
Description

How confident are you when you create project schedules and budgets? How confident does your project sponsor want you to be? What would it cost to increase your confidence, or how much less costly would your project be if you accepted more risk? Using Microsoft's built-in statistical functions, you can easily create probabilistic project estimates using just a 3-point estimate (minimum, most likely, maximum) for any uncertain outcome and a subjective opinion about how likely the most likely outcome really is. Using the normal distribution probability curve and Excel's statistical functions, it's easy to see the difference between low risk, high cost, long schedule estimates from high risk, low cost, short schedule estimates. The key concept that this course introduces is called Statistical PERT, which goes well beyond the Program Evaluation and Review Technique (PERT.) Statisitical PERT can be used by both traditional and agile project teams to create project-related estimates. Using additional Excel statistical functions, this course also shows how traditional project teams can use the Unified Scheduling Method to create dynamic, right-sized project reserves for when their Statistical PERT estimates are exceeded during the project execution phase. Confidently create project estimates to fit any tolerance for risk you want using Microsoft Excel, Statistical PERT, and the Unified Scheduling Method!

About the author
About the author

William is an experienced Scrum Master, agilist, and project manager who creates positive transformations through training, coaching, and mentoring software development teams.

More from the author
Forecasting for Agile Teams
Intermediate
2h 48m
Sep 11, 2019
Easily Estimate Projects and Products
Beginner
2h 51m
Mar 14, 2019
Scrum Essentials Exam Prep
Intermediate
3h 8m
Oct 8, 2018