Studentized Range q Table

The following tables provide the critical values for q(k, df, α) when α = .10, .05, .025, 01, .005 and .= 001. See Unplanned Comparisons for ANOVA for more details.

Alpha 0.10

Studentized q .10 (1)Studentized q .10 (2)

Studentized q .10 (3)

Alpha = 0.05

Studentized q .05 (1)

Studentized q .05 (2)Studentized q .05 (3)

Alpha = 0.025

Studentized q .025 (1)Studentized q .025 (2)

Alpha = 0.01

Studentized q .01 (1)

Studentized q .01 (2)Studentized q .01 (3)

Alpha = 0.005

Studentized q .005 (1)Studentized q .005 (2)

Alpha = 0.001

Studentized q .001 (1)Studentized q .001 (2)

Download Table

Click here to download the Excel workbook with the above table.

References

Elvers, G. (2020) Critical values of the Studentized Range (q)
http://elvers.us/stats/tables/qprobability.html

Harter, H. L. (1960) Tables of Range and Studentized Range. Ann. Math. Statist. 31 (4) 1122 – 1147
https://projecteuclid.org/journals/annals-of-mathematical-statistics/volume-31/issue-4/Tables-of-Range-and-Studentized-Range/10.1214/aoms/1177705684.full

Zhang, L. (2018) Studentized Range distribution table. Purdue University course
https://www.stat.purdue.edu/~lingsong/teaching/2018fall/q-table.pdf

Howell, D. C. (2010) Statistical methods for psychology (7th ed.). Wadsworth, Cengage Learning.
https://labs.la.utexas.edu/gilden/files/2016/05/Statistics-Text.pdf

63 thoughts on “Studentized Range q Table”

  1. Hello Charles,
    I downloaded your Excel file with the Studentized range tables to compare against mine (I did not install the add-in). I noticed a few discrepancies in the sheet “Stud. Q Table 2”, top table with alpha=0.01: For k=3, df=19, the table shows 1.670 when it should be 4.670. Also, for k=13, df=14,…,30, the table shows 5.xxx when it should show 6.xxx. The same values ARE correct in the last table of the sheet “Stud. Q Table 1” also for alpha=0.01.

    Reply

    • Hello Amanda,
      Thanks for catching this error.
      I have now made the corrections on the attached table.
      Fortunately, the values reported by the Real Statistics software were correct.
      I really appreciate your help in improving the accuracy of the website.
      Charles

      Reply

  2. Hi there Charles,

    I have the XRealStats-Mac package downloaded and have ticked the solver and XRealStats add-in on my current excel workbook but the QDIST and QCRIT functions don’t seem to be there ? any workarounds at all ?

    thank you !

    Reply

  3. use of Sig. 0.05, 0.025, 0.001 based on what? based on need or up to us?
    I’m still confused why the app by default uses 0.05
    Please help me

    Reply

    • In some sense, these values are arbitrary, especially the default of alpha = .05. Probably .05 was chosen since it means that a wrong outcome occurs 1 time out of 20, and this was viewed as acceptable.
      Charles

      Reply

  5. Dear Charles,

    I am enjoying and learning a lot from your website. From this table, it is clear to me that the q statistic is related to t statistic in that q=t*squared root of 2. However, it only applies for the first column (k=2). My question is whether there is a relationship between the t statistics and the other columns (k>2), so that we can use the t table instead if this table. Thank you in advance for your reply.

    Regards,

    Wilson Fandino

    Reply

  6. Hi,

    This is a great resource! Couple operational questions I had:

    1) Is there a form of this Studentized Q table somewhere in a copy-able grid or excel? I only found this one but the values are different: http://elvers.us/stats/tables/qprobability.html

    2) More important question :-). Is there a table anywhere where I can manually get the corresponding P VALUES calculated based on any given Qstat (without using the Qdist plugin)? How could i best go about this would that formula?

    Reply

    • Hi Thomas,
      1. The ANOVA 1 examples workbook contains the same Studentized Range q values that you see on this webpage, but in Excel format (and therefore copyable format).
      You say that the values are different from the ones in http://elvers.us/stats/tables/qprobability.html. The values on this webpage don’t include entries for 41-47, 49-59, 61-79 and 81-119. Can you give me one or two examples outside of these ranges where the values on the Real Statistics website and this found in the table that you referenced in your comment?
      2. I have not found a table with the p-values. Instead, for Real Statistics, these values are calculated via a program in the software. The results are returned by the QDIST function. You can use this function to create the table that you are looking for.
      Charles

      Charles

      Reply

  10. dear prof
    how to calculate the critical value of SSR(Duncan’s) distribution using the qinv fuction you supplied?
    thank u very much.

    Reply
  11. Pingback: Inferential Statistics (ANOVA) – Learning Machine Learning

  13. Hi Charles,
    Hi Charles,
    I’m sorry to insist so much on Tukey’s HSD, but I really want to understand.
    Does what you wrote mean that Tukey’s HSD is not set up to compare say the group with the second smallest mean with say the group with the third largest mean?
    The point is that after having made an analysis of variance, and found that there is, at least one significant difference among the means, it is essential to find out which of the various differences among the means may be statistically significant. One thing you know for sure (at a given level of confidence) and that is that there may be significance between the smallest and the largest mean…
    So what to do if you want to calculate the smallest difference that should exist between two significantly different means since Fishers LSD’s error rate becomes too high for more than three (I read) means?
    The answer to this question needs to show a fine balance between reliability and precision, I feel.
    Thank you once more for your precious time,
    Erik

    Reply

    • Hi Erik,
      Tukey’s HSD will identify a significant difference between any two groups, not just the smallest mean with the largest. The way it reduces experimentwise error is based on the difference between the largest and smallest means, but this is perhaps a detail that you may not find that important.
      Charles

      Reply

  14. Hi Charles,
    1. I found in my wine tastings Tukey’s HSD test being so severe that it often makes conclusions disappointing at 95% of confidence level. As I wrote to you I believe a one sided test is applicable since all differences between means are positive, would you aggree with that? I really am interested to know weather your tables refere to a one tailed test or not. If they were two sided one could use de 90% tables and have a confidence level of 95%
    2. Why do you not support Fisher’s LSD test? Is it because it uses the Residual Variance and a t-value while HSD uses the Within Wines Variance and a q-value? For my wine tastings it gave mostly plausible, say “believable” values. But is gut feeling of course.
    Thank you sincerely for answer,
    Erik

    Reply

    • Hi Erik,
      1. As I just wrote to you, I believe that Tukey’s HSD is a two tailed test.
      2. I don’t support Fisher’s LSD since it doesn’t handle experimentwise error rate very well. Tukey’s HSD is much better at this.
      Charles

      Reply

  15. hello. may i ask?. How can be the q critical value be computed without depending on the Duncan’s distribution table? Is there an existing formula that can be used? what is it? thanks for your response 🙂

    Reply

  16. Hi Charles,
    I have been trying to come to a better understanding of Tukey’s HSD and wonder if you can aggree with what I wrote hereunder:
    Given a panel of n judges scoring each of k wines means X1, …, Xi, … Xk were found.
    After sorting those means from largest to smallest, the test hypotheses for the k(k-1)/2 differences are:
    Ho: mu-i minus mu-j = 0
    H1: mu-i minus mu-j larger than 0, and not “different from zero” like I found on some sites.
    So reject Ho if Xi – Xj >= q-alpha*S-w/square root n, seems to me being a one-sided test. Is this correct ? Is your table 3 made up in that sense ?
    Thank you very much, this is a brillant site,
    Erik

    Reply

    • Erik,
      I am very please that you like the site and I appreciate your calling it “brilliant”.
      I believe that Tukey’s HSD is a two-tailed test and not a one-tailed test.
      The reason for the sorting that you refer to is that the test is essentially set up to compare the group with the smallest mean with the group with the largest mean.
      Charles

      Reply

  17. good day. i have this little question. How can be the q critical value be computed without depending on the tukey’s distribution table? Is there an existing formula that can be used? what is it? thanks for your response 🙂

    Reply

  18. How can i get the critical value if my df=42 and n=3, with alpha=0.05? I can see 40 and 60 but I don’t know how I can get the exact value for that? What is my critical value then? Thanks!

    Reply

    • Iris,

      I can offer you two choices:

      (1) interpolate the values in the table between the values for 40 and 60. Since 42 is a lot closer to 40 than 60, the appropriate value should be closer to the value in the table for 40.

      (2) Install the Real Statistics Resource Pack. You can then use either the QCRIT or QINV function. QCRIT will do the interpolation for you and QINV will directly calculate an estimated value for df = 42.

      Charles

      Reply

  19. Are these tables also applicable to games-howell post hoc tests?
    Currently my df values are below 4 and a similar table I found only went to 5 as a minimum, which proved hard finding the correct Q value.
    If so, when choosing the the Q value for example if the df was 4.65, would 4 or 5 on the table be most accurate?
    I understand with games howell, you must first calculate the df, between each pair, followed by the qcrit value for each pair, before using in the final equation (see link): http://www.unt.edu/rss/class/Jon/ISSS_SC/Module009/isss_m91_onewayanova/img138.png to get the minimum significant difference.

    Can someone please confirm if this equation is correct?

    I followed the guidelines from this website: http://www.unt.edu/rss/class/Jon/ISSS_SC/Module009/isss_m91_onewayanova/node7.html

    However in the final calculation of minimum significant difference for games howell, (down the bottom of the webpage) I noticed in place of their qcrit, they used the calculated df value instead, despite in the formula saying q crit. I wonder if this is a mistake, or if this is what one is meant to do.

    Any guidance would be greatly appreciated and if anyone has a better calculations example for games-howell please share.

    Warm regards, Jess

    Reply

    • Jess,
      Yes, these tables are applicable to Games-Howell. If your df is between 4 and 5 you can interpolate between the values in the table.
      Sorry but I haven’t had time to look at the references you provided regarding your other questions.
      Charles

      Reply

      • Dear Charles,
        Thank you kindly for that!
        I have since downloaded the program onto my mac and have attempted to use QCRIT formula, however every time I type the function with the values, separated by commas, it shows up as #NAME and says ‘compile error in module: look up’.
        Any guidance please?

        Reply

        • Jess,
          I have just checked on my Windows.based computer and the QCRIT function works fine. I can’t think of any reason why it wouldn’t work on the Mac, but
          unfortunately, since I don’t own a Mac I can’t test the QCRIT on the Mac until the next time I borrow a Mac from a friend. In any case, you can try to use the QINV function which estimates the value of the inverse Studentized Range value without doing a table lookup.
          Charles

          Reply

  20. Thank you for your service! I am interested to known about ANOVA post-hoc Q test. Is it possible to run this test for more than 20 treatments (groups)? Where do I get a Q table that provides values for a>20? Can I calculate table Q value? How? Is there an “infinite a” Q value? Will you please help me?

    Reply

    • Gurumani,
      The Real Statistics Resource Pack provides the function QINV(p, k, df, tails) which calculates the table value for any value of k (= # of groups), even for k > 20. The values of Q for infinite df are given in the table on the referenced webpage. You can download the Real Statistics Resource Pack for free from the website.
      Charles

      Reply

    • Sarah,

      You would need to interpolate between the table values for df = 120 and df = 240. Q-crit for df = 120 is 3.685 and the Q-crit for df = 240 id 3.659. A linear interpolation would give the value 3.6772, which can be calculated using the Real Statistics formula =QCRIT(4,156,0.05,2).

      The Real Statistics formula =QINV(0.05,4,156,2), which does not use the table, will usually give a more accurate answer, which in this case is 3.6726.

      Charles

      Reply

  27. Can anyone please tell me what the Q statistic is for alpha 0.05, df 75 and k 23? I have not found it in any reference table.

    Reply

  28. hello
    Can you please tell me what the Q statistic is for two way anova (25×2), alpha 0.05, and df 200 ? Thx 😀

    Reply

Leave a Comment