Is there a way to find if there relationship of numbers

46 Views Asked by At

I have a challenge. This may be little tricky or even not possible but wanted to check if anyone has any thoughts on this?

PS : This question is in general and not related to only to R. May be I can say its general mathematics

I have a data

df
ColA    ColB    ColC
 6       9       27
 1       4       32
 4       8       40

If you observe closely, there is some relationship between these columns.

Example, (ColC/ColB)+ColA will give you number 9.

df
ColA    ColB    ColC   ColD
 6       9       27     9
 1       4       32     9
 4       8       40     9

However this data is manipulated and I made sure there is some relation. But in general, lets us take any numbers, is there a way to find if there is any relationship between these numbers. Need not be (ColC/ColB)+ColA . It could be anything.

Say we have 5 columns of numeric data. I need to find mathematical operation between these so that common number exists.

Can anyone help

This is more into mathematics(algebra). Can anyone let me know is this even possible ?