Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: Z.TEST function

Z.TEST function: Description, Usage, Syntax, Examples and Explanation

 What is Z.TEST function in Excel? Z.TEST  is one of Statistical functions in Microsoft Excel that returns the one-tailed P-value of a z-test.Go to the explanation section below to see how Z.TEST can be used in a formula to compute a two-tailed probability value. For a given hypothesized population mean, x, Z.TEST returns the probability that the sample mean would be greater than the…