Statistical Functions - Expected Value?

M

unread,

Mar 16, 2004, 7:34:10 PM3/16/04

to

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

Norman Harker

unread,

Mar 16, 2004, 7:40:49 PM3/16/04

to

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
njha...@optusnet.com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"M" <anon...@discussions.microsoft.com> wrote in message
news:e66c01c40bb7$90d02fa0$a401...@phx.gbl...

Harlan Grove

unread,

Mar 16, 2004, 7:50:53 PM3/16/04

to

"M" wrote...

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

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).

--
To top-post is human, to bottom-post and snip is sublime.

M

unread,

Mar 16, 2004, 8:06:37 PM3/16/04

to

Thanks to both of you! Yes, that will most certainly do
the trick.

M

>.
>

Norman Harker

unread,

Mar 16, 2004, 10:19:40 PM3/16/04

to

Hi M!

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

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
njha...@optusnet.com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"M" <anon...@discussions.microsoft.com> wrote in message

news:e6a001c40bbc$1912dbc0$a401...@phx.gbl...