Welcome Guest
Log In | Register )
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
PrintE-mailLink
Snakeyes's avatar - 8579390479 65f71643cf_m.jpg
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.

    Thoth's avatar - binary
    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~

      Raven62's avatar - binary
      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

        guesser's avatar - Lottery-017.jpg

        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/

          JADELottery's avatar - YingYangYong 01.PNG
          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

            JADELottery's avatar - YingYangYong 01.PNG
            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

              Avatar
              New Member

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

              Delete MessageSend a ReplyRE: How is this applied to excel ?


              Avatar

              Standard Member
              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 ! (Function) ??....

               Thx  For your reply.

              Josephjphs2002@yahoo.com

                JADELottery's avatar - YingYangYong 01.PNG
                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:

                 

                 
                _CD
                9

                Mean (m) =

                 9.44 
                10

                Standard 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.44
                25130.06116.11
                26140.03433.43
                27150.01671.67
                28160.00700.70
                29170.00260.26
                30180.00080.08
                31190.00020.02
                32200.00010.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