That strategy isn't going to work Aha The cumulative probabilities have been tabled for the \(N(0,1)\) distribution.
Aw, geez, there'd have to be an infinite number of normal probability tables. In probability theory and statistics, the cumulative distribution function ( CDF) of a real-valued random variable X. So, all we need to do is find a normal probability table for a normal distribution with mean \(\mu100\) and standard deviation \(\sigma16\). JSTOR ( March 2010) ( Learn how and when to remove this template message)Ĭumulative distribution function for the exponential distribution Cumulative distribution function for the normal distribution.Unsourced material may be challenged and removed.įind sources: 'Cumulative distribution function' – news For example, NORM.DIST (5,3,2,TRUE) returns the output 0.841 which corresponds to the area to the left of 5 under the bell-shaped curve described by a mean of 3 and a standard deviation of 2. The value for which you want the distribution. NORM.DIST(x,mean,standarddev,cumulative) The NORM.DIST function syntax has the following arguments: X Required. This function has a very wide range of applications in statistics, including hypothesis testing. Please help improve this article by adding citations to reliable sources. The NORM.DIST function returns values for the normal probability density function (PDF) and the normal cumulative distribution function (CDF). Returns the normal distribution for the specified mean and standard deviation. This article needs additional citations for verification.