Using Two-Sample Hypothesis
In this assignment, you will simply be working through a few examples of hypothesis testing with two samples and determining whether the results are statistically significant using Excel. In some problems, you will be provided the data set, and in others, you will just be given the sample statistics.
Submit a single Excel file that includes your results for all of the exercises. For each exercise, include the output from XLMiner or one of the online calculator tools, and make sure that you clearly include the following information:
Null and alternative hypotheses (don’t forget that sometimes you’ll use p and sometimes μ)
The values of any sample means, proportions, and standard deviations
Which test you use and why. Here are the options:
t-Test: Paired Two-Sample for Means
t-Test: Two-Sample Assuming Equal Variances
t-Test: Two-Sample Assuming Unequal Variances
z-Test: Two-Sample for Proportions
The resulting p-value
Whether or not you reject the null hypothesis
