Standard Deviation for each value in a column

[khannadh]

Hello,
I have a column of value that represents number of survey responses for each hotel (7,000 hotels as rows).
I want to calculate standard deviation for each row (value in the column) to see which hotels have responses within 1 SD and which ones have response beyond one SD.

How can I do that?
Any help is appreciated.

Thank You

 

[JGordon11]

Book1 (version 1).xlsb
	A	B	C	D	E	F	G
1	Hotel	Responses	# SDs from mean		SD	30.95396
2	A	1	-1.537767922		Mean	48.6
3	B	47	-0.051689678
4	C	4	-1.440849775
5	D	16	-1.05317719
6	E	83	1.111328078
7	F	31	-0.568586458
8	G	72	0.755961541
9	H	65	0.5298192
10	I	22	-0.859340897
11	J	62	0.432901054
12	K	18	-0.988565093
13	L	2	-1.505461873
14	M	84	1.143634127
15	N	81	1.04671598
16	O	83	1.111328078
17	P	76	0.885185736
18	Q	28	-0.665504605
19	R	54	0.174452663
20	S	92	1.402082517
21	T	51	0.077534517
22
Sheet4

Cell Formulas
Range	Formula
C2:C21	C2	=(B2:B21-Mean)/SD
F1	F1	=STDEV.S(B2:B21)
F2	F2	=AVERAGE(B2:B21)
Dynamic array formulas.

Named Ranges
Name	Refers To	Cells
Mean	=Sheet4!$F$2	C2
SD	=Sheet4!$F$1	C2