NTSYS-pcsoftwareproceduresSetupExcelspreadsheet1strowatA1=1(typeofspreadsheet),B1=#rows,C1=#columns,D1=symbolformissingvalues2ndrowshouldcontaincolumnlabelsoremptyMatrixshouldbeginonB3(noterow2isemptyasiscolumn1)SavespreadsheetasanxlsfileCloseexcel.MakingNTSYSmatrixClickonNteditFile/import/OLEfileSelectexcelspreadsheet(matrixshouldimport)CheckmatrixtomakesureitisinrightorientationClickCollabbuttonandinsertcolumnlabelsDothesameforrowlabelsifyouwantSavefileaswhateveryouwantbutshouldhaveaspreadsheet.ntsextension.Analysis(notemustkeepallwindowsopentoproceedtonextstep)OpenNTSYS-pcprogramClicksimilaritythensimqualbuttonsInputfileclickonopenspacetobrowse,selectspreadsheet.ntsfilejustcreatedDon’tcheckbyrowsInsertsmincoefficientforsimilaritymatchingClickoutputfileasatextfilesimqual.ntsPositivecode=1.00Negativecode=0.00ThencomputePrintoutreportfile/notebook/print/ok.GobacktoNTSYS-pcscreenCheckclusteringthenSAHNInputfilewillbethesimqual.ntsfileaboveOutputfilewillbeSAHN.NTSClusteringmethod=UPMGAIncaseoftie=WARNMaximum#oftiedtrees=2Tietolerance=0.000000000Beta=0.000000000Compute.MaketreeplotGotographicsinNTSYS-pcprogramwindowClicktreeplot,plotshouldcomeinviewFile/savemetafile.emfTomakesimilaritymatrixGotoNTSYS-pcwindowClickgeneralthenDcenterInputfile=simqual.ntsResultmatrix=matrix.ntsCompute.OrdinationOpenNTSYS-pcwindowClickordinationClickeigenInputmatrix=matrix.ntsDim=3Outputeigenvector.emfVectorscaling=squarelamdaSamplesize=0Degreeoffreedom=0Howtomake2Dor3Dgraph(PCA)GotoGraphics,then3Dplot,Inputfile=eigenvector.emf,thendon’tcheckplotbyrows,X(1)Y(2)Z(3),Graphmatrixfile(no),thenrotation30.0030.00,viewdistance(999.00),thencompute.PCAanalysisOpenNTSYS-pcprogramClicksimilaritythenqualitativedatabuttonsInputfileclickonopenspacetobrowse,selectspreadsheet.ntsfilejustcreatedDon’tcheckbyrowsInsertsmincoefficientforsimilaritymatchingClickoutputfileasatextfilesimqual.ntsPositivecode=1.00Negativecode=0.00ThencomputePrintoutreportfile/notebook/print/ok.TomakesimilaritymatrixGotoNTSYS-pcwindowClickgeneralthenDcenterInputfile=simqual.ntsResultmatrix=matrix.ntsCompute.OrdinationOpenNTSYS-pcwindowClickordinationClickeigenInputmatrix=matrix.ntsDim=3Outputeigenvector.emfVectorscaling=squarelamdaSamplesize=0Degreeoffreedom=0Make2Dor3Dgraph(PCA)GotoGraphics,then3Dplot,Inputfile=eigenvector.emf,thendon’tcheckplotbyrows,X(1)Y(2)Z(3),Graphmatrixfile(no),thenrotation30.0030.00,viewdistance(999.00),thencompute.