由平均值到變異數到標準差到變異係數
.
|
X / Y |
3 |
1 |
1 |
|
2 |
4 |
1 |
2 |
|
3 |
5 |
1 |
3 |
|
4 |
5 |
1 |
4 |
|
5 |
5 |
5 |
5 |
|
6 |
5 |
9 |
6 |
|
7 |
5 |
9 |
7 |
|
8 |
6 |
9 |
8 |
|
9 |
7 |
9 |
9 |
|
加總 |
=SUM(B1:B9) |
=SUM(C1:C9) |
=SUM(D1:D9) |
|
最大 |
=MAX(B1:B9) |
=MAX(C1:C9) |
=MAX(D1:D9) |
|
最小 |
=MIN(B1:B9) |
=MIN(C1:C9) |
=MIN(D1:D9) |
|
平均 |
=AVERAGE(B1:B9) |
=AVERAGE(C1:C9) |
=AVERAGE(D1:D9) |
|
記數 |
=COUNT(B1:B9) |
=COUNT(C1:C9) |
=COUNT(D1:D9) |
|
眾數 |
=MODE(B1:B9) |
=MODE(C1:C9) |
=MODE(D1:D9) |
|
中位數 |
=MEDIAN(B1:B9) |
=MEDIAN(C1:C9) |
=MEDIAN(D1:D9) |
|
偏差平方和 |
=DEVSQ(B1:B9) |
=DEVSQ(C1:C9) |
=DEVSQ(D1:D9) |
|
偏差平方後加總 / 項目計數N=母體變異數 |
=VAR.P(B1:B9) |
=VAR.P(C1:C9) |
=VAR.P(D1:D9) |
|
變異數開平方根=母體標準差 |
=STDEV.P(B1:B9) |
=STDEV.P(C1:C9) |
=STDEV.P(D1:D9) |
|
如果偏差不平方加總再除以項目 |
=(ABS($B$13-B1)+ABS($B$13-B2)+ABS($B$13-B3) +ABS($B$13-B4)+ABS($B$13-B5)+ABS($B$13-B6) +ABS($B$13-B7)+ABS($B$13-B8)+ABS($B$13-B9))/B14 |
=(ABS($B$13-C1)+ABS($B$13-C2)+ABS($B$13-C3) +ABS($B$13-C4)+ABS($B$13-C5)+ABS($B$13-C6) +ABS($B$13-C7)+ABS($B$13-C8)+ABS($B$13-C9))/C14 |
=(ABS($B$13-D1)+ABS($B$13-D2)+ABS($B$13-D3) +ABS($B$13-D4)+ABS($B$13-D5)+ABS($B$13-D6) +ABS($B$13-D7)+ABS($B$13-D8)+ABS($B$13-D9))/D14 |
|
變異係數CV=標準差 / 平均值。一般以%表示 |
=B19/B13 |
=C19/C13 |
=D19/ |
|
no1 |
3 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
|
no2 |
3 |
3 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
|
no3 |
3 |
3 |
3 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
|
no4 |
3 |
3 |
3 |
3 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
|
no5 |
3 |
3 |
3 |
3 |
3 |
2 |
2 |
2 |
2 |
2 |
2 |
|
no6 |
3 |
3 |
3 |
3 |
3 |
3 |
2 |
2 |
2 |
2 |
2 |
|
no7 |
3 |
3 |
3 |
3 |
3 |
3 |
3 |
2 |
2 |
2 |
2 |
|
no8 |
3 |
3 |
3 |
3 |
3 |
3 |
3 |
3 |
2 |
2 |
2 |
|
no9 |
3 |
3 |
3 |
3 |
3 |
3 |
3 |
3 |
3 |
2 |
2 |
|
no10 |
3 |
3 |
3 |
3 |
3 |
3 |
3 |
3 |
3 |
3 |
2 |
|
母體數 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
|
加總 |
30 |
29 |
28 |
27 |
26 |
25 |
24 |
23 |
22 |
21 |
20 |
|
平均 |
3 |
2.9 |
2.8 |
2.7 |
2.6 |
2.5 |
2.4 |
2.3 |
2.2 |
2.1 |
2 |
|
變異數 |
0.00% |
9.00% |
16.00% |
21.00% |
24.00% |
25.00% |
24.00% |
21.00% |
16.00% |
9.00% |
0.00% |
|
標準差 |
0.000 |
0.300 |
0.400 |
0.458 |
0.490 |
0.500 |
0.490 |
0.458 |
0.400 |
0.300 |
0.000 |
沒有留言:
張貼留言