Scribd
Upload
6 views2 pages

Expected Value and Standard Deviation Calculator

This module calculates statistical measures like expected value, variance, standard deviation, and coefficient of variation given probabilities and outcomes. It allows the user to enter up to 5 probabilities and corresponding outcomes. Sample data is provided as an example that calculates the expected value as 3000, variance as 1300000, standard deviation as 1140.18, coefficient of variation as 0.38, and Z-statistic as -1.7541 given the probabilities and outcomes entered.

Uploaded by

sappz3545448
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
6 views2 pages

Expected Value and Standard Deviation Calculator

This module calculates statistical measures like expected value, variance, standard deviation, and coefficient of variation given probabilities and outcomes. It allows the user to enter up to 5 probabilities and corresponding outcomes. Sample data is provided as an example that calculates the expected value as 3000, variance as 1300000, standard deviation as 1140.18, coefficient of variation as 0.38, and Z-statistic as -1.7541 given the probabilities and outcomes entered.

Uploaded by

sappz3545448
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

MODULE 14A

EXPECTED VALUE AND STANDARD DEVIATION


OBJECTIVE:
This program calculates the expected value (cell B56), variance
(E56), standard deviation (E58), the coefficient of variation
(E60), and the Z-statistic (E62), given a set of possible
outcomes and the probability distribution.
INPUTS (WILL APPEAR IN BLUE):
1) Enter up to five probabilities (as decimals) in cells A27 A31. The total must add up to 1.
2) Enter up to five outcomes (R), corresponding to the
probabilities, in cells B27 - B31.
3) If a Z-statistic is desired, enter a value for X in cell
B40.
The caret ^ in formulas signifies an exponent: x^2 is x squared.
GRAPH:
A graph can be viewed by pressing GRAPH (located at the bottom of
the screen.
SAMPLE DATA HAVE BEEN ENTERED AS AN EXAMPLE:

P
0.10
0.25
0.30
0.25
0.10

R
1000
2000
3000
4000
5000

1.00

3000

RISK CALCULATIONS
R-ER
(R-ER)^2
-2000
4000000.00
-1000
1000000.00
0
0.00
1000
1000000.00
2000
4000000.00

Variance

1300000

Stand. dev.

1140.18

Coeff. of var.
X

1000

P*(R-ER)^2
400000.00
250000.00
0.00
250000.00
400000.00

Z-statistic

0.380
-1.7541

You might also like