Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical > ZTEST
 

ZTEST(array, x, sigma)

 
 Returns the two-tailed P-value of a z-test

 arraythe array or range of data against which to test x.
 xthe value to test.
 sigmathe population (known) standard deviation

 REMARKS
 
  		• If array is empty, then #N/A is returned.
     
  		• The z-test generates a standard score for x with respect to the data set, array, and returns the two-tailed probability for the normal distribution. You can use this function to assess the likelihood that a particular observation is drawn from a particular population.

     EXAMPLES
     
     A
    1=ZTEST({3,6,7,8,6,5,4,2,1,9},4) = 0.091
    2=ZTEST({2,4,6,8,10},3) = 0.017
    		 
     Functions - Z | Index - Z | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top