Little_Louis
New member
- Joined
- Mar 26, 2022
- Messages
- 15
Hello this is my first post - thank you for your help in advance. I recently completed an online test. This was one of the questions and it baffled me. I have attempted to recreate the question in excel. Please can you help.
The Test Problem
113 students are enrolled on a course of 24 lectures:

x axis = absences, y axis = count
How many of the following can be deduced just from the data in the chart
I then quickly calculated what I thought was the mean given the graph. I got a mean of 3.14 using my own figures as per my table below.
I then looked at the options 1 to 4 and thought 'I don't think any of those are correct'. However the answer must be a number between 1 and 4 correct options.
The Test Problem
113 students are enrolled on a course of 24 lectures:
- Fifteen students attended all lectures
- 98 were absent for between 1 and 12 of the lectures

x axis = absences, y axis = count
How many of the following can be deduced just from the data in the chart
- The mean number of absences per student was 6
- At least half the lectures did not have full attendance
- The most frequent number of students attending a lecture was 91
- One lecture was attended by only 15 students
I then quickly calculated what I thought was the mean given the graph. I got a mean of 3.14 using my own figures as per my table below.
| Absence | Frequency |
| 0 | 15 |
| 1 | 16 |
| 2 | 20 |
| 3 | 21 |
| 4 | 16 |
| 5 | 9 |
| 6 | 6 |
| 7 | 3 |
| 8 | 2 |
| 9 | 1 |
| 10 | 1 |
| 11 | 1 |
| 12 | 2 |
I then looked at the options 1 to 4 and thought 'I don't think any of those are correct'. However the answer must be a number between 1 and 4 correct options.