Counting Question, thank you

[thankyou]

Hi, hope you're doing great today.

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

2

1

1

2

1

4

<tbody>
</tbody>

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

4 (which is Wed)

5

6

7

1

2

<tbody>
</tbody>

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:

	MON	TUE	WED	TH	FR	SAT
AVERAGE
MODE1
MODE2
MEDIAN

<tbody>
</tbody>

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.