x Turn on thread page Beta
 You are Here: Home >< Maths

# Data analysis help needed! watch

1. Hi,
I wonder if someone can help me. I have some results from a survey and I'm unsure how to analyse them.

I would like to rank the courses by the number of enrolled students, but as you can see, some courses have run more than once which means the number of enrolled students will of course be higher.

What method should I use so that the ranking by number of enrolled students takes into account the number of times the course has run (baring in mind that if a course has run more than once, the number of enrolled students in each session won't be equal)?

I've attached an image of my data.

Thanks very much for your help
Attached Images

2. (Original post by Cazmac)
Hi,
...
Why not number of enrolled students/number of times run to get an average for how many students enrolled in one session of the course?
3. (Original post by Zacken)
Why not number of enrolled students/number of times run to get an average for how many students enrolled in one session of the course?
Thanks for your reply. My only concern with the method you suggest is that, in some cases, the majority of students may have enrolled in the first session and only a limited number in subsequent sessions which means the overall ranking would be unfair.

Any other suggestions would be very welcome
4. (Original post by Cazmac)
Thanks for your reply. My only concern with the method you suggest is that, in some cases, the majority of students may have enrolled in the first session and only a limited number in subsequent sessions which means the overall ranking would be unfair.

Any other suggestions would be very welcome
Zacken's answer is correct. Your concern is a potential limitation of the actual study, not something that can be fixed by data analys. Unless you know what the actual average attendance was, you cannot fix it. It also shouldn't confound your analysis unless the attrition rate differs across courses.
5. (Original post by chazwomaq)
Zacken's answer is correct. Your concern is a potential limitation of the actual study, not something that can be fixed by data analys. Unless you know what the actual average attendance was, you cannot fix it. It also shouldn't confound your analysis unless the attrition rate differs across courses.
OK thanks. I will go with Zacken's and your suggestions then.
Thank you both for your help

TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

This forum is supported by:
Updated: January 19, 2016
Today on TSR

### Loughborough better than Cambridge

Loughborough at number one

Poll
Useful resources

### Maths Forum posting guidelines

Not sure where to post? Read the updated guidelines here

### How to use LaTex

Writing equations the easy way

### Study habits of A* students

Top tips from students who have already aced their exams