Statistical Functions - Expected Value?

  • Thread starter Thread starter M
  • Start date Start date
M

M

Is there a function that can be placed in a cell to
calculate Expected Value? A function in VBA would be
acceptable too.

Thanks

M
 
Hi M!

Where Values are in A1:A5 and Probabilities are in B1:B5

=SUMPRODUCT(A1:A5,B1:B5)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Is there a function that can be placed in a cell to
calculate Expected Value? A function in VBA would be
acceptable too.
Click to expand...

What sort of expected values? Expected values from histogram data? Norman Harker
has already addressed that case. Expected values for random variables from
distributional form X with parameters Y? There are formulas in most stats texts
that give these. For example, a normally distributed rv with parameters m and s
has exected value m, while a lognormally distributed rv with parameters m and s
has exected value EXP(m + 0.5 * s^2).
 
Hi M!

Good to note that it's what you needed. But note Harlan's comments.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top