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.
