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

data handling

Extracts from this document...

Introduction

Data Handling Project

Planning

I intend to investigate the relationship between the number of hours of TV watched per week by students and their KS2 maths results. I think the more TV a student watches the less successful they will be.

Hence, I expect a negative correlation i.e. the two sets of data will be inversely proportional.

Firstly, I will retrieve the relevant data i.e. gender, hours of TV watched and maths results from the spreadsheet provided. As there are on average 200 students in each year, years 7-11, almost over 1000 students, it would be difficult to analyse such large data. Therefore, I will pick one of the five year groups randomly and base my investigation on the selected year group.

I will sort the year group into two sub-groups according to their gender. I will then apply the method of systematic sampling to the data. This will make the data more represent able. I have randomly selected Year 9.

As there are 261 students in Year 9 and I intend to have a sample of 30 students I will therefore select every 8th student and randomly eliminate two, thus leaving me with a sample of 30 students.

261

30

= 8.7

261

32 -2 = 30

8

The collected data sample of 30 students is the raw data.

...read more.

Middle

The evidence from the sample suggests males, on average, scored higher in their KS2 maths results than females, for this particular year.

In order to support the above statement I will compare the mean, mode, median and range of the KS2 maths results for males and females.

Mean maths results

Mean maths result for females = 4.06

Mean maths result for males = 4.66

Mode maths results

Mode maths result for females = 4

Mode maths result for males = 5

Median maths results

Median maths result for females = 4

Median maths result for males =5

Range of maths results

Range of maths results for females = 2

Range of maths results for males =2

I have summarised these results in a table:

Maths results

Mean

Mode

Median

Range

Females

4.06

4

4

2

Males

4.66

5

5

2

Stem and leaf diagrams

Year 9 Females

Stem

Leaf        

Frequency

0

1,6

2

1

0,4,4,6,7,7,8

7

2

1,1,2,4,4

5

3

9

1

4

Year 9 Males

Stem

Leaf        

Frequency

0

4,8

2

1

0,0,0.5,2

4

2

0,0,0,0,1,2

6

3

0,0

2

4

2

1

Averages

Hours of TV watched (hrs)

Mean

Modal class interval

Median

Range

Females

18

10-20

17

38

Males

19

20-30

20

38

From the Year 9 sample, the mean, modal class interval and median were higher for males than for females. The difference in values for these measures for males and females for my Year 9 sample was not too big.

The modal class interval shows that on average males watched more hours of TV yet scored higher grades in their maths results. The range for both males and females for the hours of TV watched was the same. This refutes my original hypothesis for my sample of students from Year 9.

...read more.

Conclusion

15 - 6.25

x 100

15

i.e.  

     = 58.3%

15 - 10

x 100

15

whereas                                        =33.3% of females achieved level 4 and above

                above

15 - 14

x 100

15

Only                                               =6.7% of the males achieved a level 6                

Review

I started with a hypothesis stating that the more time spent watching TV the less successful students would be in their KS2 maths results. Though this is a logical line of enquiry my analysis of the selected data refute this hypothesis.

It was difficult to establish any strong correlation from the scatter diagrams. I have a positive correlation from my scatter diagrams however the gradient of the line of best fit is small, indicating low positive correlation. This could be due to my data being secondary and group sample selective and small. Hence, my results maybe slightly biased.

Considering my analysis for my original selected group i.e. Year 9 and my hypothesis being refuted I extended my project and drew a scatter diagram for a random sample of 60, from the whole school.

Apart from a couple of results at the top of the level 5 column, which are also quite dispersed, I think I have a negative correlation for the overall data. The gradient in this case is more distinctively negative than it was for the first set of data. They are also opposite to each other i.e. the gradient for the line of best fit for Year 9 was positive, while the gradient for the overall group is negative, confirming my hypothesis.

- 25 -

...read more.

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

See related essaysSee related essays

Related AS and A Level Probability & Statistics essays

  1. Marked by a teacher

    The heights of 16-18 year old young adults varies between males and females. My ...

    5 star(s)

    (0.995) = 2.5758 ?� n-1 ( n ) S� n-1 = 50 x 9.0864 = 9.272 49 � = � x ? n-1 V n � = 64.56 � 2.5758 x 9.272� V 50 � = 64.56 � 2.5758 x V 9.272 7.071 � = 64.56 � 2.5758 x 3.045 7.071 � = 64.56 � 2.5758 x 0.431

  2. Marked by a teacher

    data handling

    3 star(s)

    Scatter Diagrams A scatter diagram tells you how closely two things are related, the term correlation. A Strong Correlation means the two things are closely related to each other. A Weak Correlation means there is very little relationship. The line of best fit is a line that roughly goes through the middle of the points.

  1. Data Handling - Planning - I intend to investigate the relationship between the number ...

    The average number of hours of TV watched per week, being continuous data, will be analysed by recording the results using histograms. Year 9 Females Hours of TV watched p/week Tally Frequency Midpoint 0 ? t ? 7 II 2 3.5 8 ?

  2. Original Writing: Dramatic Monologue - Monologue of a Disturbed Personality

    He would have gone straight to the management and told the he was suing them. But I have inherited my mothers 'easy going' nature to all situations in life. "Yes....the sample....just a small scratch of the skin on your face that's all."

  1. Investigate if there is any correlation between the GDP per capita ($) of a ...

    61.95 3.698970004 3837.803 13.68238 229.1512 73.52 4.146128036 5405.19 17.19038 304.8233 51.01 2.954242509 2602.02 8.727549 150.6959 62.2 3.301029996 3868.84 10.8968 205.3241 64.19 3.322219295 4120.356 11.03714 213.2533 69.29 3.662757832 4801.104 13.41579 253.7925 73.43 3.748188027 5391.965 14.04891 275.2294 77.38 3.397940009 5987.664 11.546 262.9326 78.11 4.041392685 6101.172 16.33285 315.6732 81.43 4.539076099 6630.845 20.60321 369.617

  2. Anthropometric Data

    as a dependent against the foot length (mm) as the independent variable. Knowing that (y) is a dependent of (x), as (x) is an independent foot breadth will be on the (y) axis and foot length will be on the (x) axis. Scatter graph A scatter it shows a relationship between two variables.

  1. "The lengths of lines are easier to guess than angles. Also, that year 11's ...

    In this formula, p is the Spearman's coefficient rank of correlation; d is the difference between one item of data and n is the number of items of data. So, for the year nine pieces of data, ?d� = 12.25 and n = 27, so: 1 - 6 x 3494.25

  2. Teenagers and Computers Data And Statistics Project

    The formula for this was n3 - (n-2)3 - 6[(n-2)2 - 8. I then realized there should be a much simpler formula. Once I took another look at the table I realized it would be 12(n-2).This was because there are 12 edges on a cube and as there are -1

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