Contents

1 覿(ろ蠏碁)
2 ろ讌 覦覯
3 譴ク谿襯 伎 覦覯
4 5螻 螳
5 蠍壱


襯 れ, 螻螳 1覦焔 覈 り . 1覦 襷覈 企 1 伎 (觜 ) 蟲襷ろ. 讌襷 螳螳 螻螳 襷貅 旧 語企る讌 螳螳 螻螳 轟煙 覦覯 螳ロ蠍磯 覿螳ロ. 螳ロ蠍一 讌襷 企ゼ 覲企伎蟾讌 ろ 覦覲企 朱襦 ろ 覿螳レ企 る. 蠏碁 螻螳碁朱讌 Segramentation 蟆 . 朱 蟲 , , 覩, , 螳襦 れ 蟲覿螻, 螳蟾語襦 '一' 轟煙 螳譟り . 蟲 10 襦 讓手讌襷 蠍一 10 襦 讓手 一危一 轟煙 る 蟆 襷れ 企れ 殊企. 一危一 覿螳 襷れ 朱襦 襦 讓手り 讓手伎 蠏碁9 覓 襷 覿 豌願 企れ 蟆企. 蠏碁り 譯手 蟯 覿襯蠍一 一危一 覿 企れ讌.

覓語 企 譯手 讌 螻, 糾 覦覯朱 Segmentation 覦覯 2螳讌襯 螳襦 蟆.

1 覿(ろ蠏碁) #

企 一危郁 豌 譴 谿讌 豺襯 願鍵 伎 豌 蟆渚レ 殊 襷れ 譴. 豌 蟆渚レ 磯 覿螳 襷れ . 覿 れ螻 螳 覦覯朱 襷 .

  1. 一危一 豕, 豕螳 蟲.
  2. 襭 蠍一 磯 麹 螻蠍 襯 .(伎豺 蟇壱.(伎豺 蟇 覦覯))
  3. 譴覲給讌 蟆 螻蠍 蠍磯ゼ .
  4. 螳 螻蠍 (一危 )襯 蟲.
  5. 螻蠍 一朱 .
  6. 襯 蟲. ( = 企 螻蠍 / 豌 )

2 ろ讌 覦覯 #

ろ讌れ 覦覯 糾 豈 蟇一 豌 覿覿 る 伎企. ろ讌る 螻蠍 [1]襯 蟆一 覦覯朱 れ螻 螳 螻旧 襷れ.

  • 螻蠍 k = 1 + (log10N / log102) (N; 襭 ) = 1 + (LOG10(N) / LOG10(2))
  • 螻蠍 覯 R = (Max螳 - Min螳) / k

覿襯 覦覯 螻旧 伎 れ螻 螳 襦 蟲覃 .

  1. 一危一 豐 螳, Max螳, Min螳 蟲. Max螳, Min螳 蟲 伎豺襯 蟇壱 蟆 譬.
  2. ろ讌れ 覦覯 伎 螻蠍 (k)襯 蟲.
  3. 螻 蟲伎 螻蠍 k襯 伎 螳 覯襯 蟲.
  4. 蟲伎 覯襦 一危磯ゼ 蟲覿.

れ SQL Server 2005 T-SQL 蟲 企.
DECLARE
	@k int
,	@r bigint
,	@avg  bigint
,	@sigma bigint
, 	@min bigint
,	@max bigint
,	@cnt int
, 	@min_real bigint
,	@max_real bigint

--1 + (LOG10(N) / LOG10(2))

SELECT
	@sigma = STDEV(Score)
,	@avg = AVG(Score)
,	@min_real = MIN(Score)
,	@max_real = MAX(Score)
FROM #Score

-- 伎豺 蟇壱 蟲螳 蟲.: 蠏 - (1.5 * 譴ク谿) ~ 蠏 + (1.5 * 譴ク谿)
SELECT
	@r = (MAX(Score) - MIN(Score)) / (1 + (LOG10(COUNT(*)) / LOG10(2)))
,	@k = (1 + (LOG10(COUNT(*)) / LOG10(2)))
,	@cnt = COUNT(*)
,	@min = MIN(Score)
,	@max = MAX(Score)
FROM #Score
WHERE Score > @avg - (3 * @sigma)
AND Score < @avg + (3 * @sigma)

;WITH Dumy(Seq)
AS
(
        SELECT 1 Seq
        UNION ALL
        SELECT Seq + 1 FROM Dumy
        WHERE Seq + 1 <= @k
), Grade
AS
(
	SELECT 
		(@k - Seq ) + 1 Grade
	,	@min + ((Seq-1) * @r) BeginScore
	,	@min + (Seq * @r) EndScore
	FROM Dumy
), RealGrade
AS
(
	SELECT Grade, BeginScore, EndScore FROM Grade
	UNION ALL
	SELECT Grade + 1, @min_real, EndScore + 1
	FROM Grade
	WHERE Grade = (SELECT MAX(Grade) FROM Grade)
	UNION ALL
	SELECT Grade - 1, BeginScore + 1, @max_real
	FROM Grade
	WHERE Grade = (SELECT MIN(Grade) FROM Grade)
)
SELECT
	B.Grade
,	COUNT(*) AccountCnt
,	SUM(NetAMT) NetAMT
FROM #Score A
	INNER JOIN RealGrade B
		ON A.Score BETWEEN B.BeginScore AND B.EndScore
GROUP BY
	B.Grade
ORDER BY 1


3 譴ク谿襯 伎 覦覯 #

譴ク谿襯 伎覃 一, 覲危, 豬 企蟆 3螳 蠏碁9朱 . 襯 れ, 50覈 蠍 れ れ 蠏豺螳 170Cm願, 譴ク谿螳 7Cm れ螻 螳 . ([2]: 譴ク谿, 亮[3]: 蠏)

  • 豬: 163Cm 覩碁 (亮 - )
  • 覲危: 163 ~ 177Cm (68.3%)
  • 一: 177Cm 豐螻 (亮 + )

譴ク谿 襭 轟煙 襷れ 企 讌襦 蠏覿 15.85% , 襯 企襦 豬所骸 一襯 一 襷れ . 3螳 蠏碁9 {(亮 - 3) ~ (亮 + 3)} 螻 螳 6螳 蟲螳朱 .
normal_distribution.jpg 譴蠏覿

谿瑚襦 '6蠏碁' 蠏碁 蠏碁手骸 螳 詞 危螻 . 6蠏碁 (亮 - 6) ~ (亮 + 6) 蟲螳 詞 碁.

4 5螻 螳 #

蠏覿 れ螻 螳 5螳 蟲螳朱 .

蟲覿覯(%)
E(豕螳) ~ (m - 1.5)7%
D(m - 1.5) ~ (m - 0.5)24%
C(m - 0.5) ~ (m + 0.5)38%
B(m + 0.5) ~ (m + 1.5)24%
A(m + 1.5) ~ (豕螳)7%

5 蠍壱 #