Excel Help Needed

Reply #6

Bob — Tue, 01 Jul 2008 13:25:03 GMT

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

Reply #5

Raven62 — Mon, 30 Jun 2008 18:23:39 GMT

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).

Reply #4

Bob — Mon, 30 Jun 2008 16:58:40 GMT

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

Reply #3

time*treat — Mon, 30 Jun 2008 13:22:00 GMT

times a number hit / total hits

0/45 = 0

Reply #2

Bob — Mon, 30 Jun 2008 13:11:41 GMT

#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

Reply #1

CARBOB — Mon, 30 Jun 2008 12:42:11 GMT

Divde number of draws by number of hits= avg

example

45/3=15

Excel Help Needed

Bob — Mon, 30 Jun 2008 11:38:04 GMT

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