X hits on this document

48 views

0 shares

0 downloads

0 comments

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.

As your data has already been randomised you simply need to return to this and take the first 30 from each group.

Anomalies

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.

Document info
Document views48
Page views48
Page last viewedThu Dec 08 09:59:17 UTC 2016
Pages12
Paragraphs319
Words2772

Comments