does not meet the assumptions of parametric tests<\/strong>, such as the t-test or ANOVA.<\/p>\n\n\n\nIn the example below, we will show how this test can be performed in Excel.<\/p>\n\n\n\n
Mood\u2019s Median Test in Excel<\/h2>\n\n\n\n For our example, we will use two separate data sets, that will be located in columns A and B<\/strong>. They will show the grades of students from class A and class B<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nNow we will take several steps for Mood\u2019s Median test.<\/p>\n\n\n\n
\nCalculate MEDIAN<\/strong><\/li>\n<\/ol>\n\n\n\nThe first thing that we need to do is to calculate the medians for both classes<\/strong>. We will insert the data in columns C and D<\/strong>. In cell C2<\/strong>, our formula will be:<\/p>\n\n\n\n=MEDIAN(A3:A12)<\/code><\/pre>\n\n\n\nAnd we will calculate the median for column B numbers in cell D2<\/strong>. This is what we will end up with:<\/p>\n\n\n\n <\/figure>\n\n\n\n\nCalculate Deviation<\/strong><\/li>\n<\/ol>\n\n\n\nFor the second step, we calculate the absolute difference between the two medians<\/strong> by using the following formula (located in cell E2<\/strong>):<\/p>\n\n\n\n=ABS(C2-D2)<\/code><\/pre>\n\n\n\nAnd will get number 5<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\n\nRank the data<\/strong><\/li>\n<\/ol>\n\n\n\nWe need to rank our data, and the best way to do so is by using RANK.EQ formula<\/strong>. We will list all of our data in column F<\/strong>, and then will insert the formula:<\/p>\n\n\n\n=RANK.EQ(F2,$F$2:$F$21)<\/code><\/pre>\n\n\n\nIn cell G2<\/strong>, and will drag this formula till the end of the list:<\/p>\n\n\n\n <\/figure>\n\n\n\n\nSum of Ranks<\/strong><\/li>\n<\/ol>\n\n\n\nFor the next thing, we need to sum ranks for both classes<\/strong>. As we are aware that the ranks for class A are located in range G2:G11<\/strong>, we will sum these cells and input them in cell H2<\/strong>. We will do the same thing for class B<\/strong>, and we will include the range G12:G21<\/strong>. The results will be 115 for class A<\/strong>, and 89 for class B<\/strong>, respectfully:<\/p>\n\n\n\n <\/figure>\n\n\n\n\nCalculating Test Statistics<\/strong><\/li>\n<\/ol>\n\n\n\nIn another cell, cell J2<\/strong>, we will calculate the test statistic using the following formula:<\/p>\n\n\n\n=((H2-I2)^2)\/(H2+I2)<\/code><\/pre>\n\n\n\nWhich will look at the sum of ranks for class A (cell H2)<\/strong>, and the sum of ranks for class B (cell I2)<\/strong>. The result that we will get will be 3.31<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\n\nCompare to Critical Value<\/strong><\/li>\n<\/ol>\n\n\n\nWe must look at the critical value from a Chi-Squre distribution table<\/strong> with 1 degree of freedom<\/strong> and your chosen significance level (for example, 0.05)<\/strong>. The critical importance might be around 3.841<\/strong>.<\/p>\n\n\n\n\nInterpretation of Results<\/strong><\/li>\n<\/ol>\n\n\n\nThe result obtained from the Mood’s Median Test helps us determine whether there is a statistically significant difference between the medians of the two groups. In our case, the groups are Class A and Class B, and we are comparing their student grades. Here’s what the result could indicate based on the test statistic and the critical value:<\/p>\n\n\n\n
\nNull Hypothesis (H0):<\/strong> There is no significant difference<\/strong> between the medians of the two groups (Class A and Class B).<\/li>\n\n\n\nAlternative Hypothesis (H1):<\/strong> There is a significant difference<\/strong> between the medians of the two groups.<\/li>\n<\/ul>\n\n\n\nIn our example, the calculated test statistic (3.31)<\/strong> is smaller than the critical value (3.841)<\/strong>. What this means to us is that we do not have enough evidence<\/strong> to reject the null hypothesis<\/strong>. Therefore, the final result based on the data that we have collected, is that we cannot conclude a significant difference<\/strong> in medians between Class A and Class B at the chosen significance level<\/strong>.<\/p>\n\n\n\nThe example shown here is simplified, and any real-world analysis would mean that we will probably have to reconsider assumptions, data quality, and the context in which we are working. Excel might not be the best tool for Mood\u2019s Median Test<\/strong>, and some other statistical tools can probably help us more.<\/p>\n","protected":false},"excerpt":{"rendered":"Although Excel has many built-in formulas that fall under many categories: statistical, mathematical, logical, and many more, there are some things that cannot…<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[170],"yoast_head":"\n
Mood's Median Test in Excel\u00a0<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n