資源描述:
《Data Manipulation in GenStat.doc》由會(huì)員上傳分享,免費(fèi)在線閱讀,更多相關(guān)內(nèi)容在教育資源-天天文庫。
1、57DATAMANAGEMENTinGenStatDataManipulationinGenStatDavidBairdAgResearch,Box60,LincolnContentsInitialSettings3SpreadsheetOptions3SettingtheWorkingDirectory4SavingthecurrentGenStatSession6RestartingtheGenStatSession6ReloadingtheGenStatSession6Session1:DataInput7UnderstandingFactorsandotherDatatypes7
2、EnteringDataintoaSpreadsheet8SpecifyingaFactorColumninaSpreadsheet11DataVerification12SavingtheSpreadsheet13PrintingtheSpreadsheet13SendingtheSpreadsheetDatatotheServer13RecalculatingColumns14SelectionswithinSpreadsheets15MovingColumnsorRows16DeletingColumnsorRows16InsertingColumnsorRows16Convers
3、ionbetweendatatypes16Exercise:DataEntry17DateswithinGenStat18ReadingExcelData19DataformatinExcel19NamedRangesinExcel20ReadingdatadirectlyfromanExcelfile20TransferringDataviatheClipboard21Exercise:ReadingdatafromExcel22ReadingotherFileFormats22Exercise:ReadingForeignDataSets22SPLOADprocedure22Exam
4、plesofSPLOAD22IMPORTprocedure23ExamplesofIMPORT23ReadingDatainTextfilesintoGenStat24ReadingDatainTextfilesintoGenStat24Exercise:ReadingTextfiles25Session2:ManipulationofDatawithGenStat26Stack26Unstack26CombinedUseofStackandUnstack2757DATAMANAGEMENTinGenStatCalculatingSummaryStatistics29Example:Ag
5、gregatingresultsoverunits29Example:ExpandingtoallFactorCombinations29AppendingdatatoSheets30ExcelExample30MergingSheets31Exercise:DataManipulation32PasteSpecial33Ablockofdatacanbepasteddownonecolumninaspreadsheet.33Groupsofvaluesinarowcanbepastedintomultiplerows.33Restrictions/Filtering34Bookmark
6、sandComments35Temporarymissingvalues35Session3:DataExport36SavingDatabacktoExcel36UsingtheClipboard36UsingtheFile>SaveorSpread>Sheet>AddtoExcelfilemenus36UsingtheEXPORTprocedure36ExportExamples36Exercise:TransferringdatatoExcel36Useofthe%WSPREADprocedure37CreatingnewSpreadsheetsfromtheServer37Exa
7、mpleofCreatingaSpreadsheet37AddinginnewColumnsfromtheServer37ExampleofAddingColumnstoanExistingSpreadsheet38Creatingspreadsheetsfromothermenus38TabulatingandDisplayingTablesofResults38TransferringResultsintoWord39Addin