Is the claim realistic in light of the past two years?

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.

You will submit a single Excel file that includes your results for all of the exercises. For each exercise, please 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 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
Exercises
At the beginning and end of a four-week exercise program, the weights of nine adults were taken. Use the data below to test the claim that the program helps students to lose weight.
Weights Before and After Program
Start Weight (lbs) 118 126 134 162 145 188 173 125 137
End Weight (lbs) 123 131 132 159 138 182 170 128 137
It is believed that freshmen at MU earn higher averages in Stats than do the sophomores. The results of past classes reveal an average for the freshmen (n=57) of 83.63 with a standard deviation of 6.3 and an average for the sophomores (n=30) of 79.3 with a standard deviation of 8.6. Is the claim realistic in light of the past two years?
A researcher recently sought to determine whether there is a noticeable difference between coronavirus infection rates among those working from home and those commuting to work in 2020. He found that out of 810 people working from home, 62 were diagnosed with COVID, and out of 656 people commuting to work, 67 were diagnosed with COVID. Is there a statistical difference between these two groups?

Last Completed Projects