Course updates
Final exam pick up:
For those who signed the Buckley waiver: Blue file cabinets on second floor of Econ BldgFor those who did not: undergrad office on presentation of ID
The distribution of grades for the final exam:
| Question 1 | Question 2 | Midterm | |
| Mean | 30.1 | 38.7 | 69.1 |
| Min | 0 | 0 | 9 |
| Q1 | 21 | 32 | 57 |
| Median | 31 | 39 | 69 |
| Q3 | 39 | 46 | 83 |
| Max | 53 | 59 | 107 |
| StdDev | 12 | 10 | 17 |
| Sample Variance | 135.2 | 101 | 282.1 |
| Kurtosis | -.7 | .4 | 0 |
| Skewness | -.2 | -.5 | -.2 |
The distribution of grades for the midterm:
| Question 1 | Question 2 | Midterm | |
| Mean | 23.6 | 31.3 | 54.9 |
| Min | 0 | 4 | 23.5 |
| Q1 | 14.5 | 27 | 44 |
| Median | 24.25 | 32 | 55 |
| Q3 | 32.1 | 36 | 64.6 |
| Max | 50 | 46 | 93 |
| StdDev | 11.9 | 7 | 14.6 |
| Sample Variance | 141.1 | 49 | 213.4 |
| Kurtosis | -.68 | 1.13 | -.47 |
| Skewness | .01 | -.74 | .08 |
Homework format: please print out all your results and graphs from Excel and include them with your written answers. Ideally, your group would create a Word document with output results, graphs and written answers.
A practice dataset was added to the "Data" section of the website.
Course Materials
Quick Statistics Using Microsoft Excel
Data
Here is the spreadsheet created in class on 12/4/07.
Here is the spreadsheet created in class on 11/29/07.
Here is the spreadsheet created in class on 11/27/07.
Here is the spreadsheet created in class on 11/01/07.
Here is the spreadsheet created in class on 10/18/07.
Here is the spreadsheet created in class on 10/16/07.
Here is the spreadsheet created in class on 10/4/07.
Here is the spreadsheet created in class on 10/2/07. As a study aid, see if you can replicate this on your own.