Cell E7 contains the Pearson Correlation which indicates that the two variables are rather closely correlated.Cells E6 and F6 contain the number of observations in each sample.Cells E5 and F5 contain the variance of each sample.Cells E4 and F4 contain the mean of each sample, Variable 1 = Beginning and Variable 2 = End.Uncheck Labels since we did not include the column headings in our Variable 1 and 2 Ranges.This means that we are testing that the means between the two samples are equal. Enter "0" for Hypothesized Mean Difference.This is our second set of values, the values recorded at the end of the school year. This is our first set of values, the values recorded at the beginning of the school year. On the XLMiner Analysis ToolPak pane, click t-Test Paired Two-Sample for Means.Use the Paired t-Test to determine if the average score of the 2nd test has improved over the average score of the 1st test.
The students were given the same test at the beginning and end of the school year.
The example datasets below were taken from a population of 10 students.