The distribution has a mean of zero and a standard deviation of one. Use this function in place of a table of standard normal curve areas. Z is the value for which you want the distribution. Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.
Probability is a probability corresponding to the normal distribution.
Returns the Pearson product moment correlation coefficient, r, a dimensionless index that ranges from -1.0 to 1.0 inclusive, and reflects the extent of a linear relationship between two data sets. Array1 is an array or range of independent values. Array2 is an array or range of dependent values. Returns the value from array at the k-th percentile. You can use this function to establish a threshold of acceptance.