|
» Home
» Syllabus (36
KB PDF)
» Data Sources and Leads
» Assignments
» SPSS and Excel Help
» Exams From Previous Years and Sample Papers
» Stats Writing Tips
» Anonymous Email
» e-reserves
Instructor:
Rachel Garshick Kleit
kleit@u.washington.edu
P: 206.221.3063
Office: Parrington 209C
Office Hrs: T,Th 1:30-2:30pm, T 4:30-5:30 pm & by
appointment
Class Information:
Class Meeting Times:
T 6-8:50, Balmer 302
Teaching Assistant:
Tyler Davis
tbdavis@u.washington.edu
Office: Parrington 124D
Office Hrs: T 5-6, F 12:30-1:30
Review Sessions:
W 12:30 - 1:20 Par 305
W 6:30 - 7:20 BLM 212
Th 3:00 - 3:50 Par 213
|
Quantitative Analysis II
PBAF 528 — Spring 2008
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).
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 (returns a p-value--no table necessary)
NORMSDIST worksheet function (returns a z-value--no table necessary)
NORMSINV worksheet function (returns a p-value--no table necessary)
PERCENTILE worksheet function
QUARTILE worksheet function
STANDARDIZE worksheet function
STDEV worksheet function
STDEVA worksheet function
STDEVP worksheet function
STDEVPA worksheet function
TDIST worksheet function (returns a p-value--no table necessary)
| Top |
SPSS
» CSSCR's Introduction
to SPSS (Version 13.0) (link)
» Each homework problem set has SPSS directions for particular SPSS
tasks.
| Top |
|
