Finding the unknown number

[sierra spiegel]

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/tutorial...8192-bfdf6fef6500/vbnet-event-managment-.aspx

 

[sierra spiegel]

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/tutorial...76c-04d43694333b/read-any-document-like-.aspx

 

[David Biddulph]

Past success does not guarantee future performance.

 

[Joe User]

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.

-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 -----

 

[Gary''s Student]

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

 

[Rick Rothstein]

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)


in message
news:[email protected]...

 

[macropod]

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]

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.

-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 -----