Select a blank cell in the spreadsheet
Click on fx on the tool bar
Select Statistical in the function category
Select Correl in the function name and then click ok
In Array 1 highlight the heights
Click in Array 2 and highlight all the weights
Based on the results of your pilot study, you should have a line of enquiry to investigate further and should refine your hypotheses to include how you think age and gender will affect results.
E.g.Hypothesis 1 – The taller you are the heavier you are. The relationship between the two will become stronger as you get older.
Hypothesis 2 – Boys are taller and heavier than girls. The difference
between boys and girls will increase as the students get older.
For your main study you will deal with each of the 10 groups in the school separately to make comparisons across year groups and gender. To do this you will need larger samples from each group. 30 students from each group should be enough to perform statistical calculations on.
As your data has already been randomised you simply need to return to this and take the first 30 from each group.
Once you have taken your sample, you may notice anomalies (extreme values in your data, like someone who is 4.65m tall or 5kg in weight). These anomalies may be outliers (i.e. results differing greatly from others in the same sample). You should test for these outliers and then decide how to deal with them (leave them in or replace them). Keep your graphs from before and after.