Excel Functions - statistics

Reply #7

JADELottery — Sat, 28 Oct 2006 21:45:30 GMT

The formatted Execl function: =(1/(D$10*SQRT(2*PI())))*EXP((-1*(C13-D$9)^2)/(2*D$10^2))

The sample sheet:

_CD

9Mean (m) =

9.44

10Standard Deviation (s) =

2.65

11

12Number in the Distribution (x) Probability of SelectionPercent Probability of Selection

1310.00090.09

1420.00290.29

1530.00790.79

1640.01831.83

1750.03703.70

1860.06486.48

1970.09859.85

2080.129912.99

2190.148514.85

22100.147214.72

23110.126612.66

24120.09449.4... [ More ]

Reply #6

Josephjphs — Sat, 28 Oct 2006 20:10:20 GMT

RE: How is this applied to excel ?

JADELottery

Standard Member

Waukesha, WI

United States

Member #21

December 7, 2001

518 Posts

Offline

< Prev | Next >Received: Today, 2:27 am

It would serve everyone best if you ask this question in the forum.

Doug

Previous Private Message

Sent By : Josephjphs

Sent : October 28, 2006, 2:01 am

Hi,

JADELottery.

I notice your Function for the (# 9 # 10) probability of occurence, how is it enter into Excel ! (Fu... [ More ]

Reply #5

JADELottery — Fri, 27 Oct 2006 03:05:54 GMT

Also, to get the probabilty of both 9 and 10 together, just sum the calculations for both.

Reply #4

JADELottery — Fri, 27 Oct 2006 02:54:33 GMT

The function is :

1 -( (x - m)2/ 2 s2)

y = ---------- e

s 2 p

x - number in the distribution

m - mean

s - standard deviation

y - probability of x occurence

note: multiply y by 100% to get percentage.

Reply #3

guesser — Fri, 06 Oct 2006 04:49:55 GMT

Register for free at the website below, and ask there in the 'Business Applications' section.

You will have a choice of good answers in about 12 hours:

http://forums.techguy.org

Reply #2

Raven62 — Fri, 06 Oct 2006 00:49:34 GMT

PROB Returns the probability that values in a range are between two limits

Reference

Reply #1

Thoth — Fri, 06 Oct 2006 00:23:49 GMT

Exactly what probability are u wanting to know and for what game

Excel Functions - statistics

Snakeyes — Thu, 05 Oct 2006 23:35:57 GMT

I am trying to figure out how to calculate a probability using the function command in Excel and am drawing a blank.

I have a mean of 9.44, standard deviation of 2.65 and am trying to get the probability of a number coming out between 9 and 10.

I thought NORMINV would do the trick, but....no luck.

Any help is appreciated. Mind you, I am not a stat's expert so, I could be doing this wrong altogether.