Data Manipulation in GenStat.doc

《Data Manipulation in GenStat.doc》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

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