Hi everyone,
I would like to run a Kruskal-Wallis test on a large sample with a likert scale. I am having difficulties figuring out how to process with the ''rank_avg'', and rank sum with such a large sample. Here's how my data is presented for a typical question:
-Marketing department, 1200 respondants, 88% are favorable, 4% neutral and 8% not favorable to the question
-Eng. department, 500 respondants, 77% are favorable, 3% neutral, 20%... and so on
I would like to assess if results from each department are statistically significantly different from one another. Maybe this is not the right test to use, I would like your help since it is my first survey analysis.
Thank you and best regards
Hello VIncent,
If you must use excel to evaluate a Kruskal-Wallis test, here is a link that will walk you through the steps:
https://www.real-statistics.com/one-way-analysis-of-variance-anova/kruskal-wallis-test/ (Note that this does include an explanation of how to use the real statistics add-in module to excel as well.)
Of course, many other statistical software packages, including the freely available R system, include subprograms to perform the Kruskal-Wallis test.
Good luck with your work.
Why not use such more friendly package as SPSS for such large data ?
- Badges
- Science topic
- Similar topics
- Biological Science
- Kinesiology
- Running