6 Using the Spreadsheet Viewer
6.1 Spreadsheet Overview
6.2 Manipulating, Filtering and Preparing Data Using the Spreadsheet
6.2.1 Dependent or Independent Variable?
6.2.2 Selecting a Dependent
6.2.3 Deactivating Unwanted Columns
6.2.4 Sorting Records
6.2.5 Plotting Individual Columns
6.2.6 Activating - Deactivating Row Data
6.2.7 Picking Random Record Sets
6.3 The File Menu
6.3.1 Save As - Exporting Data
6.3.2 Save As Comma-Delimited Text File
6.3.3 Save As DSF File
6.3.4 Save As PED/MAP Files
6.3.5 Save Family Data
6.3.6 Apply Gene Marker Map
6.3.7 Join Spreadsheet on Row Labels
6.3.8 Join Spreadsheets With Uneven Row Numbers
6.3.9 Join family-indexed spreadsheets
6.3.10 Join Spreadsheets by Sorting
6.3.11 Import a Legacy Tree Model
6.3.12 Closing the File
6.4 The Edit Menu
6.4.1 Row
6.4.2 Column
6.5 The Analysis Menu
6.5.1 Interactive Tree Analysis
6.5.2 Create a Multiple-Tree Model
6.5.3 Apply a Tree Model
6.5.4 Regression Analysis
6.5.5 Plot Numeric Columns
6.6 The Genetics Menu
6.6.1 Genetic Association Tests
6.6.2 Marker Statistics
6.6.3 Principal Component Analysis
6.6.4 EM Haplotype Frequency Estimation
6.6.5 HWE Plot
6.6.6 LD Plot
6.6.7 PBAT Family-Based Analysis
6.6.8 Runs of Homozygosity
6.6.9 Infer Missing Genotypes
6.7 The Help Menu
6.2 Manipulating, Filtering and Preparing Data Using the Spreadsheet
6.2.1 Dependent or Independent Variable?
6.2.2 Selecting a Dependent
6.2.3 Deactivating Unwanted Columns
6.2.4 Sorting Records
6.2.5 Plotting Individual Columns
6.2.6 Activating - Deactivating Row Data
6.2.7 Picking Random Record Sets
6.3 The File Menu
6.3.1 Save As - Exporting Data
6.3.2 Save As Comma-Delimited Text File
6.3.3 Save As DSF File
6.3.4 Save As PED/MAP Files
6.3.5 Save Family Data
6.3.6 Apply Gene Marker Map
6.3.7 Join Spreadsheet on Row Labels
6.3.8 Join Spreadsheets With Uneven Row Numbers
6.3.9 Join family-indexed spreadsheets
6.3.10 Join Spreadsheets by Sorting
6.3.11 Import a Legacy Tree Model
6.3.12 Closing the File
6.4 The Edit Menu
6.4.1 Row
6.4.2 Column
6.5 The Analysis Menu
6.5.1 Interactive Tree Analysis
6.5.2 Create a Multiple-Tree Model
6.5.3 Apply a Tree Model
6.5.4 Regression Analysis
6.5.5 Plot Numeric Columns
6.6 The Genetics Menu
6.6.1 Genetic Association Tests
6.6.2 Marker Statistics
6.6.3 Principal Component Analysis
6.6.4 EM Haplotype Frequency Estimation
6.6.5 HWE Plot
6.6.6 LD Plot
6.6.7 PBAT Family-Based Analysis
6.6.8 Runs of Homozygosity
6.6.9 Infer Missing Genotypes
6.7 The Help Menu
