我有一堆數字
1
3
4
6
8
9
10
12
15
19
excel可唔可以GROUP D數
1-5 3個
6-10 4個
11-15 2個
16-20 1個
咁樣架?
excel有冇得GROUP數??
2010-04-21 8:22 am
回答 (3)
2010-04-21 6:10 pm
✔ 最佳答案
這是統計上常用的方法. 其實, excel 是有內建函數 frequency( ) 來處理的.步驟如下:
1. 假設 你的 data 在 A1:A10
2. 在 B1:B4 輸入 5, 10, 15, 20.
3. Highlight C1:C4, 並輸入 =FREQUENCY(A1:A10, B1:B4)
然後按 ctrl+shift+enter (即 同時按下 ctrl 和 shift, 再按 enter)
4. C1:C4 就會出現 3, 4, 2, 1 了.
2015-05-03 1:33 am
FREQUENCY 示範: https://www.youtube.com/watch?v=n24vDAcxNv4
希望幫到你
希望幫到你
2010-04-21 3:54 pm
1-5 3個 =COUNTIF(A1:A10,">0")-COUNTIF(A1:A10,">5")
6-10 4個 =COUNTIF(A1:A10,">5")-COUNTIF(A1:A10,">10")
11-15 2個 =COUNTIF(A1:A10,">10")-COUNTIF(A1:A10,">15")
16-20 1個 =COUNTIF(A1:A10,">15")-COUNTIF(A1:A10,">20")
6-10 4個 =COUNTIF(A1:A10,">5")-COUNTIF(A1:A10,">10")
11-15 2個 =COUNTIF(A1:A10,">10")-COUNTIF(A1:A10,">15")
16-20 1個 =COUNTIF(A1:A10,">15")-COUNTIF(A1:A10,">20")
收錄日期: 2021-04-13 17:12:30
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20100421000051KK00038