Working out the standard deviation and standard error for a sample:	Raw scores:	STEP 1: Each raw score minus the mean:		STEP 2: square these differences from the mean:	STEP 3: Add the squared differences together:	STEP 4: Divide STEP 3 by n-1:	STEP 5: Take the square root of STEP 4, to get the standard deviation:
	3	3 - 4.8 =	-1.8	3.24
(a) first work out the mean for the scores;	4	4 - 4.8 =	-0.8	0.64
(b) then work out the standard deviation;	5	5 - 4.8 =	0.2	0.04
(c) then work out the standard error (which is the standard	6	6 - 4.8 =	1.2	1.44
deviation divided by the square root of the number of subjects)	6	6 - 4.8 =	1.2	1.44
					6.8	1.7	1.303840481
sample mean (= AVERAGE B2:B6)):	4.8
standard deviation (=STDEV B2:B6):	1.30384048
standard error of the mean: (in Excel there is no shorthand formula for the standard error, so just work out the s.d. using the STDEV  formula, and then divide the result of this by the square root of the number of subjects minus one:	0.58309519