用EXCEL进行模糊聚类分析

13220006()JournalofLiaochengTeachersUniversity(Nat.Sci.)Vol.13No.2Jun.2000EXCELa王文德1)　巩建闽2)　石凤来3)(1),252059;2);3))聚类分析是统计方法中多元数据分析的三大方法之一,也是数据挖掘技术研究的方法之一,本文介绍了用电子表格软件Excel实现模糊聚类分析的方法.Excel,模糊聚类分析,聚类分析TP39,Excel,.Excel(Excel).Excel.Excel,,.Lotusl-2-3XBase.dbf.Excel,MIS.Excel.,(DataMining),,.1n(),x1,x2,,xn,()xi(i=1,2,,n)m,xi1,xi2,,xim,m.1.,Excel.1x1x2x3x4y1x11x21xn1y2x12x22xn2ymx1mx2mxnmn..xixjdij,dij,Excel.x1,x2,,xna:1999-11-20RR=d11d12d1nd21d22d2ndn1dn2dnn.R,R,.:R2=R.R,,R2k=Rk.Rk,k=1,2,4,,k,R2k=Rk.R=Rk,R.R,K0K1,R,K,1,0,KRK,RK.R2=(d*ij),d*ijd*ij=nk=1(djkdkj)(i,j=1,2,,n).(1)2ExcelExcel(sheet)xjk=1xik,0xik,i=1,2,,n,k=1,2,,m[1],xikik.xixj,dijdij=mk=1xikxjk+mk=1(1-xik)(1-xjk)]m,i,j=1,2,,n,xixj;,dij,.,dij,.dij,Excel.Excel,.,5R=ABCDE11.0020.711.0030.630.491.0040.600.530.581.0050.680.670.480.491.00(=13,=93),R(sheet).R,(1),(sheet)312:EXCELABCDE11.000.710.630.600.6820.711.000.490.530.6730.630.491.000.580.4840.600.530.581.000.4950.680.670.480.491.00FGHIJ1.000.710.630.600.680.711.000.490.530.670.630.491.000.580.480.600.530.581.000.490.680.670.480.491.00K=LMNOP1.000.710.630.600.680.711.000.630.600.680.630.631.000.600.630.600.600.601.000.600.680.680.630.601.00.,A1:E5R,F1:J5R,L1:P5(1)R2.,Excel,,.L1=MAX(MIN(ÇA1,FÇ1),MIN(ÇB1,FÇ2),MIN(ÇC1,FÇ3),MIN(ÇD1,FÇ4),MIN(ÇE1,FÇ5))1L1.,,R4=R2.R(=R2).R,K0K1,R,K,1,0,KRK,RK.K=0.60,0.63,0.68,0.7,R=LMNOP71.0080.711.0090.630.631.00100.600.600.601.00110.680.680.630.601.00.,IF(),K,KF13.,F13K,.L72.32()13,F130.63,K=0.63,.,{x1,x2,x3,x5},{x4}.,Excel,VBAR0.63=LMNOP11211311140001511101Excel,.Excel.,.(KDD),,,,,.,Excel,,.1,.FUZZY.,1989.22,..:,1982MakingFuzzyClusteringAnalysiswithMicrosoftExcelWangWende1)GongJianmin2)ShiFenglai3)(1)DepartmentofComputerScience,LiaochengTeachersUniversity,Liaocheng;2)DezhouCollege;3)ChinaConstructionBankLiaochengBranch)AbstractClusteringanalysisasamethodofDataMiningisoneofthethreemethodaboutMultivariateStatistics,thispapershowsthewaytomakeFuzzyClutteringAnalysiswithMicrosoftExcel.KeywordsExcel,FuzzyClutteringanalysis,Clutteringanalysis(29)RealizingtheFillofArbitbaryEnclosedGraphicZonebyStackZhengHaiyang(DepartmentofMathematics,GuyuanTeachersCollege,Guyuan756000)AbstractThepaperdiscussesthealgorithmofrealizingthefillofarbitraryen-closedgraphiczonebystackandonthebasisofwhichgivesaprogrambyClanguagere-alizingthealgorithm.KeywordsStack,Enclosedgraphiczone,Fill332:EXCEL