Hi, hope you're doing great today.

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

2
1
1
2
1
4

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

4 (which is Wed)
5
6
7
1
2

In column D, I have (if even 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), analyzing the data in column B, with output like this:

MON TUE WED TH FR SAT
AVERAGE (H2)
MODE1
MODE2
MEDIAN M5


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).

Thanks