Preencher os valores da células verde.
ifi xi fi.xi fri Fi Fri fi.|Xi-Ma| (xi)² fi.(xi)²
1150 ├154 4 152 608.00 10.00 4 10.00 9.00 36.00 23,104.00 92,416.00 81.00 324
2154 ├158 9 156 1,404.00 22.50 13 32.50 5.00 45.00 24,336.00 219,024.00 25.00 225
3158 ├162 11 160 1,760.00 27.50 24 60.00 1.00 11.00 25,600.00 281,600.00 1.00 11
4162 ├166 8 164 1,312.00 20.00 32 80.00 3.00 24.00 26,896.00 215,168.00 9.00 72
5166 ├170 5 168 840.00 12.50 37 92.50 7.00 35.00 28,224.00 141,120.00 49.00 245
6170 ├174 3 172 516.00 7.50 40 100.00 11.00 33.00 29,584.00 88,752.00 121.00 363
7├0 0.00 0.00 0.00 0.00 0
8├0 0.00 0.00 0.00 0.00 0
9├0 0.00 0.00 0.00 0.00 0
10 ├0 0.00 0.00 0.00 0.00 0
10 ∑fi 40 ∑fi.xi 6,440.00 ∑fi.|Xi-Ma| 184.00 1,038,080.00 ∑fi.|Xi-Ma|² 1,240.00
=161.00
=4.60 31
=5.57 ou 5.57
Intervalo
de classe |Xi-Ma| |Xi-Ma|² fi.|Xi-Ma|²
∑fi.(xi)²
Ma ou
dp
=√(□(64&(∑𝒇𝒊(𝒙𝒊)
^𝟐 )/𝒏 −((∑𝒇𝒊.𝒙𝒊
)/𝒏 ) ² ))
dm=(∑128▒𝑓𝑖|𝑥_𝑖−𝑀𝑎| )/𝑛 Var=(∑128▒ 〖 [𝑓𝑖|𝑥_𝑖−𝑀𝑎| 〗 ])/² 𝑛
Ma =(∑128▒ 〖𝑓𝑖 .𝑥𝑖 〗 )/𝑛
Dp=√𝑉𝑎𝑟
