Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10,124
Default How to calculate frequency of lottery numbers?

http://www.txlottery.org/export/site...Frequency.html
19 49
17 48
7 47
31 45
26 43
8 42
10 42
12 42
23 42
35 42
36 42
43 42
16 41
28 41
42 40
47 40

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message news:...
I once played the Texas lotto and kept a log of winning numbers. Probably
best to use a macro to record as each game is played. However, my file
showed me that playing the lotto was not a winning proposition so I QUIT.
However, if desired, send your file to my address below and I'll take a
look.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Xray_Man" wrote in message
...
I'm new to Excel, so please explain things to this newbie in
non-technical
terms as much as possible! I have downloaded the array of previous week's
winning lottery numbers, and I want Excel to create a number frequency
chart
for me. The numbers are 1 to 59. I want to calculate a histogram of the
frequencies of each number from 1 to 59. So far, I set up Excel so that
the
results of the previous lottery games are in 5 collumns.
A1:A100,B1:B100,C1:C100,D1:D100,E1:E100. I then entered the numbers 1
through
59 into K1:K59. I tried to use the Frequency function, which sort of
seems to
calculate the frequencies as expected, but I don't know where to find the
resulting array of frequencies. I hope what I just said didn't sound too
silly, but my problem is that I don't know how to complete the job so
that I
can some how view the array of frequencies in some easy to view form,
such as
a histogram. Any help would be most appreciated (and I hope it makes me
rich!! LOL)



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to calculate frequency of lottery numbers? Xray_Man New Users to Excel 24 April 3rd 23 02:10 PM
Bingo Lottery Winning Numbers Nomis-MCSE Excel Discussion (Misc queries) 1 January 13th 06 08:21 PM
How do I generate random lottery numbers in Excel? Mark1809 Excel Worksheet Functions 7 July 31st 05 07:23 PM
Checking Winning Numbers in the Lottery. Ann Excel Discussion (Misc queries) 4 May 18th 05 10:55 AM
complex validation for lottery numbers [email protected] Excel Discussion (Misc queries) 2 February 9th 05 04:15 PM


All times are GMT +1. The time now is 10:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"