XLSTAT使用说明

XLSTATGeneralitiesInstallationRunningXLSTAT-XLSTATManagerXLSTATdirectaccessGeneralremarksDialogboxesNumericalefficiencyMissingdata/NumericalandcategoricalvariablesErrormessagesShortcutkeysReferencesHelpfilesStatisticaltools6DPlotsANOVA/ANCOVAAxesZoomerCategoricalsortingClustering1&2Correlations/PrincipalComponentAnalysis(PCA)CorrespondenceanalysisCrossedsorting/FlatsortingDataFlaggerDescriptivestatisticsDiscretizedataDiscriminantanalysisEasylabels(twoclickstoaddlabelsonaplot)ExtractasampleofrowsfromadatasetFactoranalysisFitdatatodensityfunctionsandtestfitHistogramsKruskal-WallistestMicroMoverMinMaxSearchModelsforbinaryresponsedata(Logit,Probit,...)MotriMaxMultidimensionalScaling(MDS)MultiplecorrespondenceanalysisNon-linearfitting(GenFit)OddsratioSimilarrowsdetectionPlotTransformerRegressionTestforcomparingtwoproportionsTestsforcomparingtwosamples(Student,Wilcoxon,Fisher,...)Testsoncontingencytables(Chi-squareandExacttests)TranspositionMicrosoftExcel©andStatisticsLicenseconditionsGeneralitiesInstallationRequiredsoftware:Excel®5.0oraboveRequiredhardware:XLSTATiscompatiblewithallPCsthatcanrunMicrosoftExcel®5.0.However,foroptimalperformance,a486DX33PCwith8MbRAMoraPowerPC-basedMacintoshisrecommended.ToinstallXLSTATyouneedtocopyallthefilesfromtheXLSTATdisktotheharddisk.YouloadXLSTATbyopeningthefileXLSTAT.xlawiththeopencommandintheFilemenuofExcel,orbetter,youcanusetheadd-inmanagerinthetoolsmenu.AdoubleclickonthefilenameoriconintheWindowsExploreroffilemanagerisalsopossible.TheprofessionalversionofXLSTATisexactlythesameasthesharewareone,theonlydifferencebeingthatitisnottimelimited[e-mail]:|OpencommandorbyusingtheTools|Add-inManagermenu.OnceXLSTATisopened,theavailablecommandscanbedirectlyaccessedfromthemenubarorfromtheXLSTATManagerwhichcorrespondstothecolorediconintheXLSTATtoolbar.UsingtheXLSTATManagertoopenthetoolsmakesitpossibletoaccessthemintheXLSTATtoolbar,astheyareaddedtoitafterselection.Toknowwhattoolcorrespondstowhaticonofthetoolbar,leavethemousecursorontheicon,andreadtheinfoballoonthatwillappear.ByusingtheXLSTATManagertoselecttools,youcanalsosaveaconfigurationasdefault.SavingaconfigurationasdefaultusingtheSavebutton,willmakeyousavetime:eachtimeXLSTATwillload,itwillautomaticallyopenthetoolsyousavedintheconfiguration.Whenyouclickonsavetheoptionscorrespondingtothe“O”buttonofthetoolbararealsosavedforthenextsessions.YoucanalsoactivatetheXLSTATManageratanytime,usingtheXLSTATManagercommandoftheXLSTATmenu.ToedittheXLSTATstandardorderingsheet,youcanusetheOrderbuttonoftheXLSTATAboutwindoworopenorder.xlsfromyourXLSTATdirectory.AfteryouregisteredyoucanusetheRegisterbuttontoenteryourpersonallicensenumber,givenbytheauthororthedistributor.YouwillthenimmediatelybecomeanXLSTAT-Pro!XLSTATdirectaccessIfyouwanttoopenandcloseXLSTATdirectlyatanytimebyjustpressingabutton,youonlyneedtoopenonceinExcelthexlsbar.xlamacro.ItwilladdabluecolorbuttoninthestandardtoolbarofExcel,closetothesavebutton.YoucanmoveordeletethisbuttonasanyotherExcelbuttonusingtheView/Toolbars/customizecommandofExcel.GeneralremarksIntheOptionsdialogbox,selectingGraphicsonseparatedsheetwillensurethatformostofthetoolstheplotswillbestoredinstandardChartsheets.Ifyoudon'tselectthisoption,theplotswillbestoredonthesamesheetastheoutputtables,intheupperleftcornerofthesheet.XLSTATsometimescreatesintermediatesheetsthatarestoredintheresultsworkbooks.Ifyouwantyoucanviewthembyselectingthecorrespondingoption.EachtimeyouloadXLSTAT,thereferenceoptionissettoA1ifitwasonR1C1.ThisisnecessaryforXLSTATtoworkproperly.Ifyouchangethatoptionwhileworking,don’tforgettochangeitbackbeforeusingXLSTATagain.EachXLSTATcopyisprotectedbycopyrightlaws,andcanonlybeusedononecomputeratatime.EverysinglesharewarereleaseofXLSTATistimelimited.Toobtainthelatestversion(updatesarereleasedfrequently)pleasecontactThierryFAHMYatthefollowinge-mailaddresses:[e-mail]'thackthissoftware,andmoreimportantlydon'tspreadillegalcopies.Respectotherpeople'swork,orsharewarewilldisappear.Don’tforgetthatifyoubuyXLSTATyouwillgetfreeupdatesforayear!TheAuthordisclaimsanyresponsibilityfordamagesorsubsequentlosscausedbyusingXLSTAT.DialogboxesDialogboxeshavebeencreatedtobeasstraight-forwardanduniformaspossible.TheOutputrangeisinfacttheupperleftcorneroftheoutputtables.InthecorrespondingboxpleaseselectonExcelsheetthecellwhichwillbetheupperleftcorneroftheresultstables.Whenyouselectdata,variablesalwaysneedtobestoredincolumns.Variableorcolumnlabelscorrespondtothelabelsornamesoftheexplanatoryvariables.Ifyouselectthevariablelabelswithinthedatarangeyoumusttickthecorrespondingoption.Observationsorrowslabelscorrespondstothelabelsornamesofeachdataline.Ifyouselectthedatalabelswithinthedatarange,thenyoumustspecifytickthecorrespondingoption.NB:TheOutputsrangedoesnotneedtobeonthesamesheetoronthesameWorkbookthantheinputtable.NumericalefficiencyXLSTATis