If you are taking the course for credit or for a letter grade, you must complete the assignment.
In an Excel file, create examples showing the use of each of the following Excel worksheet functions.
Worksheet functions are described in Schmuller p. 23.
average |
max |
|
median |
min |
|
var |
rand |
|
stdev |
ttest (two-sample assuming equal variances) |
|
standardize |
ttest (paired/matched) |
|
rank |
correl (Pearson) |
In the same Excel file create examples showing the use of each of the following menu items from the Tools/Data Analysis menu.
Described in Schmuller p. 31.
ANOVA: Single factor |
Regression |
|
Correlation |
Sampling |
|
Descriptive Statistics |
t-test: Paired two sample for means |
|
Random Number Generation |
t-test: two-sample assuming equal variances |
Find three newspaper or magazine articles that contain incorrect or misleading analysis or presentation of statistics.
For each article, hand in a copy of the article and a short critique of the incorrect or misleading analysis or presentation of statistics in the article.
Email the Excel file to me, mwalker@stanfordalumni.org.
Hand in the three newspaper or magazine articles and your critique of the articles on the last day of class.
Write your name on your critique.
Course introduction.
Assignments
Statistics software.
How to describe data: Descriptive statistics.
Phillips chapter 3,4,5,8
Schmuller chapter 4,5,6.
What does statistically significant mean? Probability and p-values.
How to compare groups: T-tests
Phillips chapter 7,8,9
Schmuller chapter 9,10,11.
How to compare groups: Analysis of Variance (ANOVA)
How many subjects do I need? Sample size and power.
Phillips chapter 10
Schmuller chapter 14,15.
How to detect and quantify trends: Regression
How to measure association: Correlation
Phillips chapter 6,11
Schmuller chapter 14,15.
How to measure association: chi-square test
Non-parametric tests (for non-normal distributed data)
Common errors in statistical analyses
Phillips chapter 10
Schmuller chapter 10,19,20.
topPhilips, John L.
Schmuller, Joseph