mytest > help > Part 2. MM4XL Tools > 2. Analytical Tools > Business Formulas > 6. Project Management > mmPERTVAR, Expected Variance of an Activity

Business Formulas

mmPERTVAR, Expected Variance of an Activity

Category: Project Management

The PERT Project Management function mmPERTVAR assumes that the time required to perform the project activities is not known with certainty. Using estimate duration this formula estimates the variance of the completion time.

Business analysis formulas for Excel. Marketing tool for professionals

Where:

O = Optimistic estimate of the activity duration
P = Pessimistic estimate of the activity duration

Syntax

mmPERTVAR(Optimistic, Pessimistic)

Optimistic The smallest time estimate to complete the project
Pessimistic The largest time estimate to complete the project

Example

See example file Business Formulas.xls, sheet mmPERTVAR.

Business analysis formulas for Excel. Marketing tool for professionals

Related functions
  • mmDHMS
  • mmLEARN
  • mmPERTSD
  • mmPERTT
  • mmINTERPOLE
  • mmMD1
  • mmMG1
  • mmMMS
  • mmMMSP
  • mmMMSQ
  • mmRANGE
  • mmRANK
Related MM4XL software tools
  • Quality Analyst
  • Decision Tree
  • Descriptive Statistics
  • Semantic Differential
  • Smart Map
Source
Cliff T. Ragsdale, 2001, Spreadsheet modeling and decision analysis
Lifetime license:

Price: euro

Vote this tool
We proudly serve
Your vote
vote1 vote2 vote3 vote4 vote5
Email:
Gender:
M
F
Age:
Position:
Department:
Comment: