Box-whisker plot ͼ Ҳ ͼ Box Plot е ͳ һ ķ λ λ ķ λ ݵ һ Ҳ Դ Եؿ Ƿ жԳ ԣ ķ ɢ ȵ Ϣ Ϊһ ݷ Σ ͼ ã ʺ ڣ 1 2

ӹ ע
ת http://blog.csdn.net/dylanren/archive/2010/05/31/5635620.aspx
Box-whisker plot ͼ Ҳ ͼ Box Plot е ͳ һ ķ λ λ ķ λ ݵ һ Ҳ Դ Եؿ Ƿ жԳ ԣ ķ ɢ ȵ Ϣ Ϊһ ݷ Σ ͼ ã ʺ ڣ 1 2 ʶ 쳣 㡣 ڻ ͼ ʱ OL 1 ķλ quartile ͳ ѧ У С в ĵȷݣ λ õĵ ķ λ (2) һķλ (Q1) OK һλ ķλ ڸ Ск 25% ڶ ķλ 3 (Q2) Median λ ӴСС λм Ϊ ʱ λ = (N +1) / 2 ݣ Ϊż ʱ λΪ N / 2 N / 2 +1 ݵ ƽ һ м λ ϵĴ ݼ Ӱ 졣 ijЩ ݵı䶯 λ Ӱ 첻 һ еĸ ݱ䶯 ϴ ʱ 伯 ơ : 4 ķλ (Q3) OK λ ķλ ڸ Ск 75% (5) ķλ IQR interquartile range ھ, ķλķλ , ķλ ɷӳ ȵ ĴС (6): Q1-1.5I * QR, Q3 +1.5 * IQR Ϊ ޡ (7) 쳣 㣨outliers Ϊ 쳣 㡣 ͼ ʱ ߵ յ Ϊ min (Q3 +1.5 * IQR, ) ߵ յ Ϊ max (Q1-1.5 * IQR, С ) ͼ ǿ Բ ݵķ λ ʷ ݵ ߡ dz Ϊ 쳣 㡣EXCEL 2 Լ ķλ quartile (Array, quart) percentile ldm (Array, k) 10 2 3 5 10 12 13 14 34 34 36 ڵ A1 A10 С
Quartile ķλQUARTILE (A1: A10, 1) = 6.25 λQUARTILE (A1: A10, 2) = 12.5 ķλQUARTILE (A1: A10, 3) = 29 percentile ķλPERCENTILE (A1 : A10, 0.25) = 6.25 λPERCENTILE (A1: A10, 0.5) = 12.5 ķλPERCENTILE (A1: A10, 0.75) = 29 λ Բ median () ķλķж EXCEL Уķλ㷨 ҵ k С , k = (quart / 4) * (n-1)) +1, quart Ϊ0 4 һ quart ķ λ nλ ĸ k ȡ ȥ С λf ҵ k k+1 й ʽ 㣺Output = a [k] + (f * (a [k +1]-a [k])) to [k] = kС the [k +1] = k + 1С У ķ λ 㷨 test, k = (1/4 * (10-1) +1) = 3 f = 1/4 * (10-1) +1- k = 0.25 = 5 ķλ +10- 5 * f = 6.25 ע MINITAB м ķ λ 㷨 EXCEL 㷨 Ҳ Dz ġ Ϊ Ŀ ģ ʵ п Բ EXCEL Ľ 2-3 ҵ ͼ ÿ ͼ ȣ ͼ Ҫ ж ݵķ Ҫ ݵ㰴ʱ Ҫ У к ǿ ʵ ԡ ij ҵ 18 Ŀ ϵͳ Ե ȱ ȣ õ µ ݣ ȱ (/ KLOC) 1 1.37 2 1.57 3 0.70 4 0.47 5 0.89 6 0.67 7 0.21 8 0.67 9 0.89 10 0.25 11 0.63 12 0.60 13 0.13 14 0.47 15 2.38 16 0.33 17 1.11 18 0.00 ͼ ߣ EXCEL м = 0.37 Q1 Q2 Q3 = 0.65 = 0.89 IQR = 0.52 ǽ ޣ 0 壬 ȡ Ϊ0 ޣ 0.65 1.67
ת http://blog.csdn.net/dylanren/archive/2010/05/31/5635620.aspx ͼ Box Box-whisker plot Ҳ ͼ Plot, blogTag: 'statistics, ͼ, λ, blogUrl:' blog/static/22367723201092571951810, isPublished: 1, istop: false, ldm type: 0, modifyTime: 1316946535654, publishTime: 1288005591810 , Permalink: ldm 'blog/static/22367723201092571951810, commentCount: 0, mainCommentCount: 0, recommendCount: 0, bsrk: -100, publisherId: 0, recomBlogHome: false, currentRecomBlog: false, attachmentsFileIds: [], vote: {}, groupInfo: {}, friendstatus: 'none', followstatus: 'unFollow', pubSucc:'', visitorProvince:'', visitorCity:'', visitorNewUser: false, postAddInfo:{"postAdSetting":{"title":" ʤ ","linkUrl":"http://g.163.com/a?CID=29495&Values=3214368749&Redirect=http://e.cn.miaozhen.com/r.gif?k=1014155&p=4-7Oo0&ae=1000778&vo=3f900abb5&vr=2&rt=2&ns=[M_ADIP]&ni=[M_IESID]&na=[M_MAC]&o=http%3A%2F%2Fpizzahut.qq.com","imageUrl":"http://img1.126.net/channel8/017284_290260_0714.swf","linkUrl2":"","expireDay":"3","modifyTime":"1405904548091","imageUrl2":"","targetProvince":"","flashUrl":"http://img1.126.net/channel8/017284_290260_0714.swf"},"isAdShow":true,"postAdContent":{"special":[{"title":" ldm ϰ ϯ 籭 Ը ʱʵ ","url":"http://cskun1989.blog.163.com/blog/static/1276782242014621856361/"},{"title":" Ƴ ο "Ǯ"","url":"http://topnews9.blog.163.com/blog/static/227137096201462193141515/"},{"title":" С " ʥ" ˮ ","url":"http://zhangjinlai0412.blog.163.com/blog/static/659131202014621003991/"}],"blog":[{"title":" С Ȼ Ϸˮ","pic":"http://img2.cache.ne