Left/right handed: This is very important as I am trying to prove whether left handed people are smarter and more creative than right handed people.
Key Stage 2 Science results: This will help me prove the students creativity skills and IQ levels.
Key Stage 2 English results: This will help me prove the students IQ levels.
Key Stage 2 Maths results: This will help me prove the students IQ levels.
IQ levels: This will definitely help me prove the pupils IQ levels.
There are about 1200 names in the Mayfield High data and to make it easier and the project smaller for me I will choose 80 names in total. I will choose 40 right handed people and then 40 left handed people. There are many different ways in choosing what data you can use such as:
Randomized: This means choosing the names at random with no specific order.
Quota: This method chooses a sample of data such as 40 right handed people and 40 left handed people.
Systematic: This means choosing the data in order, such as choosing a person every 20 names. This method is very similar to choosing the data in random.
I am using the method quota to select my data. I will select 40 right handed students and 40 left handed students. I will sort the data into two groups. One group will be left handed and the other right handed. I will then put the names for the two groups into order starting with the names beginning with the letter ‘A’ at the top of my table. I will be using 80 students from year 10 only. This the data that I have decided to keep:
I have also done a pivot table to show how many students I have selected from the left and right handed groups:
I am now going to make some pivot tables and graphs for the Key Stage 2 results for English, Maths and Science. Once I have put my data into the graphs I should be able to prove which handed people are cleverer than the other.
I am going to start off with a pivot table for the English results and then construct a bar graph to compare the different results between the right and left handed students.
I have constructed this bar graph by selecting the English level and the left and right handed columns from the pivot table. I then selected what graph I wanted to use to compare my data. I chose a graph which had its data columns next to each other as it would be very easy to compare the different English KS2 results for the left and right handed students. This is the graph I came up with:
When looking at this graph there is only 1 left handed and 2 right handed students who got a level 2 in English. The number of students who got level 3 has risen by a large amount to 12 left and 6 right handed students. Level 4 on the other hand is practically the opposite of level 3 as there are only 12 left handed students and a large 21 right handed students. For level 5 there are 13 left and 11 right handed pupils. For level 6 there are only 2 left handed students who got this level. The left handed pupils results are generally the same especially from levels 3 to 5 whereas the right handed students results are very uneven ranging from 2 pupils for level 2 to 21 students for level 4. In my hypothesis I am trying to prove that left handed students are more clever than right handed students so I am going to work out the averages for this subject.
The mean number for the KS2 English results for the left handed pupils
is: 163 ÷ 40 = 4.075
The mean number for the KS2 English results for the right handed pupils
is: 161 ÷ 40 = 4.025
As you can see from the mean results the left handed students get a higher level overall of 4.075 compared to the slightly lower 4.025 of the right handed students.
The modal number for the KS2 English results for the left handed pupils is: 5
The modal number for the KS2 English results for the right handed pupils is: 4
The modal results show that the left handed pupils have got a level 5 whereas the right handed students have only got a level 4. These results again prove that left handed students are slightly cleverer than right handed students.
I am now going to construct another pivot table in Excel but this time for the KS2 maths results. I will then choose an appropriate bar graph to plot the pivot table’s results.
I have made this pivot table by selecting the pivot table button and dragging which information I wanted to include in the table. For this instance I dragged in the maths levels, the left and right handed pupils and the grand totals. The computer did the rest and the pivot table came out looking like this. Once again I have chosen the same graph with the columns next to each other. This is what the graph looked like:
When looking at this graph you can see that there are 2 left handed and 1 right handed student that have got a level 2. The amount of pupils getting level 3 shoots up to 11 left handed and 12 right handed students. For level 4 the number of pupils getting this level one again rises to 14 left handed and 16 right handed pupils. For level 5 the numbers drop to an even 11 left handed and 11 right handed students. For level 6 in the KS2 maths results as well as in the KS2 English results there are only 2 left handed students who got a level 6. I am now going to work out averages for the Maths results.
The mean number for the KS2 Maths results for the left handed students
is: 160 ÷ 40 = 4
The mean number for the KS2 Maths results for the right handed students
is: 157 ÷ 40 = 3.925
As you can see from the mean number results the left handed students get a level 4 whereas the right handed students get a lower level of 3.925. Once again the left handed pupils get a higher level than the right handed pupils so I am proving my hypothesis correct for the English and Maths results.
The modal number for the KS2 Maths results for the left handed students
is: 4
The modal number for the KS2 Maths results for the right handed students
is: 4
As you can see from the modal results the left and right handed results are the same. The modal results are not that accurate and cannot distinguish whether the left handed pupils are smarter than the right handed pupils.
I am now going to make my third and final pivot table for the KS2 results. My pivot table this time will be on the Science results.
As I have used the same bar graph for the Maths and English results I will also use it for the Science results. This is what the bar graph ended up looking like:
When looking at this graph you can immediately see that the results for the left and right handed pupils are mostly the same. There is 1 left handed and 1 right handed student for level 2. For level 3 there are 8 left handed and 9 right handed pupils. For level 4 the amount of pupils getting this level shoots up to 19 left handed and 21 right handed students. For level 5 the number of students with this result decreases dramatically to 10 left handed and 8 right handed pupils. For the first time in the level 6 section there is a 1 right handed student and as all the times before 2 left handed students. It looks like the same 2 left handed pupils keep getting a level 6 for English, Maths and Science. I will now work out the mean and modal results for the KS2 Science levels.
The mean number for the KS2 Science result for the left handed pupils
is: 164 ÷ 40 = 4.1
The mean number for the KS2 Science result for the right handed pupils
is: 159 ÷ 40 = 3.975
Once again it is very clear to see that the left handed students have got a higher level compared to the right handed students. The result for the left handed pupils is a huge level of 4.1 compared to a much smaller 3.975 level result for the right handed pupils.
The modal number for the KS2 Science results for the left handed students
is: 4
The modal number for the KS2 Science results for the right handed students
is: 4
Once again the modal results are the same but as I said before the modal number is only the number that occurs the most and therefore is not that accurate.
I am now going to draw some cumulative frequency graphs and work out the upper, lower and inter quartile range to compare the left handed students to the right handed students. I will draw 3 graphs in total, 1 for the English results, 1 for the Maths results and 1 for the Science results.
Left handed students results for English:
Lower quartile = 25% of 40 = 10 = 2.8
Upper quartile = 75% of 40 = 30 = 4.3
Inter quartile range = 4.3 – 2.8 = 1.5
Right handed students results for English:
Lower quartile = 25% of 40 = 10 = 3.1
Upper quartile = 75% of 40 = 30 = 4
Inter quartile range = 4 - 3.1 = 0.9
By looking at these results the left handed students get the higher inter quartile range of 1.5 compared to the much smaller 0.9 of the right handed students. The right handed pupils get a slightly higher lower quartile range of 3.1 while the left handed pupils get only 2.8.
Left handed students results for Maths:
Lower quartile = 25% of 40 = 10 = 2.75
Upper quartile = 75% of 40 = 30 = 4.25
Inter quartile range = 4.25 – 2.75 = 1.5
Right handed students results for Maths:
Lower quartile = 25% of 40 = 10 = 2.925
Upper quartile = 75% of 40 = 30 = 4.025
Inter quartile range = 4.025 – 2.925 = 1.1
By looking at these results the right handed students get a higher mark of 2.925 for the lower quartile while the left handed pupils only get 2.75. The left handed students get a very high 1.5 for the inter quartile range whereas the right handed students get a small 1.1.
Left handed students results for Science:
Lower quartile = 25% of 40 = 10 = 3.05
Upper quartile = 25% of 40 = 30 = 4.075
Inter quartile range = 4.075 – 3.05 = 1.025
Right handed students results for Science:
Lower quartile = 25% of 40 = 10 = 3
Upper quartile = 25% of 40 = 30 = 3.975
Inter quartile range = 3.975 – 3 = 0.975
By looking at all the bar graphs, cumulative frequency graphs and pivot tables it is clear to see that the year 10 left handed students have overall done better in all the Key Stage 2 tests in English, Maths and Science.
------------------------------------------------------------------------------------------------
I am now going to compare the year 10 left and right handed IQ results. I am going to construct a pivot table with all the IQ results in Microsoft Excel. I will then work out the mean and median for the IQ results.
The mean IQ for the left handed students = 101.5
The mean IQ for the right handed students = 99.575
The left handed students got a 101.5 mean IQ average which was a total of 1.925 higher than the right handed IQ average.
The median IQ for the left handed students = 102
The median IQ for the right handed students = 100.5
Once again the left handed students beat the right handed students with an average Median IQ score of 102 compared to the 1.5 smaller average IQ score of the right handed students.
I will now draw 2 scatter diagrams. I will start off by drawing one scatter diagram for the left handed IQ results and then drawing one for the right handed student’s results.
By looking at the scatter diagram for the left handed students IQ results you can see a positive correlation in the graph. The highest IQ result is 131 and the lowest result is 74.
By looking at the second scatter diagram for the results for the right handed students the correlation is again positive. But the correlation is not as strong as the left handed students scatter diagram correlation. The highest mark is only 117 compared to the huge 131 of the left handed student. The line of best fit is steeper for the left handed IQ results than the right handed IQ results.
I will now work out standard deviation for the IQ left and right handed results. Hopefully I will once again prove that left handed people are smarter than right handed people. To work out standard deviation on Microsoft Excel you have to first:
1: Highlight the data you want to use
2: Click on the small fx button which is situated to the top left of the page
3: A grey box will come up and you will have to select the function STDEV which stands for standard deviation, then press ok.
4: Another grey box will come up and this time you will have to fill in the number 1 box with a range. E.g. E2:E42.
5: The formula result for the standard deviation will be at the bottom of the grey box.
The formula result of the standard deviation for the left handed students is: 11.30690735.
The formula result of the standard deviation for the right handed students is:
10.65757826.
The left handed pupils once again get a higher mark and this time its for the standard deviation results. The left handed students got a much bigger 11.3 compared to a much smaller 10.7 of the right handed pupils.
Overall throughout the whole of my project comparing the smartness of the year 10 left and right handed students it is very clear to see that the left handed pupils have got higher marks and generally done better than the right handed pupils. For the English, Maths and Science KS2 results and the IQ results it is obvious that the left handed students have got higher levels and marks. Not every year 10 will the left handed students do better as there may be years when there are more smart right handed pupils. I think it is safe to say that for this year 10 the left handed students have done much better by getting higher marks and that I have proved my hypothesis correct.