Formulas and Functions
ଏହି କଣ୍ଟ‍୍ରୋଲ୍‌କୁ ପରିବର୍ତ୍ତନ କରିବା ଫଳରେ ଏହି ପୃଷ୍ଠା ସ୍ବୟଂଚାଳିତ ଭାବରେ ଅପ୍‌ଡେଟ୍ ହୋଇଯିବ

ZTEST

The ZTEST function returns the one-tailed probability value of the Z-test.

ZTEST(value-set, value, stdev)

value-set: A collection of number values, date/time values or duration values. All values must be of the same value type.

value: The value to test. value is a single number value, date/time value or duration value.

stdev: An optional number value for the standard deviation of the population. stdev must be greater than 0.

Notes

  • The Z-test is a statistical test that determines if the difference between a sample mean and the population mean is large enough to be statistically significant. The Z-test is used primarily with standardised testing.

  • If stdev is omitted, the assumed sample standard deviation is used.

Example

Suppose that cells B2 to G2 contain the values 57, 75, 66, 98, 92 and 80, respectively, and represent the value-set. The ZTEST value for this set, assuming a value to test (value) of 70 and a standard deviation (stdev) of 9, can be found with the formula:

=ZTEST(B2:G2, 70, 9)

The result is 0.0147281928162857.

See alsoSTANDARDIZE
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
ସହାୟକ କି?
କ‍୍ୟାରେକ୍ଟର୍ ସୀମା: 250
ସର୍ବାଧିକ କ‍୍ୟାରେକ୍ଟର୍ ସୀମା 250 ଅଟେ।
ଆପଣଙ୍କ ମତାମତ ପାଇଁ ଧନ‍୍ୟବାଦ।
Morty Proxy This is a proxified and sanitized view of the page, visit original site.