MATHS COURSEWORK - Mayfield High - To analyse data provided by Mayfield High School by using a range of different techniques...
Extracts from this document...
Introduction
Avnit Mahal
Mathematics Statistics Coursework
Objective
To analyse data provided by Mayfield High School by using a range of different techniques.
Hypotheses
- I am going to investigate the relationship between the more hours of TV watched and the students IQ in year 10.
- I am going to investigate that students in year 11 will have a greater spread of weight (BMI) than students in year 10.
- I am going to investigate the relationship between the gender and the IQ for students at Key Stage 4.
For this data handling coursework I have been provided with data to assist me with proving my hypotheses. The data that I will be using to investigate my hypotheses is secondary data provided by a school called Mayfield High School. The data provided consists of data for key stages. It contains 13 categories of data ranging from Year Group to distance walked to school.
Hypothesis 1
The reason I chose this hypothesises because it will provide me accurate information on whether or not watching television actually does cause the IQ to decrease. The obvious theory behind this is that the more hours spent watching TV the lower the IQ as it is thought that TV will prevent students learning meaning they will have a lower IQ.
Hypothesis 2
The notion behind my second hypothesis is that it will be able to prove whether or not students in year 11 are more conscience about their weight than students in year10. I predict that students in year 11, mainly females, will become more conscience of their weight and will thus result in a smaller spread of weight than the year 10s. Also students in year 11 will do more exercise meaning this will affect their weight.
Middle
2
1,2,5,5,6,7,8,8
3
0,0,1,1
4
0,0,2
5
6
5
MEDIAN=25.5 Hours per Week
MODAL GROUP=20-29 Hours per week
Stem and Leaf Diagram of IQ of the above Students
7 | 4 |
8 | 4,7,8,9 |
9 | 0,0,0,2,6,9 |
10 | 0,0,0,0,1,2,2,3,3,3,4,4,4,7 |
11 | 6 |
MEDIAN IQ=100.5
MODAL GROUP=101-110 IQ
From these diagrams we can see clearly that the stem and leaf diagram agrees with the frequency polygon and the average number of hours of TV watched per week does affect your IQ as the average number of pupils who watch TV for 20-29 hours of TV per week have an average IQ of 101-110.
Overall it is possible to say that this diagram does not agree with my hypothesis and that the average amount of hours TW watched is the most promising for a students IQ.
From the analysis of the data for my first hypothesis it is possible to say that my hypothesis was correct to a certain extent.
Hypothesis 2
To investigate my second hypothesis I have decided to use a scatter graph to try and discover if the year 10s or year 11s have a greater spread of weight. The scatter diagram here will show the spread of year 10 and 11 students BMI upon a scatter graph.
The graph shows that there is a very large spread of students BMI across the scatter diagram.
From this graph it is possible to say that there is not as larger spread compared to the year 10s.
Also I worked out the product moment coefficient of the two graphs.
For the year 10 the product moment coefficient was 0.39767886.
For the year 11 the product moment coefficient was 0.424072703.
This proves that there was a greater correlation for the Year 11s proving that there will be a smaller spread of weights. This disagrees with my hypothesis as it proves that year 10s have a greater spread of weight.
Secondly I calculated the average BMI of the two year groups. To calculate BMI (Body Mass Index) the formula is weight / Height ^2.
YEAR 10 YEAR 11
Height (m) | Weight (kg) | BMI (kg/m2) | Height (m) | Weight (kg) | BMI (kg/m2) | |
1.66 | 66.00 | 23.95 | 1.37 | 30.00 | 15.98 | |
1.54 | 57.00 | 24.03 | 1.52 | 44.00 | 19.04 | |
1.63 | 40.00 | 15.06 | 1.52 | 48.00 | 20.78 | |
1.60 | 50.00 | 19.53 | 1.57 | 48.00 | 19.47 | |
1.60 | 51.00 | 19.92 | 1.60 | 48.00 | 18.75 | |
1.85 | 70.00 | 20.45 | 1.61 | 45.00 | 17.36 | |
1.72 | 54.00 | 18.25 | 1.62 | 51.00 | 19.43 | |
1.65 | 54.00 | 19.83 | 1.63 | 38.00 | 14.30 | |
1.72 | 71.00 | 24.00 | 1.65 | 66.00 | 24.24 | |
1.80 | 72.00 | 22.22 | 1.73 | 50.00 | 16.71 | |
1.80 | 54.00 | 16.67 | 1.75 | 56.00 | 18.29 | |
1.67 | 44.00 | 15.78 | 1.56 | 38.00 | 15.61 | |
1.65 | 68.00 | 24.98 | 1.60 | 66.00 | 25.78 | |
1.80 | 72.00 | 22.22 | 1.60 | 55.00 | 21.48 | |
1.52 | 45.00 | 19.48 | 1.63 | 48.00 | 18.07 | |
1.56 | 56.00 | 23.01 | 1.63 | 48.00 | 18.07 | |
1.63 | 72.00 | 27.10 | 1.65 | 66.00 | 24.24 | |
1.65 | 54.00 | 19.83 | 1.65 | 54.00 | 19.83 | |
1.55 | 48.00 | 19.98 | 1.69 | 54.00 | 18.91 | |
1.73 | 42.00 | 14.03 | 1.70 | 63.00 | 21.80 | |
1.74 | 47.00 | 15.52 | 1.76 | 56.00 | 18.08 | |
1.58 | 36.00 | 14.42 | ||||
1.52 | 70.00 | 30.30 | ||||
1.68 | 53.00 | 18.78 | ||||
1.61 | 59.00 | 22.76 | ||||
1.39 | 42.00 | 21.74 |
AVERAGE BMI FOR BOTH YEARS
Year 10= 20.53
Year 11= 19.34
This important calculation straight away proves my hypothesis incorrect as it states that the average BMI for year 10 is greater than the average BMI for year 11. The calculation also agrees with the scatter graph as it proves that Year 10 also have a greater spread of weight.
Another calculation includes the range of both of the years BMI. To calculate this I must work out the maximum and minimum BMI for both year groups and then takeaway the minimum from the maximum to give me the range.
The maximum AND minimum BMI for the year 10s was
30.30 |
14.03 |
RANGE |
16.26 |
The maximum AND minimum BMI for the year 11s was
25.78 |
14.30 |
RANGE |
11.48 |
Conclusion
I believe that it is not possible to confer that the data was not biased because we are unsure of the collection techniques so we are not 100% of how the data was collected and if it was collected in a biased way or not. However we can be sure that bias did not arise by the people asked because the whole school was asked the same questions so bias could not have arisen by the people asked.
Overall for improvement to the investigation, I would have not used systematic sampling for one of my hypotheses.
To investigate the problem further, I believe that I could have collected data from my own school and process the data and analyse whether or not the data agrees or disagrees with my hypotheses. My collection techniques would have been unbiased and I would use the same techniques used in this investigation so that I could compare the overall results of Mayfield School to Sir William Borlase Grammar School. This would have provided interesting data to analyse and would have provided me with more data to prove my hypotheses correct or incorrect.
This student written piece of work is one of many that can be found in our GCSE Miscellaneous section.
Found what you're looking for?
- Start learning 29% faster today
- 150,000+ documents available
- Just £6.99 a month