Excel question about the ztest function

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • cutchemist42
    SBR Wise Guy
    • 04-08-12
    • 737

    #1
    Excel question about the ztest function
    Trying to make the Ztest formula work, and normally I know how to but not in this situation, it keeps giving me the #value sign. I'm trying to do a Ztest for a certain array of numbers that excludes some cells. For example.


    A1
    A2
    A3
    A4


    I am trying to do a ztest only on the values in A1, A2, and A4 while excluding A3. The Excel formula and how it works is not letting me exclude A3.


    Thanks for any help!
  • froment
    SBR Rookie
    • 04-26-11
    • 2

    #2
    When you select those two ranges holding Ctrl, formula becomes

    =ZTEST(A1:A2,A4 ...

    So Excel assumes coma (or semicolon, depending on your keyboard settings) separates arguments of the function, so it thinks A4 is x value rather than part of the range. So, try to enclose range in parenthesis:

    =ZTEST((A1:A2,A4),x)
    Comment
    SBR Contests
    Collapse
    Top-Rated US Sportsbooks
    Collapse
    Working...