X hits on this document

54 views

0 shares

5 / 12

To Calculate Correlation Coefficient in Excel:

1.

Select a blank cell in the spreadsheet

2.

Click on fx on the tool bar

3.

Select Statistical in the function category

4.

Select Correl in the function name and then click ok

5.

In Array 1 highlight the heights

6.

Click in Array 2 and highlight all the weights

7.

Click ok

###### Part 2 – The Main Study

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.

###### Sampling

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.