EJEMPLO ANALISIS DE VARIANZA DE TRES FACTORES EN EXCEL

Tiempo de lavado C
15 20
catalizador B catalizador B
𝑦_𝑖𝑗 1 2 3 1 2 3
10.7 10.3 11.2 10.9 10.5 12.2
𝑘𝑙 1 10.8 10.2 11.6 12.1 11.1 11.7 11.1055556
11.3 10.5 12 11.5 10.3 11
Operador A




11.4 10.2 10.7 9.8 12.6 10.8
2 11.8 10.9 10.5 11.3 7.5 10.2 10.6777778
11.5 10.5 10.2 10.9 9.9 11.5
13.6 12 11.1 10.7 10.2 11.9
3 14.1 11.6 11 11.7 11.5 11.6 11.9055556
14.5 11.5 11.5 12.7 10.9 12.2
12.19 10.86 11.09 11.29 10.50 11.46 11.22963
0.9202 0.1399 0.0198 0.0035 0.5324 0.0510 1.6668
11.73889 10.677778 11.2722222
0.259345 0.3045405 0.00181413 10.182593
𝑦 ̅_ (
𝑖𝑗.) 11.3777777777778 11.0814814814815
0.0219478737997264 0.0219478737997258 0.04389575
27

𝑦 ̅_ 10.933 10.333 11.600 11.500 10.633 11.633
𝑖𝑗𝑘 11.567 10.533 10.467 10.667 10.000 10.833
14.067 11.700 11.200 11.700 10.867 11.900




𝑦SCAC
̅_ ( 10.95556 11.255556 11.1055556 0.08889232 0.0888923
𝑖𝑗.) 10.85556 10.5 10.6777778 0.00087791 0.0008779
12.32222 11.488889 11.9055556 0.07210219 0.0721022
11.37778 11.081481 11.22963 2.9137


SCBC Tiempo de lavado C
catalizadr 15 20
1 12.19 11.29 11.74 0.09111 0.09111
2 10.86 10.50 10.68 0.00088 0.00088
3 11.09 11.46 11.27 0.10988 0.10988
11.38 11.08 11.2296 3.6337
𝑦 ̅_ (
𝑖𝑗.)

, 𝑦 ̅_ (
𝑖𝑗.)