Prepared By: Rizza O. Buenaventura & Guen C. Manzano Professor: Dr. Zandra
Prepared By: Rizza O. Buenaventura & Guen C. Manzano Professor: Dr. Zandra
Prepared By: Rizza O. Buenaventura & Guen C. Manzano Professor: Dr. Zandra
σ2σ2 = Variance
xx = Values given in a set of data
x¯x¯ = Mean of the data
nn = Total number of values.
EXCEL SPSS MINITAB
Solution:
Formula for mean is given by:
x¯x¯ = ∑xn∑xn
Formula for variance is given by:
σ2σ2 = ∑(x−x¯)2n−1∑(x−x¯)2n−1
Calculation for first set of values:
x1¯x1¯ = 5
x1 x1−x1¯x1−x1¯
(x1−x1¯)2(x1−x1¯)2
1 16
-4
3 -2 4
5 0 0
2 4
7
9 4 16
∑(x1−x1¯)2∑(x1−x1¯)2 = 40
σ12 = 10
Calculation for second set of
values:
x2¯x2¯ = 5
x2 x2−x2¯x2−x2¯
(x2−x¯)2(x2−x¯)2
5 0.6 0.36
9 11.56
3.4
3 -2.6 6.76
8 2.4 5.76
3 -2.6 6.76
∑(x1−x1¯)2∑(x1−x1¯)2 =31.2
σ22 = 7.8
F valueF value = σ21σ22σ12σ22
F valueF value = 107.8107.8 = 1.282
Solution:
4 1
1
2 -1 1
5 2 4
3 -2 4
1 0 0
∑(x1−x1¯)2∑(x1−x1¯)2 = 10
σ12 = 2.5
Calculation for second set of values:
x2¯x2¯ = 4.2
x2 x2−x2¯x2−x2¯
(x2−x¯)2(x2−x¯)2
8 3.8
14.44
3 -1.2 1.44
9 4.8 23.04
0 -4.2 17.64
1 -3.2 10.24