Hello,
I appreciate any clue to something that I can not understand (attached a file).
In the file, there is a column called VALUE with different values.
The LN column is a LN function for the values in VALUE.
To verify that LN is true, I checked it with the EXP function that presented in EXP column.
Now I took an average.
I found that the average of the VALUE column is 2975548 and the average of the LN column is (14.865).
But when I use the EXP function to the number 14.865, I found it is:
EXP (14.865) = 2857671
My question is why is there no match, why there is a difference between 2857671 and 2975548?
I hope I was clear with my question?
Thank you
I appreciate any clue to something that I can not understand (attached a file).
In the file, there is a column called VALUE with different values.
The LN column is a LN function for the values in VALUE.
To verify that LN is true, I checked it with the EXP function that presented in EXP column.
Now I took an average.
I found that the average of the VALUE column is 2975548 and the average of the LN column is (14.865).
But when I use the EXP function to the number 14.865, I found it is:
EXP (14.865) = 2857671
My question is why is there no match, why there is a difference between 2857671 and 2975548?
I hope I was clear with my question?
Thank you