Hi Everyone, Hope this email finds you well - roll on the weekend!
I've been tasked with replicating an Excel spreadsheet in VFP 9 SP2. The spreadsheet contains cells that use Excels' NORMDIST() function. I have all 3 variables required - value, mean and standard deviation - but does anyone already have equivalent VFP code? Many thanks! Cheers, Garry PS: Excel Help: NORMDIST Returns the normal distribution for the specified mean and standard deviation. This function has a very wide range of applications in statistics, including hypothesis testing. Syntax NORMDIST(x,mean,standard_dev,cumulative) X is the value for which you want the distribution. Mean is the arithmetic mean of the distribution. Standard_dev is the standard deviation of the distribution. Cumulative is a logical value that determines the form of the function. If cumulative is TRUE, NORMDIST returns the cumulative distribution function; if FALSE, it returns the probability mass function. Remarks If mean or standard_dev is nonnumeric, NORMDIST returns the #VALUE! error value. If standard_dev ≤ 0, NORMDIST returns the #NUM! error value. If mean = 0, standard_dev = 1, and cumulative = TRUE, NORMDIST returns the standard normal distribution, NORMSDIST. When cumulative = TRUE, the formula is the integral from negative infinity to x of the given formula. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
