# Outliers Relative to the Mean: 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 III), grades 9–11. Answer and official solution.*

**Answer:** 11

**Solution.**

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

**Step 1. The mean of the third column.** In any free cell (for example, G2):

`=AVERAGE(C2:C101)`

This is $\bar{x}$.

**Step 2. Checking the outlier condition for each row.** In cell F2 enter (we fix the row with the mean using `$`):

`=IF(ABS(C2-G$2)>G$2, 1, 0)`

Drag the formula down to F101.

**Step 3. Counting the outliers.** In any free cell, for example H2:

`=SUM(F2:F101)`

The resulting number is the number of rows in which the value $x$ in the third column is an outlier.