The location parameter is just an offset from 0, a shortcut for adding (X) to the result. So
=ExponentialValue( 10, 1 )
would be the same as
=ExponentialValue( 0, 1 ) + 10
The shape is the hard part. Have a look at some examples on wikipedia,
[
en.wikipedia.org]
If you know your data is exponential, you can use the mean. For the exponential distribution (with location 0) the mean is
1/shape
The way I would suggest approaching this would be (1) scale down the data; (2) once scaled, figure out the offset to zero, which is the location; and then use the mean of the resulting set to figure out the shape parameter.
Make sense?
Duncan Werner
dwerner@riskamp.com