Talk:Documentation/Calc Functions/Z.TEST

    From The Document Foundation Wiki

    SF comments

    (1) General. I think it is usual to use an uppercase Z in “Z-test”. By analogy, also in “Z-statistic”.
    (2) Summary. Seems to contain three explanations of what the function does! Please have a look at the following page and see if we can come up with a more coherent explanation - https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_ZTEST_function.
    (3) Returns. After actioning the above comment on the Summary, please review this statement and see if changes are required.
    (4) Arguments, general. I expect that there are other error conditions to consider. For example, what happens if cells in Data contain anything other than real numbers? What happens if Data contains no values or one value? What happens if mu or sigma are cell references, but the cells do not contain real numbers?
    (5) Additional details, first four lines. These look as if they may have been inappropriately copied from another website.
    (6) Additional details. Text states that you can relate Z.TEST to NORMSDIST and then relates it to NORM.S.DIST.
    (7) Additional details, text “With sample being the mean of Data and”. This text (from the ODF) seems redundant because we do not use a variable called “sample”.
    (8) Examples, general. Please review the Description entries once you have had a chance to re-word the Summary and Returns sections.
    (9) Examples, general. Would it be worth giving an example with an array of values? Also, would it be worth having some negative values in Data just in case any reader mistakenly infers that only positive values are allowed?
    (10) Related LibreOffice functions. Is there any reason why T.TEST and F.TEST are omitted?

    --Stevefanning (talk) 2020-11-09T16:00:59 (UTC)

    Ronnie

    all points addressed.

    --Ronnie rg8888 (talk) 2020-11-30T08:41:10 (UTC)