HypothesisTestinginExcel-UWCoursesWeb.docVIP

Hypothesis Testing in Excel The first step is to get the data for the two groups you want organized so that the observations from one group are together and the observations for the second group are together. They don’t have to be in separate columns, but this is one way to do it. They would just be sorted in one column so that the observations from the first group are all together and so that the observations from the second group are all together. Then, choose Tools/DataAnalysis/t-Test: Two Sample Assuming Unequal Variances This is what I generally choose if I have no reason for b