|
|
Featured Tutorial
Featured Macro
Excel Statistics 57: Build Discrete Probability Distribution & Chart
Topics for Discrete Probability Distributions:
1.Define Random Variable
2.Build Frequency Distribution
3.Calculate Relative Frequency -P(x) f(x)
4.Check Requirement #1: Probability Greater Than Or Equal To Zero
5.Check Requirement #2: Sum of Probabilities Equal to One
6.Create a Column Chart for a Discrete Variable (Columns do not touch)
7.Link chart elements to cells
8.SUMIF function for adding probabilities
9.Make predictions Calculate Probabilities
1.Define Random Variable
2.Build Frequency Distribution
3.Calculate Relative Frequency -P(x) f(x)
4.Check Requirement #1: Probability Greater Than Or Equal To Zero
5.Check Requirement #2: Sum of Probabilities Equal to One
6.Create a Column Chart for a Discrete Variable (Columns do not touch)
7.Link chart elements to cells
8.SUMIF function for adding probabilities
9.Make predictions Calculate Probabilities