Skip to main content

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.