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.

[TABLE="class: grid, width: 421, align: left"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Qual.[/TD]
[TD]Level 1[/TD]
[TD]Mean Level 1[/TD]
[TD]Validation 1[/TD]
[/TR]
[TR]
[TD]1DU[/TD]
[TD="align: right"]132[/TD]
[TD="align: right"]132[/TD]
[TD]OK[/TD]
[/TR]
[TR]
[TD]1GB[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]120[/TD]
[TD]OK[/TD]
[/TR]
[TR]
[TD]1GB[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]120[/TD]
[TD]OK[/TD]
[/TR]
[TR]
[TD]1GB[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]120[/TD]
[TD]OK[/TD]
[/TR]
[TR]
[TD]1GB[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]120[/TD]
[TD]OK[/TD]
[/TR]
[TR]
[TD]1GB[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]120[/TD]
[TD]OK[/TD]
[/TR]
[TR]
[TD]1GB[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]120[/TD]
[TD]OK[/TD]
[/TR]
[TR]
[TD]1GB[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]120[/TD]
[TD]OK[/TD]
[/TR]
[TR]
[TD]1GB[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]120[/TD]
[TD]OK[/TD]
[/TR]
[TR]
[TD]1GB[/TD]
[TD="align: right"]132[/TD]
[TD="align: right"]120[/TD]
[TD]Alignment needed[/TD]
[/TR]
[TR]
[TD]1GB[/TD]
[TD="align: right"]132[/TD]
[TD="align: right"]120[/TD]
[TD]Alignment needed[/TD]
[/TR]
[TR]
[TD]1GC[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]120[/TD]
[TD]OK[/TD]
[/TR]
[TR]
[TD]1GC[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]120[/TD]
[TD]OK[/TD]
[/TR]
[TR]
[TD]1GC[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]120[/TD]
[TD]OK[/TD]
[/TR]
[TR]
[TD]1GD[/TD]
[TD="align: right"]128[/TD]
[TD="align: right"]128[/TD]
[TD]OK[/TD]
[/TR]
[TR]
[TD]1GE[/TD]
[TD="align: right"]132[/TD]
[TD="align: right"]120[/TD]
[TD]Alignment needed[/TD]
[/TR]
[TR]
[TD]1GE[/TD]
[TD="align: right"]132[/TD]
[TD="align: right"]120[/TD]
[TD]Alignment needed[/TD]
[/TR]
[TR]
[TD]1GE[/TD]
[TD="align: right"]112[/TD]
[TD="align: right"]120[/TD]
[TD]Alignment needed[/TD]
[/TR]
[TR]
[TD]1GE[/TD]
[TD="align: right"]112[/TD]
[TD="align: right"]120[/TD]
[TD]Alignment needed[/TD]
[/TR]
[TR]
[TD]1GE[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]120[/TD]
[TD]OK[/TD]
[/TR]
[TR]
[TD]1GE[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]120[/TD]
[TD]OK[/TD]
[/TR]
[TR]
[TD]1GE[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]120[/TD]
[TD]OK[/TD]
[/TR]
[TR]
[TD]1GE[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]120[/TD]
[TD]OK[/TD]
[/TR]
[TR]
[TD]1GE[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]120[/TD]
[TD]OK[/TD]
[/TR]
[TR]
[TD]1GE[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]120[/TD]
[TD]OK[/TD]
[/TR]
[TR]
[TD]1GE[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]120[/TD]
[TD]OK[/TD]
[/TR]
</tbody>[/TABLE]