• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Bivariate Data

Extracts from this document...


Bivariate Data

        I am going to carry out an investigation into a set of bivariate data. The data I will investigate are a previous year groups KS3 and GCSE point score averages. I will see, whether or not there is a correlation between the KS3 and GCSE result scores.

        By finding a correlation or not, I will be able to determine if the scores obtained at KS3 will allow teachers to predict the student’s score at GCSE. If there is a strong correlation, this will be very useful for teachers and students to give them an idea on what they can be expected to score. Grade Predictions would be easier and probably more accurate.

        For example, if there is a correlation, a student could predict their GCSE score by using the KS3 results they obtained, and with this would provide a target score to reach or beat. This will also be useful for the teacher where they will be able to overview any additional help or teaching that a student may or may not need.

The Population (presented in table 1) shows last year’s groups, KS3 and GCSE point score averages. There are a total of 90 pieces of data. This is a fairly small population but it was the only set easily available. From the 90 I will randomly sample 50 pieces to investigate.

The way I randomly sampled the population, was to number each set one to ninety (1-90), while also numbering ninety pieces of paper.

...read more.


x and y to show that I have knowledge on how to calculate the mean.

Table 2, shows the sample, in relation to x and y, where x = KS3 and y = GCSE point scores. It also shows, x2, y2, xy, and the means of x and y. These have been calculated for the Pearson’s Product Moment Correlation Coefficient. From this, I can use the formula and calculate if there is a linear correlation or not. If there is a correlation (r) will take a value close to zero. The nearer ‘r’ is to +1 or –1 the stronger the correlation. From observation alone I know that the correlation will be positive.

I have calculated the correlation coefficient and the value I have ended up with is 0.935. As said before, the nearer ‘r’ is to +1 or –1 the stronger the correlation. For my sample, ‘r’ = 0935 to 3 s.f. This shows that there is a very strong positive linear correlation. This means that a line of best fit would be suitable for the data, as the line will be fairly accurate. The line of best fit has been drawn on graph 1.

The value calculated, ‘r’, can be used as an estimate for ‘ρ’. Where ‘ρ’ = the Correlation Coefficient of the Parent Population. ‘r’ can also be used  to carry out a hypothesis test on this value of ‘ρ’. The test consists of a Null hypothesis, where there is no correlation with the parent population. This is denoted as H0: ρ = 0. There are also three alternatives.

...read more.


        I believe the only errors with the data, were that that the scores given were all averages. The sample of 50 from the parent population was too big considering that the parent population consisted of 90 pieces of data. The parent population itself were KS3 and GCSE point scores from just one particular year group. It would have been more appropriate to gather data from several year groups to give the school a more general idea on the educational level through a period of time.

        To improve the investigation I would have sampled from a much bigger population to get more varied pieces of data. Once finding the linear correlation, if it there was a strong linear correlation I would have calculated the Least Square’s Regression line to find an equation for the line of best fit. This equation could then be used by itself to calculate GCSE scores by just being given the KS3 scores. I believe that using average point scores generalises a student’s ability. They may be weak in certain subjects and stronger in others. To improve this investigation, I would take the point scores of each subject and investigate their relation to the GCSE score points of the same subject. This would help show the student’s abilities in each subject and not his overall ability that may seem weaker because of a singular weakness in once subject which would bring their average point score down.

...read more.

This student written piece of work is one of many that can be found in our GCSE IQ Correlation section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE IQ Correlation essays

  1. Maths data handleling

    sample, I shall now go into the year groups and do the same. From this graph I can see already that boys watching TV can increase their IQ and in year 7 quite considerably, although I think that could change if I put in the whole lot of data on one graph (the whole school).

  2. The 3 statements I am going to investigate are: -Does the gender of the ...

    I will produce four bar charts showing each student's result in Maths compared to their one in Science; one graph each for boys in both years and the same for the girls. The above graph is of Maths and Science results for boys in Year 10.

  1. This experiment will show that there is a significant positive correlation between males and ...

    one participant could be born in September 1986 and another in August 1987. This age difference may have a large effect on self-esteem as their ideas of 'success' and what they want out of life may be different. To try and control this the study will have 15 participants from each gender James (1890)

  2. IQ Investigation

    and to compare males and females. In the year 7 diagram, I could see no obvious correlation between the 2 areas in either males or females. The average IQ for people in this year I could see to be between 94 and 103 and the average TV hours for people

  1. Maths IQ correlations

    71 (2dp) Tier 4-6 = 5, 6, 5, 5, 6 range = 6 - 3 = 3 Tier 4-6 = 6, 6, 6, 6, 6 mode = 6 Median = 17+1 = 9th = 5 is the median 2 The data in order is: 3, 3, 3, 4, 4, 4,

  2. I am going to investigate the IQ's and number of hours of TV watched ...

    Hypothesis A I will plot on a scatter gram all the IQs and no. of hours of TV watched a week of each person in my sample. As this hypothesis is not age specific, both year 7 and 11 will be included.

  1. The purpose of this investigation is to find if there is any correlation between ...

    Insert a new column, assign a random number between 0 and 1 to each record using the random number function =rand(). This number will change every time the spreadsheet is updated. Label this new column as Rand1. 2. Copy the random number to a new column and right click, paste special.

  2. Investigate the relationship between the IQ and Key Stage results of a group of ...

    If one boy is born in late August and another in early September (excluding September 1st), and the latter is therefore older, the IQ is likely to be higher for the older boy than for the younger one. This is because up to the age of 16, your IQ is constantly growing as the individual grows.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work