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

# Statistics Coursework - Bivariate Data.

Extracts from this document...

Introduction

Bivariate Data                Shahida Jaffer

Bivariate Data

## Moving to a new area with so much choice, my parents are skeptical about which middle school my brother should go to.  They want to find a school that doesn’t just do well in one subject at Key Stage 2, but at least two out of the three subjects.  I am going to investigate this by looking at maths and science results for children at Key stage 2 achieving level 5 to see if I can find a school with a positive correlation between them.  This will be shown if a school dos well in maths, and does just as well in science, and if it does badly in maths, does it do equally as badly in science.

DATA COLLECTION

The data I have used was collected from the ‘Department for Education and Skills’ Website, under the section of performance tables for primary schools at Key Stage 2.  I chose to get the data for schools within 15 miles around my postcode (MK5 8BS), the nearest being printed first.

Middle

CORRELATION CO-EFFICIENT

Now I will do a hypothesis test using the Pearson's Product Moment Correlation Co-efficient.  This is calculated using the formula below:

This is easier than it looks!  The first step is to calculate the following:

And then put all of these into the formula to find r (which is always between 1 and -1).  Using programs such as Microsoft Excel, you can highlight the data and the computer can automatically calculate the PPMCC.

Doing this, the PPMCC is 0.8528  - this backs up my thought that my variables have a good positive correlation, as perfect correlation is at 1 or -1.

I will now carry out a hypothesis test on the correlation co-efficient comparing it with ρ (the parent population correlation co-efficient).  This is called a test statistic, and will be a 1-tailed test at a 5% significance level.

Important things to know:

• The null hypothesis, H0 represents a theory that has been put forward, either because it is believed to be true or because it is to be used as a basis for argument, but has not been proved.
• The alternative hypothesis, H1, is a statement of what a statistical hypothesis test is set up to establish.
• The final conclusion once the test has been carried out is always given in terms of the null hypothesis. We either 'reject H0 in favour of H1' or 'do not reject H0'; we never conclude 'reject H1', or even 'accept H1'.

Conclusion

So, one can conclude that if a school have a high percentage of students doing well in maths, then they will have a similar high percentage of students doing well at science and achieving level 5.  Similarly, a school that has a poor performance in maths, will have an equally poor performance in science.

This means that if my parents want to find a good primary school for my brother, then they should choose a school which has a high percentage of students doing well in maths and science.

IMPROVING THE QUALITY OF DATA

There are many different ways I could do this if I was to repeat the investigation.  If my parents decide what type of school they want to send my brother to (eg public or private) than I could sort the data into these categories first, and then sample and test.  Another thing that I could do is remove all the schools that have percentages below the national average to see if this makes a difference to my hypothesis.

Page  of 3

This student written piece of work is one of many that can be found in our AS and A Level Probability & Statistics 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

# Related AS and A Level Probability & Statistics essays

1. ## The mathematical genii apply their Statistical Wizardry to Basketball

However at this stage I will calculate the relevant parameter for this piece of coursework. I will estimate the expected number of shots required by Lee and Dom to score a basket. Expected Mean Values To find out the expected mean value for a geometric distribution it is defined as

2. ## Statistics coursework

11 girls 86 Year 11 boys 84 452 - population Proportion of strata Rounded number Year 7 girls 57.96460177 58 Year 7 boys 66.81415929 67 Year 11 girls 38.05309735 38 Year 11 boys 37.16814159 37 - With sample size of 200 I feel this is an appropriate sample size as the lowest proportion is just over 30.

1. ## Intermediate Maths Driving Test Coursework

I will repeat this procedure for each day. If I come across missing data I will move onto the next available field and continue. Below I have shown a print screen for Tuesday the candidates I am using for the sample.

2. ## Anthropometric Data

On the scatter graph the (y) versus the corresponding values of (x). On the vertical axis which is (y) is usually responding variable and the horizontal axis which is (x) which relate to the response. A scatter will be drawn to identify any outliers which mean any anomalous result that may look far out from the region.

1. ## Maths Statistics Investigation

+ 8) + 0.1((0.0005x28000) +24) 0.9(104.5+8) + 0.1(14+24) = 101.25 = 3.8 101.25+3.8=105.05 TOO BIG * When X = 0.6 * And Y = 0.4 0.6((9.5x11) +8) + 0.4((0.0005x28000) +24) 0.6(104.5+8) + 0.4(14+24) =67.5 =15.2 67.5+15.2= 82.7 too small * When X = 0.7 * And Y = 0.3 0.7((9.5x11)

2. ## I am going to design and then carry out an experiment to test people's ...

This is my new boxplot. Here I can again see that the interquartile range of the 'am' boxplot is further to the left, proving my hypothesis. However this time I notice that the 'am' boxplot has a smaller inter quartile range than the 'pm' boxplot.

1. ## Fantasy Football - Maths Coursework - Statistics

I will use the data I have to prove this. To do this I will take a sample of my data, from attackers, midfielders and defenders, and with my sample I will make a cumulative frequency graph. From this graph I will be able to find out the median and the interquartile range.

2. ## Teenagers and Computers Data And Statistics Project

Number of red faces Formula 0 (n - 2 ) 3 1 6 [ (n - 2) 2] 2 n3 - (n -2)3 - 6[(n - 2 )2 ] - 8 3 8 Total n 3 5. Explanation of the 10 x 10 x 10 cube This was relatively easy

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