Index
General training page
Excel training page
Excel
Entering data
The formula =PROPER
Getting the full dataset
Descriptive statistics
Results
Mean
Median
Mode
Standard error
Variance
Standard deviation
Sum
Count
Min/Max
Range
Skewness
Kurtosis
Pivot tables
Graphs (links)
One-way ANOVA
Comparing means and proportions (excel file)
Stata
Creating a log file
From Excel to Stata
Exploring data
Frequencies (tab)
Crosstabs
Tab1
Describe
Summarize
Tabstat
Tab/
summ
Proper
One-way ANOVA
Rolling standard deviation
T-test
Some graphs
Scatter
Regression
Quadrants
Histogram
Bar
Categorical
R
Summary tables (Excel, Stata, R)
Location
Variability
Distribution
Indicators
Z-scores
Confidence intervals
Coefficient of variation
Examples
Excel
Stata
R
Other tutorials
Linear regression
(Stata)
Linear regression
(R)
Panel data (fixed/random effects)
(Stata)
Panel data (fixed/random effects)
(R)
Multilevel analysis
Data preparation & Descriptive Statistics
Finding data (w/comments on crafting research questions)
Times Series
Logit
& Ordered
logit
regression
Factor analysis
Additional sources
References