Module: Examining Column
Relationships
|
|
| Lesson Objective | Learn how to compare numerical columns pair-wise using a linear regression, compare categorical columns pair-wise using a chi-square test, and compare numerical vs. categorical columns pair-wise using an ANOVA |
| Section | Description |
| Column Relationships | A description of the capabilities and utility of the Column Relationships tool. How to launch the tool. |
| The Column Relationships Dialog Box | Determining the appropriate statistics for your comparison (Linear regression, Anova, Chi-square) based upon numeric and categorical data columns. How to select columns for comparison and restrict the calculations to the selected records. |
| Results of Column Relationships Calculations | A detailed discussion regarding the results of each statistical comparison calculation: Linear regression results – relating to scatter plots, Anova results – relating to scatter plots or evaluating further with box plots and comparison circles, and Chi-square results – relating to pie charts. |
| Returning to Previous Calculations | How to return to the results obtained from previous calculations. |
| Performing New Calculations | How to perform new calculations. |
| Exporting Data from the Column Relationships Table | How to export data to other applications using a Copy & Paste approach. |
| Learning More about each Calculation | How to obtain additional information about the Column Relationships tool functionality, algorithms, etc. |
Print