An Easter Challange

[Ian Mac]

More of a challenge than for myself (in fact it's not for myself).

Can anyone think of a way to work out seemingly illogical differences in numbers.

The reason I ask and further clarification is that we all know that Celsius to Fahrenheit is ((Number*9)/5)+32 (well, if you didn't, you all do now)

If you had say a sample set of numbers C in ColumnA and F in ColumnB and you didn't know the logical reasons for the difference in them. Is possible to program Excel in such a way that it will return the most logical formula. Say return an equation in a disired cell

Anyone get that?

_________________
Share the wealth!!
Ian Mac
This message was edited by Ian Mac on 2002-03-28 11:16

 

[Joe Was]

On 2002-03-27 15:48, Anonymousity wrote:

On 2002-03-27 15:35, Joe Was wrote:
It may be an easier coding task given a table of C temp and corresponding F temps to convert one value to the other, without knowing the formula. Rather than code a solution that delivers the formula for the conversion. JSW

But then you would not know how to convert a temperature unless it were in the table.

The original question is find the formula from the data, so the presupposition is: we do not know the formula. (Did we miss the point?) JSW

 

[Ian Mac]

But then you would not know how to convert a temperature unless it were in the table.

The original question is find the formula from the data, so the presupposition is: we do not know the formula. (Did we miss the point?) JSW

Not at all, you are correct, my last post explains that I was looking at sequences that people have ALREADY applied a logical formula to, what was that formula?
My orginal post, expanded that idea a little too far I fear!