Help - can you test my data for a correllation?

#1
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
 

Attachments