Counting Question, thank you

[thankyou]

Hi, hope you're doing great today.

In column B, I have # of events, like this:

[TABLE="width: 65"]
<tbody>[TR]
[TD]2[/TD]
[/TR]
[TR]
[TD]1[/TD]
[/TR]
[TR]
[TD]1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[/TR]
[TR]
[TD]1[/TD]
[/TR]
[TR]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]

In column C, I have Day number of week, eg:

[TABLE="width: 106"]
<tbody>[TR]
[TD]4 (which is Wed)[/TD]
[/TR]
[TR]
[TD]5[/TD]
[/TR]
[TR]
[TD]6[/TD]
[/TR]
[TR]
[TD]7[/TD]
[/TR]
[TR]
[TD]1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]

In column D, I have (if needed), the actual weekday name (eg TUE, etc)

Here's where I need your help, please:

I want to make a table (results in H2 thru M5), like this:

[TABLE="width: 468"]
<tbody>[TR]
[TD][/TD]
[TD]MON[/TD]
[TD]TUE[/TD]
[TD]WED[/TD]
[TD]TH[/TD]
[TD]FR[/TD]
[TD]SAT[/TD]
[/TR]
[TR]
[TD]AVERAGE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MODE1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MODE2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MEDIAN[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

So, if possible, I'd like the formulas ideally, for my learning stage, that will go into H2 thru M5 for my output table.
Thank you very much for your help and time, which I truly value and appreciate. If can't do formulas I can try arrays, but I always forget when I go back into edit, and end up hitting Enter instead of CSE.
(oh, by "mode2", i mean 2nd most frequent occurrence from column B which is the data I'm hoping to analyze).

thank you so much!

 

[Blade Hunter]

First one is AverageIf

Others will be array formulas.

 

[thankyou]

BH, I'm looking for a different type of answer, thanks though.