Re: Geo average

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Harlan Grove (hrlngrv_at_aol.com)
Date: 01/18/05


Date: 18 Jan 2005 14:56:30 -0800

Myrna Larson wrote...
>Thanks for the insights. It's a function I haven't used enough to hit
the
>bugs.

If you want to model individual's annual incomes with a lognormal
distribution and you have a sample of 100 individuals' incomes in whole
US$s, you'll hit this bug (100 * ~5E4 -> ~5E400 >> Excel's FP max).


Quantcast