 |
» Home
» 2005 Syllabus (21 KB PDF)
» Syllabus
» Overheads
» Homework
» Stats Writing Tips
» Examples of Papers and Exams from Previous Years
» Washington State Population Survey Links
» SPSS and Excel Help
» Anonymous Email (link)
Instructor:
Rachel Garshick Kleit
kleit@u.washington.edu
P: 206.221.3063
Office: Parrington 209C
Office Hrs: Th 2:15-4:15 & by appointment
Class Information:
Class Meeting Times:
Th 4:30-7:30, Smith 404
Teaching Assistant:
Siri Erickson-Brown
sirieb@u.washington.edu
Office: Parrington 124D
Office Hrs: M 9:30-11:30 & by appointment
Review Session:
W 5-6pm, Parr 305 (also Parr 322 W 1-2pm)
|
|
Quantitative Analysis I
PBAF 527 — Winter 2005
SPSS and Excel Help
Skip to:
• Excel
• SPSS
Excel
If you've never used Excel before, start here (link).
For some help with Excel and statistics, click here (614 KB PDF).
Here's a user-friendly
page for HIV/AIDS CBOs that explains how to use Excel for evaluation. For those of you who are thinking about data that is primarily discrete, the instructions on how to use Pivot Tables are essential.
Excel has lots of worksheet functions. I've listed some that may be useful for this class below. For detailed instructions on how to use them, see Excel's help pull-down menu.
| Top |
AVERAGE worksheet function
CONFIDENCE worksheet function
COUNT worksheet function
FREQUENCY worksheet function
MEDIAN worksheet function
MIN worksheet function
MINA worksheet function
MODE worksheet function
NORMDIST worksheet function
NORMINV worksheet function
NORMSDIST worksheet function
NORMSINV worksheet function
PERCENTILE worksheet function
QUARTILE worksheet function
STANDARDIZE worksheet function
STDEV worksheet function
STDEVA worksheet function
STDEVP worksheet function
STDEVPA worksheet function
TDIST worksheet function
| Top |
SPSS
» CSSCR's Introduction to SPSS (link)
» Evans' School SPSS Help Pages (link)
| Top |
|
|
