BASIC STATISTICS IN EXCEL |
|
| BASIC EXCEL | |
| Introduction | |
| How to run Excel | |
| Data Structures | |
| The Excel spreadsheet | |
| Importing data | |
| EXPLORING DATA (ONE VARIABLE) | |
| Histograms | |
| Numerical Summaries | |
| Scatter plots | |
| Transforming data | |
| EXPLORING DATA (SEVERAL VARIABLES) | |
| Scatter plots and Correlation | |
| Tabulation (1) | |
| Tabulation (2) | |
| 3-way relationship graphs | |
| Filtering | |
| SAMPLES AND VARIABILITY | |
| Introduction | |
| SIGNIFICANCE TESTING AND T-TESTS | |
| Introduction | |
| Significance Testing | |
| One sample T-tests | |
| Two sample T-tests | |
| ANALYSIS OF VARIANCE | |
| Introduction | |
| One-way ANOVA | |
| Two-way ANOVA | |
| REGRESSION | |
| Introduction | |
| Simple linear regression | |
| Regression options | |
References |
|