Hypothesis Testing in Excel - University of Washington
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.
[pic]
Then, choose Tools/DataAnalysis/t-Test: Two Sample Assuming Unequal Variances
This is what I generally choose if I have no reason for believing that the variances from the two groups are equal.
[pic]
Then, complete the t-Test box by highlighting the appropriate areas, indicating whether labels are included and specifying an output range.
The Hypothesized Mean Difference refers to the difference that you are testing for between the mean for the first group and the mean for the second group. If, as woul dusually be the case, you are testing whether or not the two groups have equal means, the Hypothesized Mean difference would be zero.
Also, the window asks for Alpha, or the probability of a Type 1 error. This is used to generate critical values in the output and isn’t all that important as you will also be getting p-values with your output.
[pic]
The output looks like this
[pic]
The mean, variance and number of observations are given for each group.
The t-Stat is given.
The p-values and critical values are given for one and two tailed tests. If these are small, the means are significantly different. That is, you can reject the null hypothesis of equality in favor of the alternative hypothesis that:
1. the means are unequal, in the case of a two-tailed test
or
2. the mean of B is greater than the mean of A, in the case of a one-tailed test.
Note that the second of these takes the form that it does because the sample mean for B was greater than the sample mean for A. Given the data above, you would never reject the one sided null hypothesis that the mean of B was greater than or equal to the mean of B.
Here’s another example where the null hypotheses wouldn’t be rejected:
[pic]
In this version, the mean are so close that the null hypothesis that the mean for A is equal to the mean for B can’t be rejected, as indicated by the p-values of 0.40145 and 0.8029 for the one and two-tailed tests, respectively.
Looking at Residuals from Regressions in Excel
To look at regression residuals in Excel, first do a regression and specify that you want to save the residuals
[pic]
Below the summary output from the regression will be a column with the residuals
[pic]
You can then do a scatterplot of the residuals against the explanatory variable(s) by copying the column of residuals to a column next to the explanatory variable of your choice
[pic]
and simply doing a scatterplot by choosing Insert/Chart/XYScatter
[pic]
[pic]
Ideally, thee will be no pattern in the scatterplot(s). In this case there is, so I would try to add another explanatory variable (maybe X2) to the regression and do it again.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- example problems one sample z and t tests
- unit 7 hypothesis testing practice problems solutions
- statistics project hypothesis testing
- hypothesis testing
- lecture 15 examples of hypothesis tests v3 ramesh
- five step hypothesis testing for dependent t test
- performing hypothesis testing for one sample t tests in
- hypothesis testing with t tests university of michigan
- hypothesis testing an example
- example spss output for t test for difference in means
Related searches
- university of washington hr jobs
- university of washington jobs listing
- university of washington human resources
- university of washington human resources dept
- hypothesis testing in nursing example
- hypothesis testing in daily life
- university of washington baseball roster
- university of washington product management
- university of washington online mba
- university of washington printable map
- university of washington opioid taper
- university of washington opioid calculator