excel 公式問題
2007-12-10 7:32 am
Use Excel to construct a frequency distribution to summarize the sampled ata. Begin your fist class at "-10 but less than -7.5", and end with the last class at "5 but less than 7.5" 我想問, 因題目所比o既範圍入面, 有小數點, 例如: -3.03, -2.47, - 2.94 etc. 我excel 條公式可以點set ? 因我知第一個class 就係 =COUNTIF(A2:A40,"<-7.5"), 但我諗極都諗唔到第二class 開始點set, 麻煩請幫忙 !
回答 (2)
2007-12-10 9:00 pm
✔ 最佳答案
你應該用 FREQUENCY() functionfrequency ( data_array, bins_array )
data_array 就是你放 data 的 cells
bins_array 就是你放 d interval 的 cells
例如，你用 Col A 放 data, 而 col B 就做 d intervals, 由 B1 開始, B1 要留空, B2 到 B9
-10
-7.5
-5
-2.5
0
2.5
5
7.5
然後你 select C1 to C9, 打入 =FREQUENCY(A:A,B2:B9) , 按 Ctrl-Shift Enter
咁在 C1 to C9 就會出晒 D frequency 出黎
C1: ＜ -10
C2: between -10 to -7.5
C3: between -7.5 to -5
C4: between -5 to -2.5
C5: between -2.5 to 0
C6: between 0 to 2.5
C7: between 2.5 to 5
C8: between 5 to 7.5
C9: ＞ 7.5
C1 同埋 C9 唔係你個 list 入面，不過我地應該要小心 D check 埋，唔係用 frequency function 就會將錯既範圍外既 data 計埋入去你最大同最細既 interval 裡面
2015-05-03 1:33 am
FREQUENCY 示範: https://www.youtube.com/watch?v=n24vDAcxNv4
希望幫到你
希望幫到你
收錄日期: 2021-04-13 14:40:59
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20071209000051KK05059