Create the Mode for a group of values according to value in column A

[Plaaskind]

I need to calculate multiple means depending on the qualification codes. I have an example where I did it manually, but it is a lot of data that needs to be processed and there must be and easier way. Currently I'm using the following to calculate the mean: =+MODE($B$3:$B$12), but I need to do that grouping according to the groupings in the Qual column. Please assist.

Qual.	Level 1	Mean Level 1	Validation 1
1DU	132	132	OK
1GB	120	120	OK
1GB	120	120	OK
1GB	120	120	OK
1GB	120	120	OK
1GB	120	120	OK
1GB	120	120	OK
1GB	120	120	OK
1GB	120	120	OK
1GB	132	120	Alignment needed
1GB	132	120	Alignment needed
1GC	120	120	OK
1GC	120	120	OK
1GC	120	120	OK
1GD	128	128	OK
1GE	132	120	Alignment needed
1GE	132	120	Alignment needed
1GE	112	120	Alignment needed
1GE	112	120	Alignment needed
1GE	120	120	OK
1GE	120	120	OK
1GE	120	120	OK
1GE	120	120	OK
1GE	120	120	OK
1GE	120	120	OK
1GE	120	120	OK

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>