Understanding Statistics					 J.R. Rasmussen

					Class 2 Outline

I) Last Class

	A) Any open items or questions?
	
	B) Web site http://faculty.washington.edu/jrras/bis315am.htm

II) Recap of last class

	A) Descriptive statistics

	B) Statistical inference
	
	C) Data
		1) categorical
		2) numerical
			a) discrete
			b) continuous
	D) Histogram


III) Descriptive statistics

	A) Histogram
		1) Work last class
		2) data on heights (in inches)

	B) Histograms and Excel

		1) Remember the computer won't bite & there are gremlins
		2) Loading Excel
		3) My observations on Excel
			a) cells first
			b) operations second
		4) Data input
			a)students input data from example 3.15, pg. 116
		5) How to draw histogram on Excel
			a) selecting where we want to draw the histogram
			b) tools/analysis/histogram menu
			c) histogram dialogue screen
			d) draw the histogram
		6) How to draw histogram if we have frequency table
			a) use a new spread sheet,
			b) enter the frequency table 3.1 on page 112
			c) highlight the area and use chart wizard
			d) What happened:  how to fix on Excel
			e) enter the frequency table 3.2 on page 113
			f) highlight the area and use chart wizard

	C) Averages, medians, & quartiles
		1) concepts, how to calculate, formulas  (calculator)
		2) how to do on Excel
			a) add to our spread sheet and save
IV) Break	


V) Group exercise: example 3.15 page 116

	A) Calculate average, median
	B) Group exercise: does this fit with the histogram

	
VI) Descriptive statistics continued
	
	D) Standard deviation
		1) concept, history, how to calculate, formula
			a) longhand  (do problem 4.31, sample 1 page 184)
			b) calculator
		2) how to do on Excel
		3) group exercise: do problem 4.31, sample 2 page 184
			a) Do "long hand" first
			b) Do on Excel
		4) group exercise: do standard deviation of example 3.15 data

VII Homework

	A) Remember Assignment 1 is due at the beginning of class on Wednesday Jan. 11, 2012