What would the equivalent of NORM.DIST be?

[brandonros]

https://support.microsoft.com/en-us/office/norm-dist-function-edb1cc14-a21c-4e53-839d-8082074c9f8d

NORM.DIST(x,mean,standard_dev,cumulative)

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.

The NORM.DIST function syntax has the following arguments:

X     Required. The value for which you want the distribution.

Mean     Required. The arithmetic mean of the distribution.

Standard_dev     Required. The standard deviation of the distribution.

Cumulative     Required. A logical value that determines the form of the function. If cumulative is TRUE, NORM.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.

[dsaxton]

@brandonros If it's the cumulative version you're interested in you can use ss.cumulativeStdNormalProbability, but instead of plugging in x directly use (x - mean) / standard_dev. For the density function I'm not finding anything in simple-statistics (@tmcw please correct me if I'm wrong here) but you could always use the formula: https://en.wikipedia.org/wiki/Normal_distribution

[shrddr]

Density function missing is quite unexpected for me

[tmcw]

That's true, there's no equivalent of NORM.DIST in simple-statistics at the moment. I'd welcome such a PR, and it looks like there are some examples in JavaScript, like https://github.com/RichieAHB/normal-distribution