Looping ANOVA to determine most similar groupHi all,
I'm looking to loop a procedure that would otherwise be tedious. Potentially, someone may have a better workflow and I'm all ears if you do. For my dataset, I have 5 ethnicities and I'm trying to figure out what ethnicity 2 and ethnicity 5 match best to so I can combine the ethnicities. What I want to do is run an ANOVA and Welche's Test between 2 and the rest of the ethnicities and see if they match and which one matches best. This would only be 4 Tests, but I have 40 different groups as well so this would be a tedious tast to repeat manually. Would there be a way to loop this and somehow automate a formula where is ethnicitiy 2 matches lets say ethnicity 3 best there is a column indicator for that?
If there are better statistical methods in JMP that can facilitate this as well, I'm all ears.
AnalyticsmacOSScriptingRe: Looping ANOVA to determine most similar groupWhat you need to do, is to run the steps that need to be done for 1 group. Then, taking those steps and looping through all of the groups should be a very easy task.
Re: Looping ANOVA to determine most similar groupI generally avoid dividing the data into separate groups. (There are situations that call for separating data, of course.) I think about a model that might use all the data for the most power and sensitivity, but also account for group differences, if they exist. So what about a linear model that includes ethnicity and the group as effects?
Another consideration is the partition method. This model will tend to find the levels that should not be split.
Have you tried using two-dimensional hierarchical clustering?
Finally, ANOVA is useful when you are testing for a difference. it is not intended when you are testing for similarity. Lack of a significant ANOVA is not evidence for similarity. Equivalence testing is also a one direction test, but in the opposite direction.
