Mean & Std. Dev of Middle 80%

[z946137]

Hi guys,

I have a column of data (column H), and I'm trying to take the average & standard deviation of just the middle 80%. I can't seem to figure out how to do this.

Thank you all for your time!

 

[AhoyNC]

These are array formulas and must be entered with CTRL-SHIFT-ENTER.

Excel Workbook
	H	I	J
1	Data	Middle 80%
2	37	Average	102.7143
3	41	Std.	36.73277
4	48
5	56
6	62
7	75
8	87
9	88
10	91
11	117
12	118
13	119
14	121
15	126
16	165
17	165
18	170
19	198
Sheet