《XLSTAT使用说明》由会员分享,可在线阅读,更多相关《XLSTAT使用说明(40页珍藏版)》请在金锄头文库上搜索。
1、XLSTATGeneralitiesInstallationRunningXLSTAT-XLSTATManagerXLSTATdirectaccessGeneralremarksDialogboxesNumericalefficiencyMissingdata/NumericalandcategoricalvariablesErrormessagesShortcutkeysReferencesHelpfilesStatisticaltools6DPlotsANOVA/ANCOVAAxesZoomerCategoricalsortingClustering1&2Correlations/Prin
2、cipalComponentAnalysis(PCA)CorrespondenceanalysisCrossedsorting/FlatsortingDataFlaggerDescriptivestatisticsDiscretizedataDiscriminantanalysisEasylabels(twoclickstoaddlabelsonaplot)ExtractasampleofrowsfromadatasetFactoranalysisFitdatatodensityfunctionsandtestfitHistogramsKruskal-WallistestMicroMoverM
3、inMaxSearchModelsforbinaryresponsedata(Logit,Probit,.)MotriMaxMultidimensionalScaling(MDS)MultiplecorrespondenceanalysisNon-linearfitting(GenFit)OddsratioSimilarrowsdetectionPlotTransformerRegressionTestforcomparingtwoproportionsTestsforcomparingtwosamples(Student,Wilcoxon,Fisher,)Testsoncontingency
4、tables(Chi-squareandExacttests)TranspositionMicrosoftExcel?andStatisticsLicenseconditionsGeneralitiesInstallationRequiredsoftware:Excel?oraboveRequiredhardware:XLSTATiscompatiblewithallPCsthatcanrunMicrosoftExcel?.However,foroptimalperformance,a486DX33PCwith8MbRAMoraPowerPC-basedMacintoshisrecommend
5、ed.ToinstallXLSTATyouneedtocopyallthefilesfromtheXLSTATdisktotheharddisk.YouloadXLSTATbyopeningthefilewiththeopencommandintheFilemenuofExcel,orbetter,youcanusetheadd-inmanagerinthetoolsmenu.AdoubleclickonthefilenameoriconintheWindowsExploreroffilemanagerisalsopossible.TheprofessionalversionofXLSTATi
6、sexactlythesameasthesharewareone,theonlydifferencebeingthatitisnottimelimitedandthatafreeupdateserviceisprovidediftheauthoriscontactedat.XLSTATwebsiteis:RunningXLSTAT-XLSTATManagerTorunXLSTAT,pleaseloadthefilebyopeningitwithExcelFile|OpencommandorbyusingtheTools|Add-inManagermenu.OnceXLSTATisopened,
7、theavailablecommandscanbedirectlyaccessedfromthemenubarorfromtheXLSTATManagerwhichcorrespondstothecolorediconintheXLSTATtoolbar.UsingtheXLSTATManagertoopenthetoolsmakesitpossibletoaccessthemintheXLSTATtoolbar,astheyareaddedtoitafterselection.Toknowwhattoolcorrespondstowhaticonofthetoolbar,leavethemo
8、usecursorontheicon,andreadtheinfoballoonthatwillappear.ByusingtheXLSTATManagertoselecttools,youcanalsosaveaconfigurationasdefault.SavingaconfigurationasdefaultusingtheSavebutton,willmakeyousavetime:eachtimeXLSTATwillload,itwillautomaticallyopenthetoolsyousavedintheconfiguration.Whenyouclickonsavethe
9、optionscorrespondingtothe“O”buttonofthetoolbararealsosavedforthenextsessions.YoucanalsoactivatetheXLSTATManageratanytime,usingtheXLSTATManagercommandoftheXLSTATmenu.ToedittheXLSTATstandardorderingsheet,youcanusetheOrderbuttonoftheXLSTATAboutwindoworopenfromyourXLSTATdirectory.Afteryouregisteredyouca
10、nusetheRegisterbuttontoenteryourpersonallicensenumber,givenbytheauthororthedistributor.YouwillthenimmediatelybecomeanXLSTAT-Pro!XLSTATdirectaccessIfyouwanttoopenandcloseXLSTATdirectlyatanytimebyjustpressingabutton,youonlyneedtoopenonceinExcelthemacro.ItwilladdabluecolorbuttoninthestandardtoolbarofEx
11、cel,closetothesavebutton.YoucanmoveordeletethisbuttonasanyotherExcelbuttonusingtheView/Toolbars/customizecommandofExcel.GeneralremarksIntheOptionsdialogbox,selectingGraphicsonseparatedsheetwillensurethatformostofthetoolstheplotswillbestoredinstandardChartsheets.Ifyoudontselectthisoption,theplotswill
12、bestoredonthesamesheetastheoutputtables,intheupperleftcornerofthesheet.XLSTATsometimescreatesintermediatesheetsthatarestoredintheresultsworkbooks.Ifyouwantyoucanviewthembyselectingthecorrespondingoption.EachtimeyouloadXLSTAT,thereferenceoptionissettoA1ifitwasonR1C1.ThisisnecessaryforXLSTATtoworkprop
13、erly.Ifyouchangethatoptionwhileworking,donftorgettochangeitbackbeforeusingXLSTATagain.EachXLSTATcopyisprotectedbycopyrightlaws,andcanonlybeusedononecomputeratatime.EverysinglesharewarereleaseofXLSTATistimelimited.Toobtainthelatestversion(updatesarereleasedfrequently)pleasecontactThierryFAHMYatthefol
14、lowingemailaddressesDonthackthissoftware,andmoreimportantlydontspreadillegalcopies.Respectotherpeopleswork,orsharewarewilldisappear.DontforgetthatifyXoLuSbTuAyTyouwillgetfreeupdatesforayear!TheAuthordisclaimsanyresponsibilityfordamagesorsubsequentlosscausedbyusingXLSTAT.DialogboxesDialogboxeshavebee
15、ncreatedtobeasstraight-forwardanduniformaspossible.TheOutputrangeisinfacttheupperleftcorneroftheoutputtables.InthecorrespondingboxpleaseselectonExcelsheetthecellwhichwillbetheupperleftcorneroftheresultstables.Whenyouselectdata,variablesalwaysneedtobestoredincolumns.Variableorcolumnlabelscorrespondto
16、thelabelsornamesoftheexplanatoryvariables.Ifyouselectthevariablelabelswithinthedatarangeyoumusttickthecorrespondingoption.Observationsorrowslabelscorrespondstothelabelsornamesofeachdataline.Ifyouselectthedatalabelswithinthedatarange,thenyoumustspecifytickthecorrespondingoption.NB:TheOutputsrangedoesnotneedtobeonthesa