Index

• General training page
• Excel training page
• Excel
• Entering data
• The formula =PROPER
• Getting the full dataset
• Descriptive statistics
1. Results
2. Mean
3. Median
4. Mode
5. Standard error
6. Variance
7. Standard deviation
8. Sum
9. Count
10. Min/Max
11. Range
12. Skewness
13. Kurtosis
• Pivot tables
• Graphs (links)
• One-way ANOVA
• Z-test for proportions (excel file)
• Stata
• Creating a log file
• From Excel to Stata
• Exploring data
1. Frequencies (tab)
2. Crosstabs
3. Tab1
4. Describe
5. Summarize
6. Tabstat
7. Tab/summ
8. Proper
• One-way ANOVA
• T-test
• Some graphs
1. Scatter
1. Regression
2. Quadrants
2. Histogram
3. Bar
4. Categorical
• References