Excel问题，用公式或函数计算Z2至Z38大于某个数的数量占总数量的百分之几？请高手指教20.9%5.0%15.5%6.0%-0.2%9.9%9.9%5.2%3.0%7.0%29.5%3.1%6.2%4.0%5.0%5.9%5.8%6.8%-2.5%-0.2%1.2%2.7%7.8%9.6%0.8%10.0%6.9%6.0%14.2%10.0%0.0%5.5%0.8%21.1%5.6%21.0%1.3%9.7%比如大于5.6%-2.50%-0.20%-0.20%0.00%0.80%0.80%1.20%1
2019-05-23
Excel问题，用公式或函数计算Z2至Z38大于某个数的数量占总数量的百分之几？请高手指教
20.9%
5.0%
15.5%
6.0%
-0.2%
9.9%
9.9%
5.2%
3.0%
7.0%
29.5%
3.1%
6.2%
4.0%
5.0%
5.9%
5.8%
6.8%
-2.5%
-0.2%
1.2%
2.7%
7.8%
9.6%
0.8%
10.0%
6.9%
6.0%
14.2%
10.0%
0.0%
5.5%
0.8%
21.1%
5.6%
21.0%
1.3%
9.7%
比如大于5.6%
-2.50%
-0.20%
-0.20%
0.00%
0.80%
0.80%
1.20%
1.30%
2.70%
3.00%
3.10%
4.00%
5.00%
5.00%
5.20%
5.50%
5.60%
5.80%
5.90%
6.00%
6.00%
6.20%
6.80%
6.90%
7.00%
7.80%
9.60%
9.70%
9.90%
9.90%
10.00%
10.00%
14.20%
15.50%
20.90%
21.00%
21.10%
29.50%
经过排序后，可以很明显可以看出比如大于5.6%的数是5.80% 5.90% 6.00% 6.00% 6.20% 6.80% 6.90% 7.00% 7.80% 9.60% 9.70% 9.90% 9.90% 10.00% 10.00% 14.20% 15.50% 20.90% 21.00% 21.10% 29.50%，数量是21个，
21除38等于0.553乘100等于55.3即55.3％