Welcome Guest
Log In | Register )
You last visited December 3, 2016, 6:31 am
All times shown are
Eastern Time (GMT-5:00)

Excel Help Needed

Topic closed. 6 replies. Last post 8 years ago by Bob.

Page 1 of 1
PrintE-mailLink
Avatar
Michigan
United States
Member #59
November 10, 2000
377 Posts
Offline
Posted: June 30, 2008, 7:38 am - IP Logged

How does one figure out a frequency number in excel??

example

No.---Times hit
0-----8
1-----4
3-----6
2-----1
3-----7
4-----0
5-----2
6-----8
7-----5
8-----3
9-----1
total 45---Hits

Do you divide hits into total hits to find the frequency??
example ---to find out the number say 3 it hit 7 times do
you divide 7/45  ???? to get the frequency????
Need some excel help.....
Thank you
Bob in Michigan
learning excel slow but sure----

    CARBOB's avatar - FL LOTTERY_LOGO.png
    ORLANDO, FLORIDA
    United States
    Member #4924
    June 3, 2004
    5893 Posts
    Offline
    Posted: June 30, 2008, 8:42 am - IP Logged

    Divde number of draws by number of hits= avg

    example

    45/3=15

      Avatar
      Michigan
      United States
      Member #59
      November 10, 2000
      377 Posts
      Offline
      Posted: June 30, 2008, 9:11 am - IP Logged

      #DIV/0! 4
      45.00-- 9
      22.50-- 5
      15.00-- 8
      11.25-- 1
      9.00--- 7
      7.50--- 2
      6.43--- 3
      5.63--- 0
      5.63--- 6
      Total--45 hits
      ok got it and thank you carBob----but I get a #DIV/0! on the 4
      because they were no hits...?????thats normall???
      Would the 4 go on the bottom ???
      Thanks again CARBOB

      Bob in Michigan

        time*treat's avatar - radar

        United States
        Member #13130
        March 30, 2005
        2171 Posts
        Offline
        Posted: June 30, 2008, 9:22 am - IP Logged

        times a number hit / total hits

        0/45 = 0

        In neo-conned Amerika, bank robs you.
        Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.

          Avatar
          Michigan
          United States
          Member #59
          November 10, 2000
          377 Posts
          Offline
          Posted: June 30, 2008, 12:58 pm - IP Logged

          Getting kind of confused here-----

          CarBob puts it 45/3

           

          Time*treat puts it 0/45

           

          I am just learning myself but thinking that carbob is the way to go--

          Hits total / divided by Hits

          Example ----- if the number 5 had 8 Hits and the total was 45 hits

          than you would take 45 /divided by  8--------------45/8==5.62

          Hope that is right---

          Thanks

          Bob in Michigan

            Raven62's avatar - binary
            New Jersey
            United States
            Member #17843
            June 28, 2005
            49618 Posts
            Offline
            Posted: June 30, 2008, 2:23 pm - IP Logged

            If you want the Frequency over a Period of Time (Last 20 Draws) use the =countif Function over the selected Range of Addresses (Period of Time) for each Digit (0 to 9).

            A mind once stretched by a new idea never returns to its original dimensions!

              Avatar
              Michigan
              United States
              Member #59
              November 10, 2000
              377 Posts
              Offline
              Posted: July 1, 2008, 9:25 am - IP Logged

              OK thanks to all that answed-----

              If I can see an example than thats when it sticks in my mind----

              Anyway thanks

              Bob in Michigan