Excel问题,用公式或函数计算Z2至Z38大于某个数的数量占总数量的百分之几?请高手指教

来源:百度知道 编辑:UC知道 时间:2024/09/28 14:39:38
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个

=TEXT(COUNTIF(Z2:Z38,">5.6%")/COUNT(Z2:Z38),"0%")

=countif(z2:z38,">5.6%")/count(z2:z38)

子易空间站 - 高效办公指导网站

=COUNTIF(A1:A16,">"&B1) /count(a1:a16)

A1:A16为统计单元格区域,B1为输入的任意数值

=COUNTIF(z2:z38,">5.6%")/COUNTA(z2:z38)