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.14, pg. 97
		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.7 on page 107
			c) highlight the area and use chart wizard
			d) What happened?  
			e) How to fix the problem using Excel

	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.14 page 97

	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.28, sample 1 page 161)
			b) calculator
		2) how to do on Excel
		3) group exercise: do problem 4.28, sample 2 page 161
			a) Do "long hand" first
			b) Do on Excel
		4) group exercise: do standard deviation of example 3.14 data

VII Homework

	A) Remember Assignment 1 due at the beginning of class on Wednesday Oct. 7, 2009