# Plots Above the Median: Solution

*English translation by SOTA – AI Community of the Russian original. Organisers who would like this translation removed can email sota.ai.community@gmail.com.*

*Task 6 of the school stage of the All-Russian School Olympiad (VsOSh) 2025/26 in artificial intelligence (region group I), grades 9–11. Answer and official solution.*

**Answer:** 43

**Solution.**

*Translator's note: the original writes the formulas below for a Russian-language spreadsheet (Russian function names, decimal commas and semicolons between arguments); here they are given with the English function names MEDIAN, IF and COUNTIFS.*

**Step 1. The director's individual score.** In cell D2 enter:

`=0.4*A2+0.6*B2`

and drag the formula down to D101.

**Step 2. The median of column $D$.** In cell F2 (any free column “off to the side”) enter:

`=MEDIAN(D2:D101)`

**Step 3. The “not below the median” indicator.** In cell E2 enter (note the fixed row `F$2`):

`=IF(D2>=F$2, 1, 0)`

and drag the formula down to E101.

**Step 4. Counting the suitable plots (the botanists are “in favour” and $s \ge$ median).** The final formula can be placed, for example, in H2:

`=COUNTIFS(C2:C101, 1, E2:E101, 1)`

This formula counts the rows in which simultaneously $y = 1$ (column $C$) and the indicator from column $E$ equals 1, that is, $s \ge \text{Median}$.