Changes

*This  function returns the probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values.

*This  function returns the probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values.

*The test statistic should follow a normal distribution.  

*The test statistic should follow a normal distribution.  

*ZTEST is calculated when sigma is not omitted and x=μ0 : <math>ZTEST(ar,\mu_0,sigma)=1-NORMSDIST((\bar{x}-μ0)/\frac{sigma}{\sqrt{n}})</math>.

*ZTEST is calculated when sigma is not omitted and x=μ0 : <math>ZTEST(ar,\mu_0,sigma)= 1-NORMDIST(\bar{x}-\mu_0)/\frac{sigma}{\sqrt{n}}</math>

*ZTEST is calculated when sigma is omitted and x=μ0:

*ZTEST is calculated when sigma is omitted and x=μ0:

<math> ZTEST(ar,μ0)=1-NORMSDIST((\bar{x}-μ0)/\frac{s}{\sqrt{n}})</math>

<math> ZTEST(ar,μ0)=1-NORMSDIST((\bar{x}-μ0)/\frac{s}{\sqrt{n}})</math>