repeat a formula each 16 times and do median of them

[dylan nico]

I have a following structure:
predictions, truth
1,1
1,0
1,1
1,2
1,0
... 16 times
0,0
0,0
0,1
0,0
... 16 times
.
.
.

I need to compute this formula for each 16 times and then do the median between all of them:
the formula is: equal_values/16, where equal_values are the values of the predictions which are equal to the values of truth.
Then, I need to do the median of all of them.
In the example above, the first 16 pairs returns 2/16. The second 16 pairs returns 3/16. Then the median of these two values.

Below an image that give. the idea. Thanks to all for the responses.

 

[KRice]

I'm not sure I follow completely, but have a look at this to see if it does what you want. I've introduced helper column to identify the groups of 16 (called "Series"), and then tabulated intermediate results in case you want to confirm the answers.

MrExcel_20220826.xlsx
	A	B	C	D	E	F	G
1	Prediction	Truth	Series
2	0	2	1		Median	6
3	1	0	1
4	1	1	1		Series	Count Pred=Truth
5	0	0	1		1	4	4/16
6	2	2	1		2	8	8/16
7	0	1	1
8	0	1	1
9	1	2	1
10	2	1	1
11	2	1	1
12	1	1	1
13	1	0	1
14	2	1	1
15	0	2	1
16	2	1	1
17	0	2	1
18	1	1	2
19	1	1	2
20	2	2	2
21	2	0	2
22	1	0	2
23	1	0	2
24	0	1	2
25	2	1	2
26	0	2	2
27	2	0	2
28	2	2	2
29	0	0	2
30	2	2	2
31	0	0	2
32	2	2	2
33	1	2	2
Sheet6

Cell Formulas
Range	Formula
C2:C33	C2	=INT(SEQUENCE(COUNT(A2:A33),,0)/16)+1
F2	F2	=MEDIAN(F5:F6)
E5:E6	E5	=UNIQUE(C2#)
F5:F6	F5	=SUMPRODUCT((C$2#=E5)*($A$2:$A$33=$B$2:$B$33))
G5:G6	G5	=F5&"/16"
Dynamic array formulas.