Excel Function : Z.TEST

Download now!

Excel Function : Z.TEST

Category

Statistical

Description

Returns the one-tailed probability-value of a z-test

Microsoft Excel Reference Page

https://support.office.com/en-us/article/ZTEST-function-d633d5a3-2031-4614-a016-92180ad82bee

Syntax and Description of the Z.TEST Excel Function

syntax Z.TEST(value, values, [percent]) syntax error Z.TEST(TRANSPOSE(A1:A6), TRANSPOSE(A11:A16), [percent]) syntax error Z.TEST(TRANSPOSE(A1:A6), TRANSPOSE(A11:A16)) Note that you can use the TRANSPOSE function to rotate a vertical array to a horizontal array, or vice versa. This technique is useful when your data is arranged in a column or row, and you need to rotate it to the other orientation. Customizing the percentages By default, the Z.TEST function displays the percentage of values that are greater than

About Z.TEST Excel Function

The Z.TEST function returns the one-tailed probability-value of a z-test.