1,708
19
Essay, 16 pages (4000 words)

The average pupil essay

The aim of this study is to find the statistics for the average school pupil.

This will be achieved by looking at the results of a survey carried out at Jordan Hill comprehensive. Hypotheses: How the education system has changed in its efficiency, over four years. The weight of a pupil will increase with the amount of television watched per week. The hair colour of a pupil will affect their IQ. How I will achieve this? This will be achieved by using samples of the given material.

Specifically a sample of 50 people will be used for the first hypothesis, and then a sample of 30 will be used for the next two hypotheses, as to not be too time consuming. I will be using a stratified sample for the first hypothesis, and then a random sample from that point forward. Why am I using Stratified and Random sampling to acquire my sample? From studying the data sheets I have decided to use a stratified sample. I have chosen this method because it would appear to be the most efficient method of sampling in order to tackle this amount of data, and I feel that the sample is plenty large enough for the results to be significant.

I have also chosen a random sample because it cannot become bias, if some strata are larger than others. This is also because gender, or age will not affect the two last hypotheses. It will also provide me with something to compare the sampling methods with in the conclusion, and give a broader sample of the entire school, as opposed to just year 7’s, or year 11’s. Both are perfectly viable methods, as opposed to systematic or attribute sampling.

How I will display my data? I will display my data in a range of ways. These will include scatter graphs, histograms, cumulative frequency graphs, bar charts and box plots. These will allow me to investigate the spread of the data in an ordered manner. When I have to solve the hypotheses, I will outline the relevant hypothesis and then I will make a list of the pupil’s names and their scores in the areas connected to the hypothesis (only for the last two). I will then examine the data, and compare it with the use of charts.

Finally I will come to a conclusion by combining all the gathered data from all my hypotheses and I will answer the question, what is the average child. How I will deal with problems I may come acrossDuring my investigation there are a number of problems I may encounter, be these with my data collection or an unprecedented solution to a sum. Therefore, I must plan ahead and create some solutions to these possible dilemmas. I will therefore create a problems/solutions table in order to help me during any difficult moments within the investigation. ProblemPossible cause of problemSolutionI have a large amount of data, which consists of a mass of numbers (i. e.

the students I. Q) how should I deal with this? The data I am looking at has an answer that is not a set answer. This is continuous data, and means that the data could be anything. I should group my data. I should then place the data in a group that is appropriate for it. When I try and draw my results in a table, there is no correlation between the resultsThis is possibly due to me plotting the results wrongly, or that there is no natural correlation between your results.

Firstly I should try to plot the results again, and if there is still no correlation between the results then it’s safe to assume that there is no natural link between my results. Two or more numbers are the same when I use a random sampleThe random number generator (excel) has chosen two or more numbers at random that happen to be the sameI should discard the numbers, and continue with picking the random sample, as without it. Just this small amount of data, in the above table, should be able to help me anticipate and deal with any real problems I may encounter. Collected DataI will collect my data using stratified and random sampling; this should allow me to create a fair sample of people effectively with relative ease. I have included below the process I will use to collect my samples: 1. Open “ Microsoft Excel XP edition” and open the Jordan Hill 2 file, located in the maths GCSE file within the resources folder.

2. Every name should already be assigned a number; I will use these numbers when picking my stratified sample. However, when I use a random sample, I will create a new column titled random. Then I shall type in “= rand()*1184” then press f9, drag the box down the length of the data. Then sort the data in ascending order.

I will pick the first 30 as my random pupils. 3. Generally I am going to use continuous data, which should help me create graphs and presentational devices with increased ease, and when numbers are involved it makes graphs and such, much clearer and creating figures much more accurate. In hypothesis 3 however, I have included hair colour, as one of the variables. This is non-continuous data, and will prove that I can work with that just as well. Hypothesis 1: How the education system has changed in its efficiency, over four years.

Within this initial investigation I intend to go about discovering how the education system has changed in its efficiency over 4 years, by taking the Key Stage 2 results of the year 11’s, and then displaying is various graphs, and tables, and then compare it to the Key Stage 2 results of the Year 7’s, of whom most are nearly exactly four years younger, therefore the school system is four years older and wiser, and should be able to produce better grades from the children. I will take a stratified sample of 50 children from each year group of mixed gender, but as I am using a stratified sample, for year 7’s, if there were 60% girls to 40% boys, then obviously, I would have to put in 30 girls and 20 boys, out of 50, (60% of 50, and 40% of 50, respectively). Then I will do the same for year 11 and see what I find out using a mixture of histograms, box plots and scatter diagrams. Initially I shall start off with the year 7’s. Girls = 131/282= 46.

50%Boys = 151/282= 53. 50%This table shows that there are 131 girls and 151 boys within the total of 282 of year 7 pupils. This means that I will have to use these percentages within my rather reduced sample of 50 children. That means that within my sample there must be 23 girls, and 27 boys. I will sort data within excel, for each gender, and choose the top 23 random girls, and top 27 random boys.

Then I will create a total for each student selected within the sample for a total Ks2 mark for the student. Then put each student into different groups according to their total mark. This data set will then be used to create a histogram. RangeClass widthFrequencyFrequency density0

310

There are very few students who obtained less than a total of 10 for their key stage 2 results. The general shape of the histogram is to be expected, with a few people who achieve the high scores, and who score the low ones, whereas the majority lay somewhere in the middle. I could also show the results in a cumulative frequency graph, by calculating the highest and lowest cumulative frequencies myself to give me a pair of boundaries, and then letting excel calculate the 3 quartiles to be able to draw the graph. In order to do this, you must type in “= quartile(range),(1, 2, or 3, depending on which quartile you want measuring)”. GroupsFrequencyCum Freq0; total mark; 103315; total mark; 20750In the cumulative frequency graph, you can see that the key stage two results of the students has a symmetrical distribution, as the median is exactly in the middle, of the lower and upper quartiles. This means that the majority of students lay somewhere in the middle of the class.

A box plot can further prove this. Finally, I could display my sample in a box plot form, as follows: Minimum: – 8Lower Quartile: – 12Median: – 13Upper Quartile: – 14Maximum: – 16Inter quartile range (IQR): – 2I will remark on the distributions from the box plots, after I have devised one for the year 11 group. (See page 6)Now I am going to investigate the equivalent, but for the year 11’s. Girls = 86/170= 50.

60%Boys = 84/170= 49. 40%This table shows that there are 86 girls and 84 boys within the total of 170 of year 11 pupils. This means that I will have to use these percentages within my rather reduced sample of 50 children. That means that within my sample there must be 25 girls, and 25 boys.

I will sort data within excel, for each gender, and choose the top 25 random girls, and top 25 random boys. Then I will create a total for each student selected within the sample for a total Ks2 mark for the student. Then put each student into different groups according to their total mark. This data set will then be used to create a histogram. RangeClass widthFrequencyFrequency density0

313

A box plot can further prove this. Finally, I could display my sample in a box plot form again, but I will pitch it onto the same axes as the box plot displaying the year 7’s distributions, so that I can compare them both much better. Minimum: – 9Lower Quartile: – 12Median: – 13Upper Quartile: – 14Maximum: – 18Inter quartile range (IQR): – 2The box plot has an outcome exactly the same to the one I had previously predicted. The middle half of the class, are exactly the same for both years.

There are just one or two pupils that are dragging the minimum mark down for the year 7’s, and a few high achievers pushing the side up for the year 11’s. Looking at the general range, the marks are lower for year 7’s, than year 11’s. SummaryBefore I summarise this section, I must first recap the hypothesis: How the education system has changed in its efficiency, over four years. Using the above data and my graphs that I have created on other sheets, I can conclude that the education system has changed over four years. It would appear that the education system has declined in its efficiency over the four years.

I have come to this decision using all my graphs and data boxes. This may not be true for the entirety of the two year groups, as a sample of 50 people, only gives us a slight insight into the actual size of the year groups. The education system may have infact improved over the four years; however, my investigation has proved that it did not. If I had to do this hypothesis again, then I would require the whole year group, and perhaps even from a different school(s) as the year 11 from Jordan Hill may have been a relatively unproductive year group, then perhaps I would be able to get a true idea of how the education system changed over the time span.

Random sampling: From this point forward I will be using a random sample. I have acquired this random sample through excel, and here is a list of all the names of the students, I used accompanied by the relevant information I need. Surname1st Name2nd NameHair colourTv hoursIQWeight (KG)GuzmanVictoriaLouiseBlack1411265GorstFrancescaRed159150JasonCarenBrown811653TaylorBethanyJaneBrown18-48ReadLouiseEmmaHoney/blonde147948MartinToddBlack308852JagsPhilFair1210268MurphyStaceyAnnBrown1010654BodmanMikealChristopherBrown87238JervisPeterWilliamBlack1410340JusticeTonyPhilipBlack249860VictoriaCarolAprilBlack168855AndrewsJohnBlonde2010145BigglesworthWayneGregoryBrown149166CasselDianeBrown51146IngletonElizabethSarahBrown2011437FriendAaron CarlBlonde2010260HuntGarethBarryBrown310262BhattiSadiaBlack99448AshcroftWaynePaulBrown2310837MevineGaryClarkBlack1510450KhanAdilaBlack1412048SayersBenBlonde1010140BlackMiaSarahBrown1410357ThompsonKamaraPaulaBrown68942HardyRhysBlack149045MaddenBenBlonde1010647VegetaGokuKrillainBlack6510935McAtherDougieDavidBlue17010160LargeStephenDanielBrown1210326Hypothesis 2: The weight of a pupil will increase with the amount of television watched per week. This hypothesis uses two sets of data (weight and amount of television watched per week) that can be grouped.

This will allow me to accurately compare the two sets of data, and I should therefore be without any problems. After I have compared the sets of data I have ascertained, I should be able to accurately find out whether, or not there is any correlation between the two sets of data. I will start by comparing histograms for both sets of data; Initially, the table for weightWeight (kg)FrequencyClass widthFrequency density0

860

Now I will draw the frequency density table for the number of hours of television watched per week. Tele hoursFrequencyClass widthFrequency density0

01The graph is quite disappointing because, of the last figure it has, misshapen the scale somewhat, and produced, an almost useless graph, however I still realised that the histogram appears to have a large number of pupils who watch less than 30 hours of television per week. This graph has no correlation with the graph for weight and is therefore quite worrying, as there seems to be no connection between the amount of television watched by the students and their weight. Before I come to a conclusion however, I must study my results in more detail. Next, I will be using a cumulative frequency graph to look at my results in a different light, and be able to draw a box plot (without using excel). Weight (kg)FrequencyCumulative frequency20

If you look at the graph, it clearly shows a steady rise in the weight of the pupils. This tells me that this graph is symmetrical, however this can only be determined with the use of a box plot. Here is the data required in order to draw a box plot. Minimum: – 26Lower quartile: – 41Median: – 47. 5Upper quartile: – 55Maximum: – 68Interquartile range: – 14If you then, look at the relevant box plot I have produced, in my graph booklet, it shows that my beliefs were correct, in that the data set is symmetrical when put into graph form. I can determine this through the fact that the median appears to be directly in between the upper, and lower quartiles, therefore showing that this graph is definitely symmetrical.

There is however, a small negative lean with the graph with it facing in the direction that there must more pupils in my sample that weigh over 40 kg, than under it. Now I will do exactly the same, but for TV hours watched. TV hours watched per weekFrequencyCum freq0

I will continue to investigate this hypothesis however, as there might be some correlation between the data. Here is the relevant data needed in order to draw my box plot. Minimum: – 3Lower quartile: – 9Median: – 13Upper quartile: – 16Maximum: – 170Interquartile range: – 7I have drawn my box plot (refer to graphs booklet) and I have found that the amount of hours of television watched per week by each student definitely has a positive skew. We can tell this as the lower quartile, median and upper quartiles are all ‘ bunched’ together on the left-hand side of the box plot. This is a definite sign of a positive skew as they are all at the start of the graph. Using this I can say that a majority of the students in my students in my sample watch less than 20 hours of television per week.

I will now look at the mean average for each of the different sets of data I am analysing, weight and number of hours of television watched per week; Weight (kg)FrequencyMid-interval valueFrequency x mid-interval0

5Mean = (frequency x midinterval) / frequency = 1434. 5/30 = 47. 8Tele hoursFrequencyMid-interval valueFrequency x mid-interval0

576. 530

570

5By looking at the results of these two tables I can conclude that there is no correlation between the two sets of data. This is quite disappointing as I was expecting the students weight to increase along with the amount of hours of television watched per week. Looking at the median, mode and standard deviation of the data, as well as studying the scatter graph I have created in my graphs booklet, I can back up the results of my findings. Distributions are usually compared using measures of spread and central tendency. Standard deviation is a measure of spread that calculates the average deviation of all values from the mean. Weight Television hours watchedIQR = 14 IQR = 7Median = 15.

5 = 40

The scatter graph I have drawn from the first 10 pupils from my list (see just before the start of this hypothesis) also shows me that there is no correlation between the data. It would’ve been the easiest way of showing if it did, but it obviously didn’t because if there were then they would appear to be in a straight line or curve, with only a few outliners. In this case there are several outliners, and the line of best fit only serves to show the direction in which the plots should have gone if there was to be any correlation between the two sets of data. SummaryBefore I summarise this hypothesis, I think I should firstly look back and see what I initially predicted: The weight of a pupil will increase with the amount of television watched per week, After using all the data I have acquired on the two statistics I have come to the conclusion that there is no correlation between the two sets of data. This means that no matter how many hours of television are watched per week per student it will have no effect on their weight. This may not be true for the entire population however, as a sample of 30 people only gives me a slight insight into the actual size of the entire population.

The amount of hours of television watched per week could indeed have an effect on a students weight in kilograms, however in my sample I have proved that it did not. If I were to investigate this hypothesis again, then I would require a larger sample size in order for my investigation to be effective. This sample size would have to be in the region of 150 to 300 as I fell that a sample this big would truly reflect the actual size of the entire populationHypothesis 3: the hair colour of a pupil will affect their I. Q.

T o investigate this I have drawn a series of graphs, in order to compare the hair colour and I. Q. of the students in my sample. However, with the hair colour of the pupils there was very little I could do apart from draw a bar graph for the different hair colours and the mode average. The bar graph can be found in my graphs booklet, and the mode average is shown below. The graph shows me the number of students with varying types of hair colour.

As you can see, more pupils have brown hair rather than black hair whereas only 2 pupils have a hair colour other than brown, black or blonde. Mode = BrownA bar chart is the only reasonable way I can display the hair colour of the students. Below is the sampled data, I have analysed and a graph accompanies it (in the graph booklet) for the pupil’s I. Q.

I did not have any problems with this data, and it is therefore displayed in the form of a histogram and a cumulative frequency graph, among others. I. QFrequencyClass widthFrequency density0; I. Q; 802800.

02580; I. Q; 904100. 490; I. Q; 1004100. 4100; I.

Q; 11014101. 4110; I. Q; 1204100. 4The histogram itself (which can be found in the graph booklet) shows me that the majority of the students had an I. Q ranging between 100-110.

A small minority of the students had an I. Q below 80. After constructing a histogram for my data, I will then created a cumulative frequency graph in order to examine the trend the I. Q took and find the interquartile range of my data. Here is the relevant data to the cumulative frequency graph. I.

QFrequencyCumulative frequency70; I. Q; 802280; I. Q; 904690; I. Q; 100410100; I. Q; 1101424110; I. Q; 120428You can find the graph, in my graph booklet and if I study it, I can see that the graph shows the I.

Q of the pupils has a skewed negative distribution, as the median is closer to the upper quartile then it is the lower quartile. This means that there is a noticeable amount of students with a high I. Q in my sample. A box plot of the graph can further prove that the data has a negative distribution. Minimum: – 72Lower quartile: – 94Median: – 104Upper quartile: – 109Maximum: – 120Interquartile range: – 7Within the above data, I compiled to be able to draw a box plot; the minimum for my data set for I. Q was actually 11.

I regard this particular statistic as an anomaly, as I believe that nobody could achieve 11 as an I. Q, as it is very unrealistic. Studying the box plot (included in the graphs booklet) in more detail I can quite clearly see that the I. Q of the pupils clearly has a negative skew distribution. We can tell this, as the median is noticeably closer to the upper quartile, than the lower quartile.

Using this knowledge I can safely say that the median average I. Q of the students is higher than the mean average I. Q. However, as I can only compare the I. Q with the I.

Q with the hair colour through the modal average this makes the median and mean, although interesting, totally and utterly useless, when it comes to coming the hair colour of the students with their I. Q. SummaryBefore I summarise this question, I must first re-cap the hypothesis: The hair colour of a pupil will affect their I. Q.

Using all of the above data, plus my graphs in the graph booklet, I can conclude that hair colour does have some effect on the I. Q of a student. Comparing the two separate modes can show this: Hair colour: BrownI. Q 100 -110There were 12 people in my sample who had brown hair. There were 14 people in my sample who had an I. Q between 100 and 110.

This means that there must be some connection between hair colour and I. Q as both of these numbers are just under 50% of the total data collected in my sample. Of course, this conclusion may not be true for the entire population of students in the data, as my sample is not big enough to reflect the whole population. However, my sample size is big enough to give a small insight into what could be the case in the entire student population. My conclusion that students with brown hair will have an I.

Q between 100 and 110 is justified in my sample as ahs been proven by my use of several different methods in order to analyse the data I have got. In my sample of the I. Q there was only 28 valid results when I collected a sample of 30 (as can be seen in cumulative frequency chart). One result was an I.

Q of 11. This, as I have already stated, I do not believe to be possible as someone with an I. Q score this low would be allowed to attend any sort of school! The other anomaly was that someone didn’t even have an I. Q score.

These anomalies in my data can both be 1 of 2 things. Firstly, that they are simple mistakes on the spreadsheet of data, or secondly, that they are mistakes made during the marking of the I. Q test. I believe however, that they are mistakes made during the writing of the spreadsheet and that they have no real reflect on the data at all.

If I were to investigate this hypothesis again, I would take a sample of at least 200 people, and maybe even students from a different school, or area to, 1. Discover whether any environmental aspects may affect their results, 2. See if there were any differences perhaps in teaching technique, and 3. To allow me to get an accurate view of the population as a whole. This would also allow me to develop an accurate conclusion, and truly find out if a students hair colour affects their I. Q.

Another method I would use would be to group the data acquired on hair colour by order of spectrum. This would allow me to make a cumulative frequency graph for the data, and would thereby allow me to find such things as the standard deviation and distribution for the students hair colour, as it would then be classed as continuous data. ConclusionFinally, I must look at the original point of this investigation: Describe an average school pupilUsing the results I have acquired from my hypothesis, I am able to state that the average school pupil should have: Brown hair, An I. Q of between 100 and 110, And it was clear to see that the education system has significantly decreased in efficiency in regards to teacher/pupil ability over four years. These results cannot be looked upon as definite however, as my sample (displayed just before the start of hypothesis 2) was not big enough to examine the entire population. To do this I would have needed a sample of at least 300 students, and therefore an awful lot of time.

I found that when I changed to use random sampling as opposed to stratified sampling, the whole process became much easier, with no time wasted working out the correct proportions to make my particular accurate in relation to the raw data. The random sampling was easier, just to create a random sample of students and use them, and it really did eliminate any bias strata, however I am glad that I did use stratified sampling for one of my sample because it has me an insight of using it, and also has given me something to compare the random sampling against. If I were to do this again, then I would examine my hypotheses in greater detail, as I would group the colours in my statistics in the order of the spectrum. This would allow further investigation and therefore a more in-depth comparison. My use of cumulative frequency graphs really helped as well, as these allowed me to make comparisons between my data such as finding the median, using box plots to discover the distribution and allowing me to discover the IQR for the data through the usage of quartiles. Most of my credit has to go to Excel though, as it was most useful during all of my tabulated and graphical representations, along with the calculations I needed.

Thank's for Your Vote!
The average pupil essay. Page 1
The average pupil essay. Page 2
The average pupil essay. Page 3
The average pupil essay. Page 4
The average pupil essay. Page 5
The average pupil essay. Page 6
The average pupil essay. Page 7
The average pupil essay. Page 8
The average pupil essay. Page 9

This work, titled "The average pupil essay" was written and willingly shared by a fellow student. This sample can be utilized as a research and reference resource to aid in the writing of your own work. Any use of the work that does not include an appropriate citation is banned.

If you are the owner of this work and don’t want it to be published on AssignBuster, request its removal.

Request Removal
Cite this Essay

References

AssignBuster. (2022) 'The average pupil essay'. 29 September.

Reference

AssignBuster. (2022, September 29). The average pupil essay. Retrieved from https://assignbuster.com/the-average-pupil-essay/

References

AssignBuster. 2022. "The average pupil essay." September 29, 2022. https://assignbuster.com/the-average-pupil-essay/.

1. AssignBuster. "The average pupil essay." September 29, 2022. https://assignbuster.com/the-average-pupil-essay/.


Bibliography


AssignBuster. "The average pupil essay." September 29, 2022. https://assignbuster.com/the-average-pupil-essay/.

Work Cited

"The average pupil essay." AssignBuster, 29 Sept. 2022, assignbuster.com/the-average-pupil-essay/.

Get in Touch

Please, let us know if you have any ideas on improving The average pupil essay, or our service. We will be happy to hear what you think: [email protected]