想問問First Quartile點計？
根據wikipedia
Data Set: 6, 47, 49, 15, 42, 41, 7, 39, 43, 40, 36
Ordered Data Set: 6, 7, 15, 36, 39, 40, 41, 42, 43, 47, 49
Q1=15
Q2=40
Q3=43
但用Excel計，
Q1=25.5 ”=QUARTILE({6,7,15,36,39,40,41,42,43,47,49},1)”
Q2=40 ”=QUARTILE({6,7,15,36,39,40,41,42,43,47,49},2)”
Q3=42.5 ”=QUARTILE({6,7,15,36,39,40,41,42,43,47,49},3)”
是否有兩種First Quartile，我搞亂了？
Excel 怎樣計算First Quartile？
2008-04-14 9:55 pm
回答 (3)
2008-04-15 12:26 am
✔ 最佳答案
This is because Excel treats the data as continuous and u treat it as discrete.With such small amount of data, the difference is huge, but as the number of data increase, their difference get smaller and smaller.
Your answer is correct. With such small amount of data, u just need to calculate it manually.
2008-04-18 9:54 pm
謝謝各位的指教！
另外，請問有沒有人可以告訴我，Excel是如何把那些數字運算（加減乘除）得出這些答案呢？
另外，請問有沒有人可以告訴我，Excel是如何把那些數字運算（加減乘除）得出這些答案呢？
2008-04-18 7:20 pm
對於 discrete data, excel 亦提供了 median(), small(), 和 large() 來處理. 詳細解釋如下:
設 data 在 a1 至 a11, 可用公式
=SMALL(A1:A11, (COUNT(A1:A11)+1)/4) 來計算Q1
=MEDIAN(A1:A11) 來計算Q2
=LARGE(A1:A11, COUNT(A1:A11)/4) 來計算Q3.
設 data 在 a1 至 a11, 可用公式
=SMALL(A1:A11, (COUNT(A1:A11)+1)/4) 來計算Q1
=MEDIAN(A1:A11) 來計算Q2
=LARGE(A1:A11, COUNT(A1:A11)/4) 來計算Q3.
收錄日期: 2021-04-19 00:52:32
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20080414000051KK00977