- #1
cps.13
- 40
- 1
Hi,
Please note: this is not a homework question! It is a real world problem I am trying to solve.
I have some values in mA and tonnes which I need to extrapolate but they are not linear. I know it the mA curve drops off the higher the tonne values go.
I have plotted the values in excel
mA tonne
7.63 42
10.83 84
13.86 126
15.17 147
unknown 210
I have got a logarithmic trend line which is -5.9517ln(x) - 14.903 but I am not 100% sure this is correct?
I then did =(-5.9517*LN(210))-14.903 to get my 210 value but this comes out with a high negative value!
I need to find my predicted mA value at 210tonne.
Can anyone help?
Thanks
Please note: this is not a homework question! It is a real world problem I am trying to solve.
I have some values in mA and tonnes which I need to extrapolate but they are not linear. I know it the mA curve drops off the higher the tonne values go.
I have plotted the values in excel
mA tonne
7.63 42
10.83 84
13.86 126
15.17 147
unknown 210
I have got a logarithmic trend line which is -5.9517ln(x) - 14.903 but I am not 100% sure this is correct?
I then did =(-5.9517*LN(210))-14.903 to get my 210 value but this comes out with a high negative value!
I need to find my predicted mA value at 210tonne.
Can anyone help?
Thanks