Instructions
Calculate the average, minimum and maximum rating in each group:
- Select the value Group in the Row labels input.
- Leave the Column labels input empty.
- Remove the value Group and select the value Average rating in the Calculated column input.
- Select the value Average in the Operation type input.
- Add the value Max in the Operation type input.
- Add the value Min in the Operation type input.
- Click the
icon and Save changes.
80 %
Training table
Student's progress sheet
| Student | Group | Average rating | Admission to the exam |
|---|---|---|---|
| Diana Lyndon | Group 1 | 7 |  |
| Quin Rich | Group 3 | 5 | |
| Clint Pamila | Group 2 | 8 |  |
| Andy Asia | Group 1 | 4 | |
| Primula Linnie | Group 3 | 9 | |
| Leith Eireann | Group 2 | 6 | |
| Mary Saxon | Group 1 | 8 | |
| Robina Cletis | Group 3 | 5 | |
| Allyn Arlo | Group 1 | 10 | |
| Dave Bertie | Group 3 | 9 | |
| Matty Lowell | Group 2 | 10 | |
| Sheridan Anselm | Group 2 | 6 | |
| Kemp Emmet | Group 2 | 8 | |
| Sarah Milly | Group 1 | 9 | |
| Anna Kassy | Group 2 | 7 | |