MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Easily Estimate Projects Using Statistics and Excel

Course Summary

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 Syllabus

    Easily Estimate Projects Using Statistics and Excel
    - 45m 13s

    —Course Introduction 5m 18s
    —Introduction to Statistical PERT and Unified Scheduling Method 4m 37s
    —Estimation Techniques 3m 9s
    —Estimating in the Area of Uncertainty 4m 2s
    —Statistics Refresher Introduction 0m 53s
    —Mean, Median and Mode 8m 17s
    —Standard Deviation 9m 41s
    —Bell-shaped Curves 2m 5s
    —Excel's Statistical Functions 4m 14s
    —Conclusion 2m 52s
    Foundational Underpinnings of Statistical PERT
    - 58m 54s

    —Objectives 6m 21s
    —PERT Estimation 7m 2s
    —Parkinson's Law 7m 1s
    —Normal Distribution using NORM.DIST (Part 1) 5m 22s
    —PERT Standard Deviation 5m 32s
    —Normal Distribution using NORM.DIST (Part 2) 2m 41s
    —SPERT Estimation with High Expectation 10m 14s
    —SPERT Estimation with Low Expectation 5m 24s
    —SPERT Estimation with Moderate Expectation 2m 21s
    —Characteristics of SPERT 3m 52s
    —Conclusion 2m 58s
    Demonstrate Statistical PERT in Excel
    - 1h 4m
    The Unified Scheduling Method (USM)
    - 1h 1m
    Statistical PERT for Agile Teams
    - 1h 1m


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Related Posts:

Attended this course?

Back to Top

 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url