MATHS COURSEWORK - Mayfield High - To analyse data provided by Mayfield High School by using a range of different techniques...

Authors Avatar

Avnit Mahal

Mathematics Statistics Coursework

Objective

To analyse data provided by Mayfield High School by using a range of different techniques.

Hypotheses

  1. I am going to investigate the relationship between the more hours of TV watched and the students IQ in year 10.    

  1. I am going to investigate that students in year 11 will have a greater spread of weight (BMI) than students in year 10.  

   

  1. 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. Furthermore they will be taller so their weight will be spread over a further distance meaning a smaller spread of weight over the shorter year 10s. Also stress can play a factor as it can affect a student’s weight. Year 11s have a lot of stress to deal with because of GCSE Exams.

Hypothesis 3   

The reason I chose my third hypothesis is to prove whether males or females are more intelligent by their IQ. I predict that males will have a higher IQ because previous research proves that males generally have a higher IQ than their counter parts. I believe this will apply at Key stage 4 as well.

As the data was provided to me it is known as secondary data. Secondary data includes anything which is available from an external source. There are many advantages and disadvantages of secondary data.  There are many ways of using secondary data yet for the task I will use it for my main mode of research.

The advantages include it is much faster. As you have not collected the data it is less time consuming as it is provided from an external source it does not waste valuable time. Furthermore secondary data is useful at representing the population and analysing certain areas of the research.  The limitations of secondary research are they are usually collected for a different purpose. Sometimes a Lack of Awareness can lead to errors such as empty cells or invalid data. Furthermore as you did not collect the data yourself bias could occur because of the methods used to collect the data.

Bias is anything which distorts the data so that the end result is it cannot provide a fairly representative picture of a population. Bias can arise in two different methods:

In the way the questions were asked and from the people asked. From the Mayfield Data it is impossible to know what questions were asked yet the whole school was asked the same question so bias could not have arisen by the people asked.

As collecting data from 1182 students, the complete set of data would take very long and waste valuable time I will sample the data collected. A sample is a small proportion of the data which can be applied for the whole of the population of data. The advantages of sampling are that it is much faster and cheaper to collect data. Sample size is very important as if it is not large enough it cannot be representative of the whole set of data. I will sample the data using the Excel Sample function. This is much faster and provides accurate results.

There are a range of different sampling methods which can be used to sample the data, yet for this coursework I will use random sampling and systematic sampling.

Random sampling

This type of sampling results in every member of the data having an equal chance of being selected.

For my first hypothesis and my last hypothesis I will use a random sample to collect data. To do this I will first assign all the data numbers. Then I will calculate the mean number of students needed for the sample in Excel. After this I will multiply the numbers of students provided in the data by the random function of excel. This will provide a random number between 1 and the number of students in the data. This will be the number of which data which will be included in my sample. I will do this by using the random function in Excel.

Join now!

Systematic Sampling

This is a much simpler method of sampling which I will use for my second hypothesis. This includes collecting data from every tenth individual from the data. I will do this by counting every tenth piece of data.

Invalid Data

Some of the data collected contained invalid information. To deal with this I simply decide it would be better for my results if I did not include the record in my sample. Data on Ahmed Nolan and James Lewis IQ was missing so they were not included in my sample. There were also many unrealistic data ...

This is a preview of the whole essay