Excel 2

Using the same data as the previous Excel blog, we were asked to look at a research question.

Used NCES site and looked at the state comparisons to assess where we are in terms of the national educational landscape. 

Research Question: What factor, if any, does gender play in 8th grade math performance?
Hypothesis: There is a difference between the male and female scores.
Hypothesis: There is no difference. (null hypothesis)

For this particular question we will be looking at the following information:

categorical independent variable is gender male/female.

continuous dependent variable is NAEP 2011 8th Grade state math averages.

We know the averages and standard deviations from our descriptive statistics. Now we need to know whether to accept or reject the null hypothesis.  We can use a  t-test & then Look at the 2 tail p value and make a decision.  The picture below is a Jing image of the t-test I carried out for the given data.
 

As you can see by the t-chart, which gives you an average as well as p values (which we needed), there isn’t a difference between male and female scores.  To break that down I highlighted the p values.  On the right side, NSD stands for no significant difference because our p value is greater than 0.05.  Either test gives the same result, even the two tail is greater than 0.05, so there is no significant difference and thus we must accept the null hypothesis.  There is no difference between the male or female scores. 

 ISTE NETS T - Standard 1 & 2- During this activity, students are expected to complete an assignment using digital tools (Jing), technology system (Excel) and media. Students are expected to be active in their own learning and understanding of the content. Digital communication aides in the advancement of resources and support. This activity is a great summative assessment due to the nature of the outcomes. The scatter plot offers some sort of data that should be relevant to the assignment.