Hi,

I am getting a #NUM! error for the slope calculation output of the LOGEST function. I am thinking this may be because I am using very small X values, but I am new to exponential regression so I am not sure. The LINEST function does not give any errors with the same numbers. I am modeling a distance decay function, so my independent variable is 1/d. All the other LOGEST outputs in the array are calculated with no errors...it's just the slope value that is problematic.

Here are some sample numbers if anyone can help. Thanks.


Y
2
8
2
1
188

X
3.886816E-06
2.605313E-06
3.238384E-06
3.536918E-06
5.642386E-06