add remove language chart show hidden hide
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
x
77.8
78.6
76.5
65.8
74.5
75.1
77.3
69.4
78.2
69.2
63
73.2
73.2
73.7
70
79.3
73
72.5
75.9
84.6
75.7
73.9
74
80.4
73.6
79.9
77.1
85.8
68.6
76
71.9
69.9
76.2
73
74.4
71.5
77.6
73.9
80.3
71.7
79
68.6
71.2
76.7
77.8
69.2
72.8
81.7
76.2
69.8
75
70.5
71.9
70.9
63.1
73.7
79.5
73.3
76
72.9
76
73.2
75.9
73.2
77.2
60.5
76.7
63.1
72.6
73.8
80
81.8
79.4
76.9
78.1
79.1
79.2
73.5
79.1
88.5
76.4
80.5
70.3
76
69.6
80.1
74.2
78.8
74.3
76.3
74
81.6
75.4
73
69.4
74.1
79.1
78.2
67.7
89.2
70.3
71.3
74.6
69.6
71.5
69.6
77.1
66.1
71
71.5
75.7
76.2
72.3
76.3
74.4
86
71.4
75.5
73
82.8
85.1
73.7
77.3
84.4
70.4
78
80.9
78.4
82.4
74.3
76
75
77.8
67.6
75.5
80.9
78.1
70.9
74.1
77.2
72.8
77.1
84.3
74.5
69.8
77.5
76.4
75.4
70
70.9
76
64.7
80.2
82.9
80
70.9
74.9
77.5
78.2
74.2
71.8
75.6
84.8
67.3
80.2
75.1
79.3
69.2
75.3
66.8
72.6
72.6
77.2
76.3
72.3
77.8
72.6
78.8
75.4
62.8
78
77.4
79.2
75.6
71.7
81.8
76.5
80.1
79.3
70.8
82.5
74.2
78.1
74.1
76.8
74.7
62.6
62.9
77.7
58.5
69.6
74.8
76.2
80.1
73.4
75.6
80.5
74.1
80.3
78.8
86.8
77
72.7
74.3
68.7
73.9
77.4
84.7
76.3
84.4
70.6
77.4
78.7
76.8
79.6
72.3
73.4
75.2
80.9
83.3
76.9
77
71.2
77.2
71.7
76.1
72
71.5
76.9
79.2
85.4
84
78
73.4
73.3
75.5
80.1
78.2
79.3
69.7
79.3
78.3
72.3
72.3
74.9
73.4
71.4
74
71.6
80.6
72.5
80.1
74
70.8
68
66.2
73.8
75.1
75.2
73.4
74.5
71.3
73
86.2
73.6
77.2
71.7
78.8
72.5
75.6
76.6
77.4
84.8
72.4
72.9
70.7
86.6
80.4
73.6
77.9
77.6
72.2
72
79.4
75.4
70.9
73.1
88.3
74.8
80.6
71.4
69.8
70.3
73.6
74.4
81.3
71.4
79.3
79.3
77.3
73
77.1
71.5
72
81.1
76.3
69.8
75.5
77.7
80.4
78.3
78.2
77.8
73.2
82.3
77
70.8
64.9
70.4
73
78.2
73
71.5
68.6
69.5
84.7
78
80.4
72.6
79.8
76.6
72.5
66.1
80.4
71.3
73.5
83.9
79.7
60.1
75.8
73.7
77.2
76.7
69.1
76.4
72.7
73.9
76.5
69.6
74.7
81.2
74.5
80.6
75.7
73.8
73.4
79.6
70.3
77.9
73.6
80
73.7
69.5
76.4
79.2
76.5
72.3
70.1
69.1
75.5
73.4
80.9
67
72.7
81.8
78.3
76.2
83
79.2
69.2
72.5
74.1
76.3
88.3
74.6
79.3
65.2
74.3
75
75.7
81.8
79.6
77.8
75.3
77.1
73.7
75.7
81.1
79
68.9
76.8
71
70.6
85.6
72.5
72.7
70.3
75.5
80.5
63.3
70.9
72.2
70.7
74.7
80.6
82.7
73.4
72.3
71.9
78.8
74.3
74.1
65.2
71.6
66.4
77.1
74.8
71.6
70
78.9
74.4
75.7
77.3
75.7
81.8
67.6
78.9
74.4
67.2
80.2
68.2
77.9
72.7
74.9
80.5
57.4
83.7
77.1
76.9
73.4
69.4
72.1
70.4
70.4
71.7
79
69.5
78.6
71.3
67.2
71.3
80.7
74
77.8
83.4
79.9
73.4
68.9
76.5
60.8
66.5
70.5
72.4
73.6
67
75.1
79
78.8
78.1
77.2
69.9
75.3
79.9
75.9
84.9
71
71.9
73.8
83
80.2
80.4
85.3
74
76.2
70.1
81.9
82.5
77.8
81
76.3
78.7
69.1
77.6
66.7
77.7
79.6
69.2
75.2
68.4
72.8
77.9
74.5
72.6
81.1
73.7
85.7
71.9
80.1
70.7
78.2
77.5
76.4
69.5
72.8
72.7
79.7
70.1
75.6
70.4
80.8
75.6
73.6
73.2
75.6
69.8
80.1
75.2
85.6
68.9
73.5
80.1
73.8
78.3
82
73.9
69.7
70.5
73.6
84.9
70.8
78.8
88.2
75
70.3
66.8
85.5
75.5
72.7
64.8
76.8
76.2
72.4
77.3
63
74.4
77.5
87.2
72.6
72.3
78
80.7
82.8
72.9
82.3
81.3
73.7
68.1
75.7
75.6
74.5
85.3
79.8
83.2
68
71.7
71.8
80.7
81.9
85.5
73.3
74
78.6
73.1
77.6
74.5
81.3
78.4
75.4
72.3
71
75
76
84.9
67.6
76.7
81.4
75.7
66.8
67.8
75
74.7
77.7
75.4
80.5
68.9
68.6
80.8
73
71.7
79.9
78.6
72.4
78.1
74.4
71.8
68
71
70
76
75.1
79.1
80.7
76.2
74.9
75.9
67.6
77.3
71
73.4
76
73
67.8
80.7
83
73.1
73.3
72.2
78.2
76.2
70.8
76.1
75.8
67.2
80
80.8
72.7
72.4
72.1
71.2
73.7
72.7
73.4
79.9
73.7
71.4
77.5
69.2
80.2
70.7
73.9
72.6
81.7
75.2
82.7
69.6
70.8
78.4
82.7
73
66.6
75.7
80.4
75
79.1
78
84.7
67.1
70.4
74.6
80.3
77.3
75.8
72.5
68.5
77.4
74
75.6
72
69.7
71.8
67.2
77.7
67.3
65.2
75.1
71.5
65
76.1
80.2
80.7
79.2
71.8
71.3
73.8
73.2
71.4
76.2
74.6
79.6
81.3
73.1
81.1
76.3
87.9
67
66.8
72.3
72.8
65.2
77.2
80.5
74.8
73.6
78.1
75.8
73
69
74.2
84
80.4
67.2
66.6
68.4
75.6
67.5
72.5
73.8
75.9
70.2
72.9
78.7
78.6
74.8
81.7
72.2
77.9
74
72.4
75.5
66.1
71.8
74.9
74
72.3
70.2
73.9
67.2
74.3
78.2
71.7
79.5
75.5
68
81.1
74.9
76
84.9
72.6
74.7
73.8
76.5
72.3
66.6
72.1
75.3
81.7
75.8
86.5
67.7
78.4
75.8
73.9
77.4
75.9
80.9
77
73.3
72.5
74.7
73.5
71.3
72
74.8
67.5
80.4
80.1
76.4
75.7
75.6
67.3
81.7
80.9
77.9
70.3
80.2
87.2
76.4
75.6
60.6
74.2
70
80.7
83.2
80.6
73.2
64.9
80
70.7
66.9
69.3
76.4
74.8
75.4
78.2
63.2
76.1
68.4
83
72.1
73.7
75.8
83.2
70.3
79.9
77.2
59.1
81
74.5
79.2
72
69.5
73.6
64.7
79.9
73.8
71.4
77.1
74.2
81.7
69.2
75.8
70.5
78.3
71.4
73.7
74
69.8
83.9
72.1
67.1
69.8
76.6
74.4
74.8
72.7
75
72
71.1
72.7
78.7
79.2
72.9
72.7
76.4
71.8
80.2
75.2
75.2
67.1
78.7
75.8
73
76.5
74.8
58
82
78.7
70.2
73.2
71.6
78.6
75.2
79.5
76.9
71.5
80.6
78.4
77.5
82.3
72.6
62.2
76.9
75.3
72
74.3
73.9
72.4
70.2
69.7
78.2
81
86.2
73.9
77.1
77.9
81.7
80.5
72.4
74.9
71.4
71.4
85.6
76.1
76
76.7
72.2
76.1
77.3
78.6
82.4
72.1
79.9
76
76.7
70.1
73.1
74
77.5
79.6
78.6
78.8
74
89.8
76.1
71.5
78.7
71.4
77.2
72.1
73.7
83.4
69.7
79.5
79.7
67.4
83.9
76.1
75.5
69.6
76.8
73.7
78.6
75.6
79.2
70.3
75.9
79.9
82.5
77.6
68.1
73.9
80
74.3
75
73.4
86.2
66
75.5
73.5
80.2
P
0.01
0.02
0.03
0.04
0.05
0.06
0.07
0.08
0.09
0.1
0.11
0.12
0.13
0.14
0.15
0.16
0.17
0.18
0.19
0.2
0.21
0.22
0.23
0.24
0.25
0.26
0.27
0.28
0.29
0.3
0.31
0.32
0.33
0.34
0.35
0.36
0.37
0.38
0.39
0.4
0.41
0.42
0.43
0.44
0.45
0.46
0.47
0.48
0.49
0.5
0.51
0.52
0.53
0.54
0.55
0.56
0.57
0.58
0.59
0.6
0.61
0.62
0.63
0.64
0.65
0.66
0.67
0.68
0.69
0.7
0.71
0.72
0.73
0.74
0.75
0.76
0.77
0.78
0.79
0.8
0.81
0.82
0.83
0.84
0.85
0.86
0.87
0.88
0.89
0.9
0.91
0.92
0.93
0.94
0.95
0.96
0.97
0.98
0.99
1
Median
75 
Msg 8726 Level 16 State 1 Line 1
Input parameter of PERCENTILE_CONT function must be a constant.
tile (No column name)
1 62.6
2 64.7
3 66
4 66.7
5 67.1
6 67.3
7 67.8
8 68.4
9 68.9
10 69.2
11 69.5
12 69.7
13 69.8
14 70.1
15 70.3
16 70.4
17 70.7
18 70.9
19 71.1
20 71.3
21 71.4
22 71.5
23 71.7
24 71.9
25 72
26 72.2
27 72.3
28 72.4
29 72.5
30 72.6
31 72.7
32 72.8
33 73
34 73.1
35 73.2
36 73.4
37 73.4
38 73.6
39 73.7
40 73.8
41 73.9
42 74
43 74
44 74.2
45 74.3
46 74.4
47 74.6
48 74.8
49 74.9
50 75
51 75.2
52 75.3
53 75.5
54 75.5
55 75.6
56 75.7
57 75.8
58 75.9
59 76
60 76.1
61 76.2
62 76.4
63 76.5
64 76.7
65 76.9
66 77.1
67 77.2
68 77.3
69 77.4
70 77.6
71 77.8
72 77.9
73 78.1
74 78.2
75 78.3
76 78.6
77 78.7
78 78.8
79 79.1
80 79.2
81 79.4
82 79.6
83 79.9
84 80
85 80.2
86 80.3
87 80.4
88 80.6
89 80.7
90 81
91 81.3
92 81.7
93 82
94 82.7
95 83.2
96 84
97 84.9
98 85.6
99 86.6
100 89.8
P x prank x prank (No column name)
0.01 62.6 0.00900900900900901 62.8 0.01001001001001 62.798
0.02 64.7 0.018018018018018 64.8 0.02002002002002 64.799
0.03 66 0.029029029029029 66.1 0.03003003003003 66.097
0.04 66.7 0.039039039039039 66.8 0.04004004004004 66.796
0.05 67.1 0.048048048048048 67.2 0.0510510510510511 67.165
0.06 67.3 0.0570570570570571 67.4 0.0600600600600601 67.398
0.07 67.8 0.0690690690690691 68 0.0710710710710711 67.893
0.08 68.4 0.0780780780780781 68.5 0.0810810810810811 68.464
0.09 68.9 0.0870870870870871 69 0.0910910910910911 68.97275
0.1 69.2 0.0950950950950951 69.3 0.102102102102102 69.27
0.11 69.5 0.106106106106106 69.6 0.111111111111111 69.5778
0.12 69.7 0.118118118118118 69.8 0.123123123123123 69.7376
0.13 69.8 0.123123123123123 69.9 0.13013013013013 69.8981428571429
0.14 70.1 0.137137137137137 70.2 0.141141141141141 70.1715
0.15 70.3 0.145145145145145 70.4 0.154154154154154 70.3538888888889
0.16 70.4 0.154154154154154 70.5 0.16016016016016 70.4973333333333
0.17 70.7 0.166166166166166 70.8 0.171171171171171 70.7766
0.18 70.9 0.177177177177177 71 0.183183183183183 70.947
0.19 71.1 0.189189189189189 71.2 0.19019019019019 71.181
0.2 71.3 0.193193193193193 71.4 0.2002002002002 71.3971428571429
0.21 71.4 0.2002002002002 71.5 0.211211211211211 71.489
0.22 71.5 0.211211211211211 71.6 0.22022022022022 71.5975555555555
0.23 71.7 0.224224224224224 71.8 0.232232232232232 71.772125
0.24 71.9 0.239239239239239 72 0.244244244244244 71.9152
0.25 72 0.244244244244244 72.1 0.252252252252252 72.071875
0.26 72.2 0.259259259259259 72.3 0.264264264264264 72.2148
0.27 72.3 0.264264264264264 72.4 0.276276276276276 72.34775
0.28 72.4 0.276276276276276 72.5 0.284284284284284 72.4465
0.29 72.5 0.284284284284284 72.6 0.293293293293293 72.5634444444444
0.3 72.6 0.293293293293293 72.7 0.303303303303303 72.667
0.31 72.7 0.303303303303303 72.8 0.315315315315315 72.75575
0.32 72.8 0.315315315315315 72.9 0.32032032032032 72.8936
0.33 73 0.325325325325325 73.1 0.338338338338338 73.0359230769231
0.34 73.1 0.338338338338338 73.2 0.343343343343343 73.1332
0.35 73.2 0.343343343343343 73.3 0.352352352352352 73.2738888888889
0.36 73.4 0.357357357357357 73.5 0.37037037037037 73.4203076923077
0.37 73.4 0.357357357357357 73.5 0.37037037037037 73.4971538461539
0.38 73.6 0.375375375375375 73.7 0.385385385385385 73.6462
0.39 73.7 0.385385385385385 73.8 0.399399399399399 73.7329285714286
0.4 73.8 0.399399399399399 73.9 0.408408408408408 73.8066666666667
0.41 73.9 0.408408408408408 74 0.419419419419419 73.9144545454545
0.42 74 0.419419419419419 74.1 0.432432432432432 74.0044615384615
0.43 74 0.419419419419419 74.1 0.432432432432432 74.0813076923077
0.44 74.2 0.438438438438438 74.3 0.444444444444444 74.226
0.45 74.3 0.444444444444444 74.4 0.452452452452452 74.369375
0.46 74.4 0.452452452452452 74.5 0.46046046046046 74.49425
0.47 74.6 0.468468468468468 74.7 0.472472472472472 74.63825
0.48 74.8 0.478478478478478 74.9 0.487487487487487 74.8168888888889
0.49 74.9 0.487487487487487 75 0.494494494494495 74.9358571428571
0.5 75 0.494494494494495 75.1 0.503503503503503 75.0611111111111
0.51 75.2 0.509509509509509 75.3 0.517517517517518 75.206125
0.52 75.3 0.517517517517518 75.4 0.522522522522523 75.3496
0.53 75.5 0.529529529529529 75.6 0.540540540540541 75.5042727272727
0.54 75.5 0.529529529529529 75.6 0.540540540540541 75.5950909090909
0.55 75.6 0.540540540540541 75.7 0.553553553553554 75.6726923076923
0.56 75.7 0.553553553553554 75.8 0.564564564564565 75.7585454545455
0.57 75.8 0.564564564564565 75.9 0.573573573573574 75.8603333333333
0.58 75.9 0.573573573573574 76 0.580580580580581 75.9917142857143
0.59 76 0.580580580580581 76.1 0.592592592592593 76.0784166666667
0.6 76.1 0.592592592592593 76.2 0.600600600600601 76.1925
0.61 76.2 0.600600600600601 76.3 0.610610610610611 76.2939
0.62 76.4 0.618618618618619 76.5 0.627627627627628 76.4153333333333
0.63 76.5 0.627627627627628 76.6 0.634634634634635 76.5338571428571
0.64 76.7 0.637637637637638 76.8 0.643643643643644 76.7393333333333
0.65 76.9 0.648648648648649 77 0.654654654654655 76.9225
0.66 77.1 0.658658658658659 77.2 0.667667667667668 77.1148888888889
0.67 77.2 0.667667667667668 77.3 0.677677677677678 77.2233
0.68 77.3 0.677677677677678 77.4 0.685685685685686 77.329
0.69 77.4 0.685685685685686 77.5 0.691691691691692 77.4718333333333
0.7 77.6 0.698698698698699 77.7 0.703703703703704 77.626
0.71 77.8 0.708708708708709 77.9 0.716716716716717 77.816125
0.72 77.9 0.716716716716717 78 0.723723723723724 77.9468571428571
0.73 78.1 0.72972972972973 78.2 0.735735735735736 78.1045
0.74 78.2 0.735735735735736 78.3 0.746746746746747 78.2387272727273
0.75 78.3 0.746746746746747 78.4 0.751751751751752 78.365
0.76 78.6 0.756756756756757 78.7 0.765765765765766 78.636
0.77 78.7 0.765765765765766 78.8 0.772772772772773 78.7604285714286
0.78 78.8 0.772772772772773 78.9 0.780780780780781 78.89025
0.79 79.1 0.786786786786787 79.2 0.791791791791792 79.1642
0.8 79.2 0.791791791791792 79.3 0.800800800800801 79.2911111111111
0.81 79.4 0.808808808808809 79.5 0.810810810810811 79.4595
0.82 79.6 0.814814814814815 79.7 0.820820820820821 79.6863333333333
0.83 79.9 0.825825825825826 80 0.834834834834835 79.9463333333333
0.84 80 0.834834834834835 80.1 0.840840840840841 80.086
0.85 80.2 0.84984984984985 80.3 0.858858858858859 80.2016666666667
0.86 80.3 0.858858858858859 80.4 0.861861861861862 80.338
0.87 80.4 0.861861861861862 80.5 0.870870870870871 80.4903333333333
0.88 80.6 0.877877877877878 80.7 0.883883883883884 80.6353333333333
0.89 80.7 0.883883883883884 80.8 0.890890890890891 80.7872857142857
0.9 81 0.8998998998999 81.1 0.902902902902903 81.0033333333333
0.91 81.3 0.908908908908909 81.4 0.912912912912913 81.32725
0.92 81.7 0.914914914914915 81.8 0.921921921921922 81.7725714285714
0.93 82 0.928928928928929 82.3 0.930930930930931 82.1605
0.94 82.7 0.938938938938939 82.8 0.941941941941942 82.7353333333333
0.95 83.2 0.948948948948949 83.3 0.951951951951952 83.235
0.96 84 0.958958958958959 84.3 0.960960960960961 84.156
0.97 84.9 0.96996996996997 85.1 0.973973973973974 84.9015
0.98 85.6 0.97997997997998 85.7 0.982982982982983 85.6006666666667
0.99 86.6 0.98998998998999 86.8 0.990990990990991 86.602
1 89.8 1 89.8 1 null