Easily Estimate Projects and Products
Estimating and forecasting don’t have to be time-consuming or difficult. This course will teach you how to use Microsoft Excel and a freely licensed estimation technique called Statistical PERT to easily estimate your projects and products.
What you'll learn
Have you ever had a difficult time creating a project schedule or budget or been unsure how to forecast when new features will be ready for your agile-developed product? If so, this is the perfect course for you. In this course, Easily Estimate Projects and Products, you will learn how to easily create estimates for any uncertainty that has common, bell-shaped risk characteristics, like how much a project will cost or how long it will take to develop features on your product backlog. First, you’ll learn the difference between estimates, predictions, and forecasts and why forecasts are superior to predictions. Next, you'll explore how to easily create probabilistic estimates using Statistical PERT. Finally, you’ll discover how Statistical PERT models your project and product uncertainties using the normal probability distribution curve. When you’re finished with this course, you'll not only know how to use Statistical PERT to confidently estimate your project and product uncertainties, but you'll know how to modify Statistical PERT to create even better forecasts in the future. Software required: Microsoft Excel 2010 or later.
Table of contents
- The Normal Distribution and Monte Carlo Simulation 7m
- The Normal Distribution and Statistical PERT 2m
- Bell-shaped Curves Are All around Us 2m
- NORM.DIST and NORM.INV 4m
- Program Evaluation and Review Technique (PERT) 2m
- PERT Formula for Estimating the Mean 2m
- Four Reasons Why Estimating Is Hard 5m
- Estimating with Statistical PERT: 5 Steps 3m
- Module Summary 3m
- Downloading a Statistical PERT Template 2m
- All Models Are Wrong (But Some Are Useful) 3m
- How Many Pennies Are in This Penny Jar?: Part 1 9m
- How Many Pennies Are in This Penny Jar?: Part 2 6m
- Using the SPERT Normal Charts Tab 3m
- Using the SPERT Normal (3-Point Entry) Tab 3m
- Create a Portfolio Budget 3m
- Make an Agile Delivery Forecast 8m
- Module Summary 2m
- The Problem That Statistical PERT Solves 4m
- The SPERT Standard Deviation Formula 3m
- Estimating a Trip to the Fort Lauderdale Airport 4m
- Estimating a Trip to the Los Angeles Airport 5m
- SPERT Ratio Scale Modifiers 2m
- Wheel of Fortune 5m
- Gumball Machine 5m
- Comparing Bell-shaped Curves 6m
- Module Summary 2m