1. If you are taking the course for credit or for a letter grade, you must complete the assignment.
2. In an Excel file, create examples showing the use of each of the following:
average |
standardize |
rand |
|
median |
rank |
ttest (two-sample assuming equal variances) |
|
var |
regression |
ttest (paired/matched) |
|
stdev |
one-way anova |
correl (Pearson) |
3. Excel statistics tools: Excel worksheet functions for statistics are described in Schmuller p. 23.
4. Email the Excel file to me at mwalker@stanfordalumni.org.
Course introduction.
Assignments
Statistics software.
How to describe data: Descriptive statistics.
Schmuller chapters 4,5,6.
What does statistically significant mean? Probability and p-values.
How to compare groups: T-tests
Schmuller chapter 9,10,11.
How to compare groups: Analysis of Variance (ANOVA)
How many subjects do I need? Sample size and power.
Schmuller chapter 14,15.
How to detect and quantify trends: Regression
How to measure association: Correlation
Schmuller chapter 14,15.
How to measure association: chi-square test
Non-parametric tests (for non-normal distributed data)
Design of Experiments
Schmuller chapter 10,19,20.
topSchmuller, Joseph
Stanton Glantz. (McGraw-Hill)
Descriptive Statistics Examples
Permutation example for pvalues