TURKEY TEST XLMINER ANALYSIS TOOLPAK HOW TO

Imagine we wanted to know whether social status had an influence on the lifespan of an individual. In most cases we have more than two groups. We can use a plugin calledВ XLMiner Analysis ToolPak to do the ANOVA, which can help us decide if in our class females are taller than males, and give us an idea of how confident we can be of our results. Now, the question is are females in the class taller than males or is it the other way around.

TURKEY TEST XLMINER ANALYSIS TOOLPAK HOW TO

HereвЂ™s how to do it in google sheets, tutorial, although there many more available. Now, you need to make two histograms: one for females and one for males. The statistical technique ANOVA, for Analysis of Variance, is the toolВ we are going to use in our case.ДЄnd now, open a spreadsheet, like google sheetВ or excel, and paste the data. Now, the problem with all these measures is that they lack estimations of statistical significance. Yet another one would be to line males and females separately, sort by height, and pick the persons in the middle of the two lines and compare them. Yet another one would be to pick the tallest male and tallest female and compare them. Another one would be to line them up, sort them by height, and see how many males and females are in the taller half. One way would be to pick random males and females from a sample and record how many times the male is taller and how many times the female is taller. Get in groups and craft a plan to do that.

But, is this really the case? How would you test that? Use the students in our class as your sample. Today we will learn a bit about what to do when we donвЂ™t know how to answer a question.В It is typically assumed that males are taller than females.

Turkey test xlminer analysis toolpak