Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
sorry, I miss typed the number. The numbers are as follow:
0 -11 -2 0 17 -9 -5 9 4 -12 2 11 23 -29 -10 11 -8 0 1 8 -11 -1 8 -3 1 sierra spiegel wrote: Random -Median, finding the next number 13-Nov-09 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. Previous Posts In This Thread: EggHeadCafe - Software Developer Portal of Choice ASP.NET Digest Authentication Against Database http://www.eggheadcafe.com/tutorials...uthentica.aspx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding Median Age | Excel Discussion (Misc queries) | |||
Finding the Median | New Users to Excel | |||
finding the median from a list of unsorted numbers | Excel Discussion (Misc queries) | |||
Finding the median of numbers meeting criteria | Excel Discussion (Misc queries) | |||
Finding Median if a value = 1.. help! | Excel Worksheet Functions |