Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 18
Default Random -Median, finding the next number

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
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
Finding Median Age BStacy Excel Discussion (Misc queries) 5 April 10th 09 06:22 PM
Finding the Median Bad_Shot New Users to Excel 7 January 7th 09 07:48 PM
finding the median from a list of unsorted numbers Christopher Buxton Excel Discussion (Misc queries) 2 March 21st 07 12:53 PM
Finding the median of numbers meeting criteria thekovinc Excel Discussion (Misc queries) 3 February 7th 06 12:45 AM
Finding Median if a value = 1.. help! Greg Excel Worksheet Functions 2 February 13th 05 03:28 AM


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

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"