Stats functions - testing hypothesis and correllations

[asylum]

Hi,

I have the below data which shows the comlaince rates and grade bandings for 26 different audits carried out.

the date range over which each audit was carried out has been given a weighted score.

I have a hypothesis that the lighter the weighting the more likey you are to get a 'good' but the heavier the weighting the more likely you are to get a 'requires improvement'. (theory being results are worse in busy periods) I have no idea how to approach doing this. I will need to re-do it as the next 20 audit results are revealed over the next year or so.

Could anyone show me how to test this so that I can know if the hypothesis holds true now and that i can repeat it as i get more data?

Many thanks,

Regards

Andy

Banding comlinance Date Score (weighted)
Good 90.2 12
Requires Improvement 92.72 13
Good 91.02 13
Requires Improvement 89.56 13
Requires Improvement 87.2 13
Indequate 84.3 13
Indequate 81.52 13
Good 91.5 16
Requires Improvement 88.3 16
Indequate 85.49 16
Good 94.59 21
Good 90.9 21
Indequate 80.4 21
Indequate 80.1 21
Indequate 75.8 21
Good 89.5 26
Requires Improvement 87.8 26
Indequate 84.16 26
Requires Improvement 85.7 29
Indequate 83.8 29
Indequate 83.6 29
Indequate 83.6 29
Indequate 81.17 29
Requires Improvement 89.5 29
Requires Improvement 90.4 29
Indequate 83.4 30