QUARTILE

In order to use the QUARTILE formula, start with your edited Excellentable

Then type in the QUARTILE Formula in area you would like to display the outcome:

Type in the complete QUARTILE formula for a cell as shown below:

Excellentable will generate the outcome when hitting enter. 

	A	B	C	D
1	State	Data	Mean	Probability
2	Alabama	1	4	0.2
3	Alaska	2	3	0.3
4	Arizona	4	5	0.1
5	Arkansas	7	10	0.4
6	California	8	2	0.65
7	Colorado	9	9	0.35
8	Connecticut	10	1	0.25
9	Delaware	12	7	0.01
10	Florida	1	8	0.7
11	Georgia	1	40	1.5
12	Hawaii	1	10	0.25
13
14		3.5