Search

EXCEL Qre: FREQUENCY and COUNT functions...
I want to take an array of random numbers, say 30 x 30 rows/columns, and find frequency/count/reoccurrence of each number in the array. Not sure how to setup/apply the formulae functions. Excel has COUNT and FREQUENCY options, but I haven t been able, capable of avoiding errors. HELP is not much help and the 3 Disc Video Professor tutorials that came w/ the application don t cut-it. I m working on an idea promise to share results on LP, if worthy. Advice, anyone?
Aug 4, 2008, 12:50 pm - CurtisC - Mathematics Forum

Using Excel Predictive Tools to help with lotto picks
How many people use MS Excel statistical spreadsheets to help with choosing lotto numbers? If so, do you find it easy or hard? What do you use the most, frequency, sums, odd/even/high/low, decades, groups, skips, correlations, and/or individual numbers? Does anyone use trailing averages, slopes, ranks, differences or trend lines to assist in evaluating what numbers to play?
May 7, 2017, 10:34 am - AlanHarvey - Mathematics Forum

Excel Formula
I need help with an Excel formula to sort through data to find sequencial numbers e.g. 1-2 or 3-4 etc. I tried using a FREQUENCY formula but only got results for the 2 individual numbers where I need results where both numbers are included in a row.
Oct 29, 2012, 12:12 pm - buc2012 - Mathematics Forum

Help find Best frequency for a 3 digit number
excel pro's-- and All--- How does one find the Frequecy of 3 digit numbers??? Is there different frequencys to a group of numbers?? Like how many times a number hits? What do you divide it by? Hits/by number of draws??? Trying to find out which one is the BEST to go by in EXCEL 2007-----??? What is the Best FORMULA to use in EXCEL to get the frequency??? We searched here on LP butt did not find what we wanted... I think maybe a good one is How manytimes a number hits d
Feb 11, 2010, 8:38 am - Bob - Mathematics Forum

Excel Help Needed
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----
Jun 30, 2008, 7:38 am - Bob - Mathematics Forum

Power Mega Balls with Three Sum MathReply
1) I understand about sums and how concept works from reading some of your first posts. So by looking at excel threesums I understand to put in 2 last draws, Mega Millions for example, then number of selections. What exactly this number represent? Is it number of drawings? So what number better to put in there? The number of selections is the number of simulations for the next draw for each column beneath the two last drawings and is based on the three sum distribution. If you want to see
Feb 28, 2016, 11:09 am - JADELottery - Mathematics Forum

Help with Prediction NeededReply
Hey martor. There is a wealth of information online about XmR charts or Individual moving range charts. It basically means you are charting data that has one source, (for instance daily sales, or in your case, daily frequency of an event and NOT an average recording, such as the average temperature today). It's a great method because it not only tracks the individual readings but also the movement between readings. Which is what can help to show patterns. If all the numbers plot within the limit
Jul 31, 2012, 12:43 am - AlgorithmGuru - Mathematics Forum

Suggestions for Access queries?Reply
No, it is just frequency of couples, like I wrote above. I continued on my website and updated tables. See https://emuis.be/euromillions for Euromillions. There is no pick 3. If you feel the vocation to do input, then I do the charts. It does not make much sense for me to post charts here, while I can update charts automatically with done input. I hope that you understand that. Also I don't want to loose time with number input instead of keeping busy organizing site and programs, also continue s
Feb 18, 2015, 1:01 pm - SergeM - Mathematics Forum

What Excel version are you using?Reply
What we've found is that oscillating random data can have multiple waves. The Wave Matrix is like a frequency filter that can, in general, find a close match to the waves in the oscillating data. If you Sum the Linear Regression, Waves and the Remainder in a single line, you'll see the Sum of those equals the original data. Example, in line 10 of our previous Wave Matrix of Column C, you can see that if each of the components in the Wave Matrix are Summed we get the original data. Be
Oct 2, 2012, 6:54 pm - JADELottery - Mathematics Forum

Power Mega Balls with Three Sum MathReply
My fault for not checking further. These files already have the new CombNexus and DisimulateNexus functions. http://www.jadexcode.com/files/excel/threesums-02.xlsm or ftp://www.jadexcode.com/excel/threesums-02.xlsm However, we need to change the Powerball Unbounded CombNexus usage from CombNexus(59, 5, C, N0, N1) to CombNexus(69, 5, C, N0, N1) and CombNexus(35, 1, C, N0, N1) to CombNexus(26, 1, C, N0, N1) then remake the frequency chart.
Jan 8, 2016, 2:32 pm - JADELottery - Mathematics Forum