Welcome Guest
You last visited January 19, 2017, 8:41 pm
All times shown are
Eastern Time (GMT-5:00)

# Excel Functions - statistics

Topic closed. 7 replies. Last post 10 years ago by JADELottery.

 Page 1 of 1
Cleveland, Ohio
United States
Member #11445
February 13, 2005
1303 Posts
Offline
 Posted: October 5, 2006, 7:35 pm - IP Logged

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.

Findlay, Ohio
United States
Member #4855
May 28, 2004
400 Posts
Offline
 Posted: October 5, 2006, 8:23 pm - IP Logged

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.

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

~Probability=Odds in Motion~

New Jersey
United States
Member #17843
June 28, 2005
51098 Posts
Offline
 Posted: October 5, 2006, 8:49 pm - IP Logged

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

Reference

United States
Member #41383
June 16, 2006
1969 Posts
Offline
 Posted: October 6, 2006, 12:49 am - IP Logged

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/

The Quantum Master
West Concord, MN
United States
Member #21
December 7, 2001
3684 Posts
Offline
 Posted: October 26, 2006, 10:54 pm - IP Logged

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.

Presented 'AS IS' and for Entertainment Purposes Only.
Any gain or loss is your responsibility.
Use at your own risk.

Order is a Subset of Chaos
Knowledge is Beyond Belief
Wisdom is Not Censored
Douglas Paul Smallish
Jehocifer

The Quantum Master
West Concord, MN
United States
Member #21
December 7, 2001
3684 Posts
Offline
 Posted: October 26, 2006, 11:05 pm - IP Logged

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

Presented 'AS IS' and for Entertainment Purposes Only.
Any gain or loss is your responsibility.
Use at your own risk.

Order is a Subset of Chaos
Knowledge is Beyond Belief
Wisdom is Not Censored
Douglas Paul Smallish
Jehocifer

New Member

United States
Member #7839
October 14, 2004
4 Posts
Offline
 Posted: October 28, 2006, 4:10 pm - IP Logged

## RE: How is this applied to excel ?

Standard Member

Waukesha, WI
United States
Member #21
December 7, 2001
518 Posts
Offline
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,

I notice your Function for the (# 9  &  # 10) probability of occurence, how is it enter into Excel ! (Function) ??....

Josephjphs2002@yahoo.com

The Quantum Master
West Concord, MN
United States
Member #21
December 7, 2001
3684 Posts
Offline
 Posted: October 28, 2006, 5:45 pm - IP Logged

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

The sample sheet:

 _ C D 9 Mean (m) = 9.44 10 Standard Deviation (s) = 2.65 11 12 Number in the Distribution (x) ¯ Probability of Selection Percent Probability of Selection 13 1 0.0009 0.09 14 2 0.0029 0.29 15 3 0.0079 0.79 16 4 0.0183 1.83 17 5 0.0370 3.70 18 6 0.0648 6.48 19 7 0.0985 9.85 20 8 0.1299 12.99 21 9 0.1485 14.85 22 10 0.1472 14.72 23 11 0.1266 12.66 24 12 0.0944 9.44 25 13 0.0611 6.11 26 14 0.0343 3.43 27 15 0.0167 1.67 28 16 0.0070 0.70 29 17 0.0026 0.26 30 18 0.0008 0.08 31 19 0.0002 0.02 32 20 0.0001 0.01

Adding the Percent Probability for 9 and 10 (14.85 + 14.72) calculates to a 29.57% probability of a 9 or a 10 being selected from this distribution based on the mean of 9.44 and standard deviation of 2.65.

Presented 'AS IS' and for Entertainment Purposes Only.
Any gain or loss is your responsibility.
Use at your own risk.

Order is a Subset of Chaos
Knowledge is Beyond Belief
Wisdom is Not Censored
Douglas Paul Smallish
Jehocifer

 Page 1 of 1