How to Calculate Tukey's HSD with Excel

This video demonstrates how to calculate the Honestly Significant Differences for pairwise comparisons of means that have been shown through an analysis of variance to be significantly different. It does so by applying the HSD formula to the one factor ANOVA results that are calculated with Excel's stat pack. This formula uses the studentized range statistic which can be found from a table. Here is one good table. www.real-statis...

[@jaezarobertson8279]

THANK YOU SO MUCH!!! NEVER STOP MAKING VIDEO!! STEM GIRL

[@antoniosantoru2993]

In other sources I found that the "q" value, q(k, df, α), refers to the number of treatments "k" (in this case 3) and degrees of freedom "df" (observations - k, in this case 30 - 3 = 27). If this is correct, q(3, 27, 0.05)= 3.506 should be used in this example, not q(2, 27, 0.05) = 2.902.

[@user-ez2ih3pq5e]

I got the same idea. So I was confused with the number of 2.902.

[@jordanb.yonque2672]

that was quick and easy, thanks .

[@austiniturbe4495]

Thank you for the video, this helped for my Kinesiology lab

[@deltami2562]

I would like to know your opinion if the MS within groups either greater than MS between groups. Thank you.

[@zarashine2543]

Thank you so much.I have a question if q cannot be calculated from the table .. my value for df between groups is 6.0 and within group is 434.0 . In this case, how could I calculate HSD? Thanking you a lot..

[@moose23rizla]

you have to get the biggest one which in your case its infinite