Difference between revisions of "Manuals/calci/ZTEST"

From ZCubes Wiki
Jump to navigation Jump to search
Line 22: Line 22:
 
     2. ar or x is empty.
 
     2. ar or x is empty.
 
     3. ar contains only one value.
 
     3. ar contains only one value.
 +
 +
==Examples==
 +
#'''Example 1'''
 +
{| class="wikitable"
 +
|+Spreadsheet
 +
|-
 +
! !! A !! B !! C !! D !! E !! F !! G
 +
|-
 +
! 1
 +
| 10 || 15 || 7 || 2 || 19 || 20 || 12
 +
|-
 +
! 2
 +
| 3 || 4 || 8 || 1 || 10 || 15
 +
|}
 +
1.ZTEST(A1:G1,4) = 0.00042944272036
 +
2.2*MIN(ZTEST(A1:G1,4),1-ZTEST(A1:G1,4)) = 0.000858885440
 +
3.ZTEST(A2:F2,10) = 0.9323691845
 +
4.2*MIN(ZTEST(A2:F2,10),1-ZTEST(A2:F2,10)) = 0.135261630850
 +
 +
 +
==See Also==
 +
*[[Manuals/calci/NORMDIST  | NORMDIST ]]
 +
*[[Manuals/calci/NORMINV  | NORMINV ]]
 +
*[[Manuals/calci/NORMSDIST  | NORMSDIST ]]
 +
*[[Manuals/calci/NORMSINV  | NORMSINV ]]
 +
*[[Manuals/calci/STANDARDIZE  | STANDARDIZE ]]
 +
 +
 +
==References==

Revision as of 00:15, 10 February 2014

ZTEST(ar,x,sigma)


  • is the array of values.
  • is the value to test.
  • is the standard deviation of the population.


Description

  • This function gives the one-tailed probability of z-test.
  • Z-test is used to determine whether two population means are different when the variances are known and the sample size is large.
  • In , is the array of values against which the hypothesized sample mean is to be tested.
  • is the hypothesized sample mean, and is the standard deviation of the population.
  • When we are not giving the sigma value, it will use the standard deviation of sample.
  • 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.
  • ZTEST is calculated when sigma is not omitted and x=μ0 : Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ZTEST(ar,\mu_0,sigma)=1-NORMSDIST((\bar{x}-μ0)/\frac{sigma}{\sqrt{n}})} .
  • ZTEST is calculated when sigma is omitted and x=μ0:

Failed to parse (syntax error): {\displaystyle ZTEST(ar,μ0)=1-NORMSDIST((\bar{x}-μ0)/\frac{s}{\sqrt{n}})} where is sample mean , is the sample deviation and 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: .
  • This function will give the result as error when
    1. Any one of the argument is non-numeric.
    2. ar or x is empty.
    3. ar contains only one value.

Examples

  1. Example 1
Spreadsheet
A B C D E F G
1 10 15 7 2 19 20 12
2 3 4 8 1 10 15

1.ZTEST(A1:G1,4) = 0.00042944272036 2.2*MIN(ZTEST(A1:G1,4),1-ZTEST(A1:G1,4)) = 0.000858885440 3.ZTEST(A2:F2,10) = 0.9323691845 4.2*MIN(ZTEST(A2:F2,10),1-ZTEST(A2:F2,10)) = 0.135261630850


See Also


References