Finding the unknown number
 

I have a list of number:
-17 9 5 -9 -4 12 -2 -11 -23 29 10 -11 8 0 -1 -8 11 1 -8 3

The sum of those number +1 is the answer to the current number, but what is the future number. The total sum for the listed number is 6 + 1 = 7. Yes the current number is 7. But what is the new number? How do I create a formula do do that?



EggHeadCafe - Software Developer Portal of Choice
VB.NET Event Managment / Logging through Publisher / Subsriber Pattern
http://www.eggheadcafe.com/tutorials...anagment-.aspx

Finding the unknown number
 

Let me clarify:

The sum of all the number +1 = the current answer . How do I do it backward to get the next unknown.



sierra spiegel wrote:

Finding the unknown number
14-Nov-09

I have a list of number:
-17 9 5 -9 -4 12 -2 -11 -23 29 10 -11 8 0 -1 -8 11 1 -8 3

The sum of those number +1 is the answer to the current number, but what is the future number. The total sum for the listed number is 6 + 1 = 7. Yes the current number is 7. But what is the new number? How do I create a formula do do that?

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
Read any document (like .doc, .rtf , txt ) in ASP.Net , C#
http://www.eggheadcafe.com/tutorials...ent-like-.aspx

Finding the unknown number
 

Past success does not guarantee future performance.
--
David Biddulph

<sierra spiegel wrote in message
...
I have a list of number:
-17 9 5 -9 -4 12 -2 -11 -23 29 10 -11 8 0 -1 -8 11 1 -8 3

The sum of those number +1 is the answer to the current number, but what
is the future number. The total sum for the listed number is 6 + 1 = 7.
Yes the current number is 7. But what is the new number? How do I create a
formula do do that?



EggHeadCafe - Software Developer Portal of Choice
VB.NET Event Managment / Logging through Publisher / Subsriber Pattern
http://www.eggheadcafe.com/tutorials...anagment-.aspx

Finding the unknown number
 

"David Biddulph" <groups [at] biddulph.org.uk wrote:
Past success does not guarantee future performance.

"Guarantee"? Right: probably not.

But the past sequence might reflect a pattern that can be used to determine
the next numbers.

And if there is no discernible pattern, statistical analysis of the
historical sequence might be used to predict the next numbers, within some
degree of confidence.

I think that is the purpose of this assignment or test question.


<sierra spiegel wrote:
-17 9 5 -9 -4 12 -2 -11 -23 29 10 -11 8 0 -1 -8 11 1 -8 3
[....]
The sum of those number +1 is the answer to the
current [sequence ....]. The total sum for the
listed number is 6 + 1 = 7.

I don't think so. Mind the signs.


----- original message -----

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Past success does not guarantee future performance.
--
David Biddulph

<sierra spiegel wrote in message
...
I have a list of number:
-17 9 5 -9 -4 12 -2 -11 -23 29 10 -11 8 0 -1 -8 11 1 -8 3

The sum of those number +1 is the answer to the current number, but what
is the future number. The total sum for the listed number is 6 + 1 = 7.
Yes the current number is 7. But what is the new number? How do I create
a formula do do that?

Finding the unknown number
 

With your data in A1 thru T1, the formula:

=SUM(A1:T1)+1 will display -5

To include future, unknown, values in U1 thru IV1, change the formula to:

=SUM(A1:IV1)+1

--
Gary''s Student - gsnu200908


"sierra spiegel" wrote:

Let me clarify:

The sum of all the number +1 = the current answer . How do I do it backward to get the next unknown.



sierra spiegel wrote:

Finding the unknown number
14-Nov-09

I have a list of number:
-17 9 5 -9 -4 12 -2 -11 -23 29 10 -11 8 0 -1 -8 11 1 -8 3

The sum of those number +1 is the answer to the current number, but what is the future number. The total sum for the listed number is 6 + 1 = 7. Yes the current number is 7. But what is the new number? How do I create a formula do do that?

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
Read any document (like .doc, .rtf , txt ) in ASP.Net , C#
http://www.eggheadcafe.com/tutorials...ent-like-.aspx
.

Finding the unknown number
 

Just pointing out that your first few numbers (at least, I gave up checking
after your third number) do not follow the pattern you say these numbers
have... (-17+9)+1 is not 5, (-17+9+5)+1 is not -9, etc.

--
Rick (MVP - Excel)


"sierra spiegel" wrote in message
...
Let me clarify:

The sum of all the number +1 = the current answer . How do I do it
backward to get the next unknown.



sierra spiegel wrote:

Finding the unknown number
14-Nov-09

I have a list of number:
-17 9 5 -9 -4 12 -2 -11 -23 29 10 -11 8 0 -1 -8 11 1 -8 3

The sum of those number +1 is the answer to the current number, but what
is the future number. The total sum for the listed number is 6 + 1 = 7.
Yes the current number is 7. But what is the new number? How do I create a
formula do do that?

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
Read any document (like .doc, .rtf , txt ) in ASP.Net , C#
http://www.eggheadcafe.com/tutorials...ent-like-.aspx

Finding the unknown number
 

Hi Joe User,

The fundamental problem is that the number sequence does not match the formula the OP gave. Given that, it'd be a hopless exercise
trying to work out what any subsequent (or previous) number in the sequence should be.

--
Cheers
macropod
[Microsoft MVP - Word]


"Joe User" <joeu2004 wrote in message ...
"David Biddulph" <groups [at] biddulph.org.uk wrote:
Past success does not guarantee future performance.

"Guarantee"? Right: probably not.

But the past sequence might reflect a pattern that can be used to determine the next numbers.

And if there is no discernible pattern, statistical analysis of the historical sequence might be used to predict the next numbers,
within some degree of confidence.

I think that is the purpose of this assignment or test question.


<sierra spiegel wrote:
-17 9 5 -9 -4 12 -2 -11 -23 29 10 -11 8 0 -1 -8 11 1 -8 3
[....]
The sum of those number +1 is the answer to the
current [sequence ....]. The total sum for the
listed number is 6 + 1 = 7.

I don't think so. Mind the signs.


----- original message -----

"David Biddulph" <groups [at] biddulph.org.uk wrote in message ...
Past success does not guarantee future performance.
--
David Biddulph

<sierra spiegel wrote in message ...
I have a list of number:
-17 9 5 -9 -4 12 -2 -11 -23 29 10 -11 8 0 -1 -8 11 1 -8 3

The sum of those number +1 is the answer to the current number, but what is the future number. The total sum for the listed
number is 6 + 1 = 7. Yes the current number is 7. But what is the new number? How do I create a formula do do that?