writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 16:
Line 16: − +
→Description
*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>
where <math>bar{x}</math> is sample mean , <math> s</math> is the sample deviation and <math>n</math> is the size of the sample.
where <math>\bar{x}</math> is sample mean , <math> s</math> is the sample deviation and <math>n</math> is the size of the sample.
*Suppose we want to calculate the z-test for two tailed probability then this can be done by using the Z.Test function: <math>2*MIN(ZTEST(ar,\mu_0,sigma),1-ZTEST(ar,\mu_0,sigma))</math>.
*Suppose we want to calculate the z-test for two tailed probability then this can be done by using the Z.Test function: <math>2*MIN(ZTEST(ar,\mu_0,sigma),1-ZTEST(ar,\mu_0,sigma))</math>.
*This function will give the result as error when
*This function will give the result as error when