Welcome Guest
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
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----

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

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

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.

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

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!

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

 Page 1 of 1