LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 293
Default 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?



 
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 Unknown number sierra spiegel Excel Worksheet Functions 1 November 14th 09 01:11 AM
FINDING THE UNKNOWN NUMBER sierra spiegel Excel Worksheet Functions 3 November 13th 09 11:33 PM
Finding a string of unknown length in a string of unknown length, Help! Hankjam[_2_] Excel Discussion (Misc queries) 8 July 3rd 08 06:49 PM
finding unknown from a line of best fit Sara Beaver Charts and Charting in Excel 2 October 22nd 05 02:32 PM
Dividing by unknown to get a number bundyloco Excel Worksheet Functions 5 August 14th 05 03:44 PM


All times are GMT +1. The time now is 11:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"