---

A B C D E F G
x_i u_i u_i * x_i x_i - x̄ (x_i - x̄)² u_i * (x_i - x̄)² 
10 14 =A2*B2 =A2-$B$9 =D2^2 =B2*E2 
16 18 =A3*B3 =A3-$B$9 =D3^2 =B3*E3 
26 18 =A4*B4 =A4-$B$9 =D4^2 =B4*E4 
26 18 =A5*B5 =A5-$B$9 =D5^2 =B5*E5 
Суммы =SUM(B2:B5) =SUM(C2:C5)   =SUM(F2:F5) 
n =B6     
x̄ =C6/B6     
s² =F6/(B6-1)     
s =SQRT(B9)     
t-крит =СТЬЮДЕНТ.ОБР.2Х(0.001; B6-1)     
Δ =B11*B10/SQRT(B6)     
Нижняя гр. M =B9-B12     
Верхняя гр. M =B9+B12     
χ²_нижн =ХИ2.ОБР(0.025; B6-1)     
χ²_верх =ХИ2.ОБР(0.975; B6-1)     
Нижняя гр. σ =B10*SQRT((B6-1)/B16)     
Верхняя гр. σ =B10*SQRT((B6-1)/B17)