A Reaction to the Lecture Notes
Lecture three is more elaborate on explaining the details of using excel to perform the f-test and the t-test. First, it starts by bridging the gaps left by lecture two. Thus, the lecture gets into the details of setting up data for analysis when conducting both tests. It also elaborates on the various test-specific details. For instance, it emphasizes the need for performing an f-test before a t-test. The choice of the type of t-test to be performed depends on whether the variances are equal or not equal: a conclusion of the f-test. However, one can perform the t-test by assuming equal or unequal variance. The lecture is also keen to point out the possible confusion one can make while performing the T-Test Paired Two Sample for Means.
The material is clear in guiding one to understand the data analysis. It, however, fails to mention that the data analysis tool has to be installed from the excess add-in before it can appear on the data ribbon ( Nelson, 2013). Nonetheless, after installing the tool, one is able to follow the steps in the lecture and perform the data analysis successfully.
Delegate your assignment to our experts and they will do the rest.
Testing the Equality of the Means of the Male and Female Midpoints
The midpoint was thought necessary for answering the question of equal pay for equal work. As such, this assignment performs a t-test to check the equality of midpoints by setting up data, as shown in figure 1. The analysis then continues by sorting the data from smallest to the largest midpoints. Thereafter, one has to select t-Tests two-sample assuming equal variances in the data analysis tool as shown in figure 2. The null and alternate hypothesis is as shown as H0 and H1, respectively.
H0: Male midpoint means = Female midpoint means
H1: male midpoint means ≠ Female midpoint means
Figure 1: Data set in excel for T-Test Two-Sample for Means
Figure 2: Running the data analysis tool for T-Test Two-Sample for Means
Results and Interpretation
The results of the t-test are as shown in figure 3. The p-values for the test is 0.0013. The p-value is less than the alpha value of 0.05: P (0.0013 <= 0.05). Thus we reject the null hypothesis. In conclusion, the means of the male and the means of the female midpoints are different.
Figure 3: A screen capture of the results of data analysis for T-Test Two-Sample for Means
References
Nelson, S. (2013). Excel 2007 data analysis for dummies (p. 245). Hoboken, N.J.: John Wiley & Sons.
