View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sierra spiegel sierra spiegel is offline
external usenet poster
 
Posts: 18
Default Random -Median, finding the next number

I have a set of number and it goes like this:
0 11 2 0 -17 9 5 -9 -4 12 -2 -11 -23 29 10 -11 8 0 -1 -1 3 -1. These are only 25 of the total 80number. The order is from 0 to -1. There is a pattern to the number. I took 5, 10, 20 and 25 and saw a pattern, they seem to cancel out. I think whatever is the number left control the next number coming out. I did a median test and it shows as follows:

with 5 numbers: 0.00
with 10 numbers: 0.00
with 15 numbers: -0.5
with 25 numbers: 0
with 50 numbers: 0
with 80 numbers: 0

How do I create a formula to see what number will be next? I test 25 number and see if the 26th, 27th and so on match with the existing number. So nothing matches.

thank you very much.




EggHeadCafe - Software Developer Portal of Choice
PreEmptive Solutions Dotfuscator PE
http://www.eggheadcafe.com/tutorials...ions-dotf.aspx