#4682B4#FFFFFF2#4682B4Instructions

Calculate the average, minimum and maximum rating in each group:

  1. Select the value Group in the Row labels input.
  2. Leave the Column labels input empty.
  3. Remove the value Group and select the value Average rating in the Calculated column input.
  4. Select the value Average in the Operation type input.
  5. Add the value Max in the Operation type input.
  6. Add the value Min in the Operation type input.
  7. Click the  icon and Save changes.


80

#4682B4#FFFFFF2#4682B4Training table

Student's progress sheet

1, truem/d/yyPoint (.)1536909867910_1524176168Count ⇩5|8|w d h m|w d h mCount3v
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