Excel 2 T-Test

This assignment is a continuation of the last assignment.  We are using the same basic data, but digging a little deeper this time and using T-test to see if there is a significant difference between male and female achievement.  Our hypothesis is that there is a significant difference (greater than 5%) between male and female Reading Test Scores.  The null hypothesis is, therefore, there in not a significant difference.  In other words, less than 5%.

So, in order to do this, I had to go back into the Excel workbook and reopen the sheet containing all the information from NAEP's 2011 4th grade reading results.  I then went back into the data analysis tool pack within Excel and used the t-Test, two sample assuming equal variances option.  After selecting the data to be compared, boys versus girls, I let the computer do its thing.  Here are the results:

Because both 1.6% and 3.2% are less than 5%, I must accept the Null Hypothesis.  There is not a significant difference between male and female scores at the 4th grade reading level in 2011.

Since I teach in a high school, I could actually use this activity to show them where we are ranking.  On a bright note, the Eastern Panhandle of West Virginia actually has much better scores, but it would be interesting to get their take on how we might be able to improve scores across the state.  I like doing activities like this with my students.  It really gets them thinking and they take ownership when it involves them and real world information.  It also forces Mrs. Stephens to keep up with her statistical skills.

The NETS standards represented here are:

3b. collaborate with students, peers, parents, and community members using digital tools and resources to support student success and innovation.   5a. participate in local and global learning communities to explore creative applications of technology to improve student learning. 5c. evaluate and reflect on current research and professional practice on a regular basis to make effective use of existing and emerging digital tools and resources in support of student learning.