Free Statistics

of Irreproducible Research!

Author's title

Author*The author of this computation has been verified*
R Software Modulerwasp_percentiles.wasp
Title produced by softwarePercentiles
Date of computationThu, 20 Dec 2012 10:38:16 -0500
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2012/Dec/20/t1356017912y5dd4kt885npf28.htm/, Retrieved Thu, 18 Apr 2024 16:47:18 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=202783, Retrieved Thu, 18 Apr 2024 16:47:18 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact116
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Univariate Explorative Data Analysis] [Run Sequence gebo...] [2008-12-12 13:32:37] [76963dc1903f0f612b6153510a3818cf]
- R  D  [Univariate Explorative Data Analysis] [Run Sequence gebo...] [2008-12-17 12:14:40] [76963dc1903f0f612b6153510a3818cf]
-         [Univariate Explorative Data Analysis] [Run Sequence Plot...] [2008-12-22 18:19:51] [1ce0d16c8f4225c977b42c8fa93bc163]
- RMP       [Univariate Data Series] [Identifying Integ...] [2009-11-22 12:08:06] [b98453cac15ba1066b407e146608df68]
- RMP         [Spectral Analysis] [Births] [2010-11-29 09:38:20] [b98453cac15ba1066b407e146608df68]
- R  D          [Spectral Analysis] [WS9 3.2 CP d=0, D=0] [2010-12-07 10:39:32] [afe9379cca749d06b3d6872e02cc47ed]
-   PD            [Spectral Analysis] [Apple Inc - CP d=...] [2010-12-14 16:14:30] [afe9379cca749d06b3d6872e02cc47ed]
- RMPD              [Notched Boxplots] [] [2012-12-15 15:08:39] [d1865ed705b6ad9ba3d459a02c528b22]
- RM                    [Percentiles] [] [2012-12-20 15:38:16] [14d0a7ecb926325afa0eb6a607fbc7a0] [Current]
Feedback Forum

Post a new message
Dataseries X:
26.81
28.24
27.58
27.98
26.81
28.24
27.58
27.98
27.84
27.49
26.97
27.71
27.46
27.04
28.00
27.32
26.36
26.15
25.94
24.00
24.32
23.10
22.92
23.56
22.17
22.36
19.86
20.07
19.21
19.99
20.47
21.17
21.25
21.18
21.21
21.11
21.94
22.56
23.23
19.50
19.32
19.00
18.98
19.88
19.48
19.52
19.52
19.75
19.64
20.23
20.40
20.91
21.95
21.83
22.27
21.99
21.66
20.32
20.62
20.28
20.79
22.86
22.59
23.29
21.87
21.52
22.00
27.84
27.49
26.97
27.71
27.46
27.04
28.00
27.32
26.36
26.15
25.94
24.00
24.32
23.10
22.92
23.56
22.17
22.36
19.86
20.07
19.21
19.99
20.47
21.17
21.25
21.18
21.21
21.11
21.94
22.56
23.23
19.50
19.32
19.00
18.98
19.88
19.48
19.52
19.52
19.75
19.64
20.23
20.40
20.91
21.95
21.83
22.27
21.99
21.66
20.32
20.62
20.28
20.79
22.86
22.59
23.29
21.87
21.52
22.00




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time3 seconds
R Server'George Udny Yule' @ yule.wessa.net

\begin{tabular}{lllllllll}
\hline
Summary of computational transaction \tabularnewline
Raw Input & view raw input (R code)  \tabularnewline
Raw Output & view raw output of R engine  \tabularnewline
Computing time & 3 seconds \tabularnewline
R Server & 'George Udny Yule' @ yule.wessa.net \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=202783&T=0

[TABLE]
[ROW][C]Summary of computational transaction[/C][/ROW]
[ROW][C]Raw Input[/C][C]view raw input (R code) [/C][/ROW]
[ROW][C]Raw Output[/C][C]view raw output of R engine [/C][/ROW]
[ROW][C]Computing time[/C][C]3 seconds[/C][/ROW]
[ROW][C]R Server[/C][C]'George Udny Yule' @ yule.wessa.net[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=202783&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=202783&T=0

As an alternative you can also use a QR Code:  

The GUIDs for individual cells are displayed in the table below:

Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time3 seconds
R Server'George Udny Yule' @ yule.wessa.net







Percentiles - Ungrouped Data
pWeighted Average at XnpWeighted Average at X(n+1)pEmpirical Distribution FunctionEmpirical Distribution Function - AveragingEmpirical Distribution Function - InterpolationClosest ObservationTrue Basic - Statistics Graphics ToolkitMS Excel (old versions)
0.0118.9818.9818.9818.9818.98518.9818.9818.98
0.0218.990418.99081919191918.989219
0.031919191919.1575191919
0.0419.2119.2119.2119.2119.2119.2119.2119.21
0.0519.24319.248519.3219.3219.3219.2119.281519.21
0.0619.3219.3219.3219.3219.419.3219.3219.32
0.0719.451219.462419.4819.4819.4819.4819.337619.48
0.0819.481619.483219.519.519.519.4819.496819.48
0.0919.519.519.519.519.50519.519.519.5
0.119.51219.51419.5219.5219.5219.5219.50619.52
0.1119.5219.5219.5219.5219.5219.5219.5219.52
0.1219.5219.5219.5219.5219.5219.5219.5219.52
0.1319.565619.581219.6419.6419.6419.5219.578819.64
0.1419.6419.6419.6419.6419.69519.6419.6419.64
0.1519.73919.7519.7519.7519.7519.7519.7519.75
0.1619.767619.785219.8619.8619.8619.7519.824819.75
0.1719.8619.8619.8619.8619.86519.8619.8619.86
0.1819.873619.877219.8819.8819.8819.8819.862819.88
0.1919.8819.894319.8819.8819.962519.8819.975719.88
0.219.9919.9919.9919.9919.9919.9919.9919.99
0.2120.026820.043620.0720.0720.0719.9920.016420.07
0.2220.0720.0720.0720.0720.1520.0720.0720.07
0.2320.226820.2320.2320.2320.2320.2320.2320.23
0.2420.24220.25420.2820.2820.2820.2320.25620.23
0.2520.2820.2820.2820.2820.2920.2820.2820.28
0.2620.310420.3220.3220.3220.3220.3220.3220.32
0.2720.321620.343220.420.420.3820.3220.376820.32
0.2820.420.420.420.420.420.420.420.4
0.2920.437820.458120.4720.4720.4720.4720.411920.47
0.320.4720.48520.4720.4720.54520.4720.60520.47
0.3120.6220.6220.6220.6220.6220.6220.6220.62
0.3220.674420.728820.7920.7920.7920.6220.681220.79
0.3320.7920.7920.7920.7920.8220.7920.7920.79
0.3420.890820.9120.9120.9120.9120.9120.9120.91
0.3520.932121.1121.1121.0620.9121.0220.91
0.3621.1121.1121.1121.1121.1121.1121.1121.11
0.3721.147221.169421.1721.1721.1721.1721.110621.17
0.3821.1721.172621.1721.1721.17521.1721.177421.17
0.3921.1821.1821.1821.1821.1821.1821.1821.18
0.421.19221.20421.2121.2121.2121.1821.18621.21
0.4121.2121.212821.2121.2121.2221.2121.247221.21
0.4221.246821.2521.2521.2521.2521.2521.2521.25
0.4321.298621.414721.5221.5221.452521.2521.355321.52
0.4421.5221.5221.5221.5221.5221.5221.5221.52
0.4521.61821.6621.6621.6621.6621.6621.6621.66
0.4621.6621.731421.6621.6621.74521.6621.758621.66
0.4721.8321.8321.8321.8321.8321.8321.8321.83
0.4821.849221.868421.8721.8721.8721.8321.831621.87
0.4921.8721.886121.8721.8721.887521.8721.923921.87
0.521.9421.9421.9421.9421.9421.9421.9421.94
0.5121.942621.947721.9521.9521.947521.9421.942321.95
0.5221.9521.951621.9521.9521.9521.9521.988421.95
0.5321.981221.9921.9921.9921.9921.9921.9921.99
0.5421.990421.9958222221.99521.9921.994222
0.552222222222222222
0.5622.095222.1722.1722.1722.1722.1722.1722.17
0.5722.1722.20922.1722.1722.19522.1722.23122.17
0.5822.2722.2722.2722.2722.2722.2722.2722.27
0.5922.300622.353722.3622.3622.337522.2722.276322.36
0.622.3622.422.3622.3622.3622.3622.5222.36
0.6122.53222.5622.5622.5622.5622.5622.5622.56
0.6222.563622.582222.5922.5922.57522.5622.567822.59
0.6322.5922.592722.5922.5922.5922.5922.857322.59
0.6422.762822.8622.8622.8622.8622.8622.8622.86
0.6522.8622.89322.8622.8622.87522.8622.88722.92
0.6622.9222.9222.9222.9222.9222.9222.9222.92
0.6722.995623.123.123.123.05522.9223.123.1
0.6823.123.146823.123.123.123.123.183223.1
0.6923.222223.2323.2323.2323.2323.2323.2323.23
0.723.24223.28423.2923.2923.2623.2323.23623.29
0.7123.2923.335923.2923.2923.2923.2923.514123.29
0.7223.484423.5623.5623.5623.5623.5623.5623.56
0.7323.5623.872423.5623.5623.6723.5623.687624
0.742424242424242424
0.7524.1624.3224.3224.3224.2424.3224.3224.32
0.7624.3225.162424.3224.3224.3224.3225.097625.94
0.7725.9425.9425.9425.9425.9425.9425.9425.94
0.7825.998826.1526.1526.1526.04525.9426.1526.15
0.7926.1526.219326.1526.1526.1526.1526.290726.15
0.826.31826.3626.3626.3626.3626.3626.3626.36
0.8126.38726.751526.8126.8126.472526.3626.418526.81
0.8226.8126.832426.8126.8126.8126.8126.947626.81
0.8326.902826.9726.9726.9726.9326.9726.9726.97
0.8426.9727.017626.9726.9726.9726.9726.992427.04
0.8527.0427.0427.0427.0427.0427.0427.0427.04
0.8627.140827.3227.3227.3227.1827.0427.3227.32
0.8727.3227.388627.3227.3227.3227.3227.391427.32
0.8827.443227.4627.4627.4627.4627.4627.4627.46
0.8927.464227.4927.4927.4927.467527.4627.4927.49
0.927.4927.51727.4927.4927.4927.4927.55327.49
0.9127.549427.5827.5827.5827.557527.5827.5827.58
0.9227.5827.689227.5827.5827.5827.5827.600827.71
0.9327.7127.724327.7127.7127.7127.7127.825727.71
0.9427.767227.8427.8427.8427.77527.7127.8427.84
0.9527.8427.93127.8427.8427.8427.8427.88927.98
0.9627.974427.9827.9827.9827.9827.9827.9827.98
0.9727.984428282827.98527.982828
0.982828.11042828282828.129628
0.9928.177628.2428.2428.2428.1828.2428.2428.24

\begin{tabular}{lllllllll}
\hline
Percentiles - Ungrouped Data \tabularnewline
p & Weighted Average at Xnp & Weighted Average at X(n+1)p & Empirical Distribution Function & Empirical Distribution Function - Averaging & Empirical Distribution Function - Interpolation & Closest Observation & True Basic - Statistics Graphics Toolkit & MS Excel (old versions) \tabularnewline
0.01 & 18.98 & 18.98 & 18.98 & 18.98 & 18.985 & 18.98 & 18.98 & 18.98 \tabularnewline
0.02 & 18.9904 & 18.9908 & 19 & 19 & 19 & 19 & 18.9892 & 19 \tabularnewline
0.03 & 19 & 19 & 19 & 19 & 19.1575 & 19 & 19 & 19 \tabularnewline
0.04 & 19.21 & 19.21 & 19.21 & 19.21 & 19.21 & 19.21 & 19.21 & 19.21 \tabularnewline
0.05 & 19.243 & 19.2485 & 19.32 & 19.32 & 19.32 & 19.21 & 19.2815 & 19.21 \tabularnewline
0.06 & 19.32 & 19.32 & 19.32 & 19.32 & 19.4 & 19.32 & 19.32 & 19.32 \tabularnewline
0.07 & 19.4512 & 19.4624 & 19.48 & 19.48 & 19.48 & 19.48 & 19.3376 & 19.48 \tabularnewline
0.08 & 19.4816 & 19.4832 & 19.5 & 19.5 & 19.5 & 19.48 & 19.4968 & 19.48 \tabularnewline
0.09 & 19.5 & 19.5 & 19.5 & 19.5 & 19.505 & 19.5 & 19.5 & 19.5 \tabularnewline
0.1 & 19.512 & 19.514 & 19.52 & 19.52 & 19.52 & 19.52 & 19.506 & 19.52 \tabularnewline
0.11 & 19.52 & 19.52 & 19.52 & 19.52 & 19.52 & 19.52 & 19.52 & 19.52 \tabularnewline
0.12 & 19.52 & 19.52 & 19.52 & 19.52 & 19.52 & 19.52 & 19.52 & 19.52 \tabularnewline
0.13 & 19.5656 & 19.5812 & 19.64 & 19.64 & 19.64 & 19.52 & 19.5788 & 19.64 \tabularnewline
0.14 & 19.64 & 19.64 & 19.64 & 19.64 & 19.695 & 19.64 & 19.64 & 19.64 \tabularnewline
0.15 & 19.739 & 19.75 & 19.75 & 19.75 & 19.75 & 19.75 & 19.75 & 19.75 \tabularnewline
0.16 & 19.7676 & 19.7852 & 19.86 & 19.86 & 19.86 & 19.75 & 19.8248 & 19.75 \tabularnewline
0.17 & 19.86 & 19.86 & 19.86 & 19.86 & 19.865 & 19.86 & 19.86 & 19.86 \tabularnewline
0.18 & 19.8736 & 19.8772 & 19.88 & 19.88 & 19.88 & 19.88 & 19.8628 & 19.88 \tabularnewline
0.19 & 19.88 & 19.8943 & 19.88 & 19.88 & 19.9625 & 19.88 & 19.9757 & 19.88 \tabularnewline
0.2 & 19.99 & 19.99 & 19.99 & 19.99 & 19.99 & 19.99 & 19.99 & 19.99 \tabularnewline
0.21 & 20.0268 & 20.0436 & 20.07 & 20.07 & 20.07 & 19.99 & 20.0164 & 20.07 \tabularnewline
0.22 & 20.07 & 20.07 & 20.07 & 20.07 & 20.15 & 20.07 & 20.07 & 20.07 \tabularnewline
0.23 & 20.2268 & 20.23 & 20.23 & 20.23 & 20.23 & 20.23 & 20.23 & 20.23 \tabularnewline
0.24 & 20.242 & 20.254 & 20.28 & 20.28 & 20.28 & 20.23 & 20.256 & 20.23 \tabularnewline
0.25 & 20.28 & 20.28 & 20.28 & 20.28 & 20.29 & 20.28 & 20.28 & 20.28 \tabularnewline
0.26 & 20.3104 & 20.32 & 20.32 & 20.32 & 20.32 & 20.32 & 20.32 & 20.32 \tabularnewline
0.27 & 20.3216 & 20.3432 & 20.4 & 20.4 & 20.38 & 20.32 & 20.3768 & 20.32 \tabularnewline
0.28 & 20.4 & 20.4 & 20.4 & 20.4 & 20.4 & 20.4 & 20.4 & 20.4 \tabularnewline
0.29 & 20.4378 & 20.4581 & 20.47 & 20.47 & 20.47 & 20.47 & 20.4119 & 20.47 \tabularnewline
0.3 & 20.47 & 20.485 & 20.47 & 20.47 & 20.545 & 20.47 & 20.605 & 20.47 \tabularnewline
0.31 & 20.62 & 20.62 & 20.62 & 20.62 & 20.62 & 20.62 & 20.62 & 20.62 \tabularnewline
0.32 & 20.6744 & 20.7288 & 20.79 & 20.79 & 20.79 & 20.62 & 20.6812 & 20.79 \tabularnewline
0.33 & 20.79 & 20.79 & 20.79 & 20.79 & 20.82 & 20.79 & 20.79 & 20.79 \tabularnewline
0.34 & 20.8908 & 20.91 & 20.91 & 20.91 & 20.91 & 20.91 & 20.91 & 20.91 \tabularnewline
0.35 & 20.93 & 21 & 21.11 & 21.11 & 21.06 & 20.91 & 21.02 & 20.91 \tabularnewline
0.36 & 21.11 & 21.11 & 21.11 & 21.11 & 21.11 & 21.11 & 21.11 & 21.11 \tabularnewline
0.37 & 21.1472 & 21.1694 & 21.17 & 21.17 & 21.17 & 21.17 & 21.1106 & 21.17 \tabularnewline
0.38 & 21.17 & 21.1726 & 21.17 & 21.17 & 21.175 & 21.17 & 21.1774 & 21.17 \tabularnewline
0.39 & 21.18 & 21.18 & 21.18 & 21.18 & 21.18 & 21.18 & 21.18 & 21.18 \tabularnewline
0.4 & 21.192 & 21.204 & 21.21 & 21.21 & 21.21 & 21.18 & 21.186 & 21.21 \tabularnewline
0.41 & 21.21 & 21.2128 & 21.21 & 21.21 & 21.22 & 21.21 & 21.2472 & 21.21 \tabularnewline
0.42 & 21.2468 & 21.25 & 21.25 & 21.25 & 21.25 & 21.25 & 21.25 & 21.25 \tabularnewline
0.43 & 21.2986 & 21.4147 & 21.52 & 21.52 & 21.4525 & 21.25 & 21.3553 & 21.52 \tabularnewline
0.44 & 21.52 & 21.52 & 21.52 & 21.52 & 21.52 & 21.52 & 21.52 & 21.52 \tabularnewline
0.45 & 21.618 & 21.66 & 21.66 & 21.66 & 21.66 & 21.66 & 21.66 & 21.66 \tabularnewline
0.46 & 21.66 & 21.7314 & 21.66 & 21.66 & 21.745 & 21.66 & 21.7586 & 21.66 \tabularnewline
0.47 & 21.83 & 21.83 & 21.83 & 21.83 & 21.83 & 21.83 & 21.83 & 21.83 \tabularnewline
0.48 & 21.8492 & 21.8684 & 21.87 & 21.87 & 21.87 & 21.83 & 21.8316 & 21.87 \tabularnewline
0.49 & 21.87 & 21.8861 & 21.87 & 21.87 & 21.8875 & 21.87 & 21.9239 & 21.87 \tabularnewline
0.5 & 21.94 & 21.94 & 21.94 & 21.94 & 21.94 & 21.94 & 21.94 & 21.94 \tabularnewline
0.51 & 21.9426 & 21.9477 & 21.95 & 21.95 & 21.9475 & 21.94 & 21.9423 & 21.95 \tabularnewline
0.52 & 21.95 & 21.9516 & 21.95 & 21.95 & 21.95 & 21.95 & 21.9884 & 21.95 \tabularnewline
0.53 & 21.9812 & 21.99 & 21.99 & 21.99 & 21.99 & 21.99 & 21.99 & 21.99 \tabularnewline
0.54 & 21.9904 & 21.9958 & 22 & 22 & 21.995 & 21.99 & 21.9942 & 22 \tabularnewline
0.55 & 22 & 22 & 22 & 22 & 22 & 22 & 22 & 22 \tabularnewline
0.56 & 22.0952 & 22.17 & 22.17 & 22.17 & 22.17 & 22.17 & 22.17 & 22.17 \tabularnewline
0.57 & 22.17 & 22.209 & 22.17 & 22.17 & 22.195 & 22.17 & 22.231 & 22.17 \tabularnewline
0.58 & 22.27 & 22.27 & 22.27 & 22.27 & 22.27 & 22.27 & 22.27 & 22.27 \tabularnewline
0.59 & 22.3006 & 22.3537 & 22.36 & 22.36 & 22.3375 & 22.27 & 22.2763 & 22.36 \tabularnewline
0.6 & 22.36 & 22.4 & 22.36 & 22.36 & 22.36 & 22.36 & 22.52 & 22.36 \tabularnewline
0.61 & 22.532 & 22.56 & 22.56 & 22.56 & 22.56 & 22.56 & 22.56 & 22.56 \tabularnewline
0.62 & 22.5636 & 22.5822 & 22.59 & 22.59 & 22.575 & 22.56 & 22.5678 & 22.59 \tabularnewline
0.63 & 22.59 & 22.5927 & 22.59 & 22.59 & 22.59 & 22.59 & 22.8573 & 22.59 \tabularnewline
0.64 & 22.7628 & 22.86 & 22.86 & 22.86 & 22.86 & 22.86 & 22.86 & 22.86 \tabularnewline
0.65 & 22.86 & 22.893 & 22.86 & 22.86 & 22.875 & 22.86 & 22.887 & 22.92 \tabularnewline
0.66 & 22.92 & 22.92 & 22.92 & 22.92 & 22.92 & 22.92 & 22.92 & 22.92 \tabularnewline
0.67 & 22.9956 & 23.1 & 23.1 & 23.1 & 23.055 & 22.92 & 23.1 & 23.1 \tabularnewline
0.68 & 23.1 & 23.1468 & 23.1 & 23.1 & 23.1 & 23.1 & 23.1832 & 23.1 \tabularnewline
0.69 & 23.2222 & 23.23 & 23.23 & 23.23 & 23.23 & 23.23 & 23.23 & 23.23 \tabularnewline
0.7 & 23.242 & 23.284 & 23.29 & 23.29 & 23.26 & 23.23 & 23.236 & 23.29 \tabularnewline
0.71 & 23.29 & 23.3359 & 23.29 & 23.29 & 23.29 & 23.29 & 23.5141 & 23.29 \tabularnewline
0.72 & 23.4844 & 23.56 & 23.56 & 23.56 & 23.56 & 23.56 & 23.56 & 23.56 \tabularnewline
0.73 & 23.56 & 23.8724 & 23.56 & 23.56 & 23.67 & 23.56 & 23.6876 & 24 \tabularnewline
0.74 & 24 & 24 & 24 & 24 & 24 & 24 & 24 & 24 \tabularnewline
0.75 & 24.16 & 24.32 & 24.32 & 24.32 & 24.24 & 24.32 & 24.32 & 24.32 \tabularnewline
0.76 & 24.32 & 25.1624 & 24.32 & 24.32 & 24.32 & 24.32 & 25.0976 & 25.94 \tabularnewline
0.77 & 25.94 & 25.94 & 25.94 & 25.94 & 25.94 & 25.94 & 25.94 & 25.94 \tabularnewline
0.78 & 25.9988 & 26.15 & 26.15 & 26.15 & 26.045 & 25.94 & 26.15 & 26.15 \tabularnewline
0.79 & 26.15 & 26.2193 & 26.15 & 26.15 & 26.15 & 26.15 & 26.2907 & 26.15 \tabularnewline
0.8 & 26.318 & 26.36 & 26.36 & 26.36 & 26.36 & 26.36 & 26.36 & 26.36 \tabularnewline
0.81 & 26.387 & 26.7515 & 26.81 & 26.81 & 26.4725 & 26.36 & 26.4185 & 26.81 \tabularnewline
0.82 & 26.81 & 26.8324 & 26.81 & 26.81 & 26.81 & 26.81 & 26.9476 & 26.81 \tabularnewline
0.83 & 26.9028 & 26.97 & 26.97 & 26.97 & 26.93 & 26.97 & 26.97 & 26.97 \tabularnewline
0.84 & 26.97 & 27.0176 & 26.97 & 26.97 & 26.97 & 26.97 & 26.9924 & 27.04 \tabularnewline
0.85 & 27.04 & 27.04 & 27.04 & 27.04 & 27.04 & 27.04 & 27.04 & 27.04 \tabularnewline
0.86 & 27.1408 & 27.32 & 27.32 & 27.32 & 27.18 & 27.04 & 27.32 & 27.32 \tabularnewline
0.87 & 27.32 & 27.3886 & 27.32 & 27.32 & 27.32 & 27.32 & 27.3914 & 27.32 \tabularnewline
0.88 & 27.4432 & 27.46 & 27.46 & 27.46 & 27.46 & 27.46 & 27.46 & 27.46 \tabularnewline
0.89 & 27.4642 & 27.49 & 27.49 & 27.49 & 27.4675 & 27.46 & 27.49 & 27.49 \tabularnewline
0.9 & 27.49 & 27.517 & 27.49 & 27.49 & 27.49 & 27.49 & 27.553 & 27.49 \tabularnewline
0.91 & 27.5494 & 27.58 & 27.58 & 27.58 & 27.5575 & 27.58 & 27.58 & 27.58 \tabularnewline
0.92 & 27.58 & 27.6892 & 27.58 & 27.58 & 27.58 & 27.58 & 27.6008 & 27.71 \tabularnewline
0.93 & 27.71 & 27.7243 & 27.71 & 27.71 & 27.71 & 27.71 & 27.8257 & 27.71 \tabularnewline
0.94 & 27.7672 & 27.84 & 27.84 & 27.84 & 27.775 & 27.71 & 27.84 & 27.84 \tabularnewline
0.95 & 27.84 & 27.931 & 27.84 & 27.84 & 27.84 & 27.84 & 27.889 & 27.98 \tabularnewline
0.96 & 27.9744 & 27.98 & 27.98 & 27.98 & 27.98 & 27.98 & 27.98 & 27.98 \tabularnewline
0.97 & 27.9844 & 28 & 28 & 28 & 27.985 & 27.98 & 28 & 28 \tabularnewline
0.98 & 28 & 28.1104 & 28 & 28 & 28 & 28 & 28.1296 & 28 \tabularnewline
0.99 & 28.1776 & 28.24 & 28.24 & 28.24 & 28.18 & 28.24 & 28.24 & 28.24 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=202783&T=1

[TABLE]
[ROW][C]Percentiles - Ungrouped Data[/C][/ROW]
[ROW][C]p[/C][C]Weighted Average at Xnp[/C][C]Weighted Average at X(n+1)p[/C][C]Empirical Distribution Function[/C][C]Empirical Distribution Function - Averaging[/C][C]Empirical Distribution Function - Interpolation[/C][C]Closest Observation[/C][C]True Basic - Statistics Graphics Toolkit[/C][C]MS Excel (old versions)[/C][/ROW]
[ROW][C]0.01[/C][C]18.98[/C][C]18.98[/C][C]18.98[/C][C]18.98[/C][C]18.985[/C][C]18.98[/C][C]18.98[/C][C]18.98[/C][/ROW]
[ROW][C]0.02[/C][C]18.9904[/C][C]18.9908[/C][C]19[/C][C]19[/C][C]19[/C][C]19[/C][C]18.9892[/C][C]19[/C][/ROW]
[ROW][C]0.03[/C][C]19[/C][C]19[/C][C]19[/C][C]19[/C][C]19.1575[/C][C]19[/C][C]19[/C][C]19[/C][/ROW]
[ROW][C]0.04[/C][C]19.21[/C][C]19.21[/C][C]19.21[/C][C]19.21[/C][C]19.21[/C][C]19.21[/C][C]19.21[/C][C]19.21[/C][/ROW]
[ROW][C]0.05[/C][C]19.243[/C][C]19.2485[/C][C]19.32[/C][C]19.32[/C][C]19.32[/C][C]19.21[/C][C]19.2815[/C][C]19.21[/C][/ROW]
[ROW][C]0.06[/C][C]19.32[/C][C]19.32[/C][C]19.32[/C][C]19.32[/C][C]19.4[/C][C]19.32[/C][C]19.32[/C][C]19.32[/C][/ROW]
[ROW][C]0.07[/C][C]19.4512[/C][C]19.4624[/C][C]19.48[/C][C]19.48[/C][C]19.48[/C][C]19.48[/C][C]19.3376[/C][C]19.48[/C][/ROW]
[ROW][C]0.08[/C][C]19.4816[/C][C]19.4832[/C][C]19.5[/C][C]19.5[/C][C]19.5[/C][C]19.48[/C][C]19.4968[/C][C]19.48[/C][/ROW]
[ROW][C]0.09[/C][C]19.5[/C][C]19.5[/C][C]19.5[/C][C]19.5[/C][C]19.505[/C][C]19.5[/C][C]19.5[/C][C]19.5[/C][/ROW]
[ROW][C]0.1[/C][C]19.512[/C][C]19.514[/C][C]19.52[/C][C]19.52[/C][C]19.52[/C][C]19.52[/C][C]19.506[/C][C]19.52[/C][/ROW]
[ROW][C]0.11[/C][C]19.52[/C][C]19.52[/C][C]19.52[/C][C]19.52[/C][C]19.52[/C][C]19.52[/C][C]19.52[/C][C]19.52[/C][/ROW]
[ROW][C]0.12[/C][C]19.52[/C][C]19.52[/C][C]19.52[/C][C]19.52[/C][C]19.52[/C][C]19.52[/C][C]19.52[/C][C]19.52[/C][/ROW]
[ROW][C]0.13[/C][C]19.5656[/C][C]19.5812[/C][C]19.64[/C][C]19.64[/C][C]19.64[/C][C]19.52[/C][C]19.5788[/C][C]19.64[/C][/ROW]
[ROW][C]0.14[/C][C]19.64[/C][C]19.64[/C][C]19.64[/C][C]19.64[/C][C]19.695[/C][C]19.64[/C][C]19.64[/C][C]19.64[/C][/ROW]
[ROW][C]0.15[/C][C]19.739[/C][C]19.75[/C][C]19.75[/C][C]19.75[/C][C]19.75[/C][C]19.75[/C][C]19.75[/C][C]19.75[/C][/ROW]
[ROW][C]0.16[/C][C]19.7676[/C][C]19.7852[/C][C]19.86[/C][C]19.86[/C][C]19.86[/C][C]19.75[/C][C]19.8248[/C][C]19.75[/C][/ROW]
[ROW][C]0.17[/C][C]19.86[/C][C]19.86[/C][C]19.86[/C][C]19.86[/C][C]19.865[/C][C]19.86[/C][C]19.86[/C][C]19.86[/C][/ROW]
[ROW][C]0.18[/C][C]19.8736[/C][C]19.8772[/C][C]19.88[/C][C]19.88[/C][C]19.88[/C][C]19.88[/C][C]19.8628[/C][C]19.88[/C][/ROW]
[ROW][C]0.19[/C][C]19.88[/C][C]19.8943[/C][C]19.88[/C][C]19.88[/C][C]19.9625[/C][C]19.88[/C][C]19.9757[/C][C]19.88[/C][/ROW]
[ROW][C]0.2[/C][C]19.99[/C][C]19.99[/C][C]19.99[/C][C]19.99[/C][C]19.99[/C][C]19.99[/C][C]19.99[/C][C]19.99[/C][/ROW]
[ROW][C]0.21[/C][C]20.0268[/C][C]20.0436[/C][C]20.07[/C][C]20.07[/C][C]20.07[/C][C]19.99[/C][C]20.0164[/C][C]20.07[/C][/ROW]
[ROW][C]0.22[/C][C]20.07[/C][C]20.07[/C][C]20.07[/C][C]20.07[/C][C]20.15[/C][C]20.07[/C][C]20.07[/C][C]20.07[/C][/ROW]
[ROW][C]0.23[/C][C]20.2268[/C][C]20.23[/C][C]20.23[/C][C]20.23[/C][C]20.23[/C][C]20.23[/C][C]20.23[/C][C]20.23[/C][/ROW]
[ROW][C]0.24[/C][C]20.242[/C][C]20.254[/C][C]20.28[/C][C]20.28[/C][C]20.28[/C][C]20.23[/C][C]20.256[/C][C]20.23[/C][/ROW]
[ROW][C]0.25[/C][C]20.28[/C][C]20.28[/C][C]20.28[/C][C]20.28[/C][C]20.29[/C][C]20.28[/C][C]20.28[/C][C]20.28[/C][/ROW]
[ROW][C]0.26[/C][C]20.3104[/C][C]20.32[/C][C]20.32[/C][C]20.32[/C][C]20.32[/C][C]20.32[/C][C]20.32[/C][C]20.32[/C][/ROW]
[ROW][C]0.27[/C][C]20.3216[/C][C]20.3432[/C][C]20.4[/C][C]20.4[/C][C]20.38[/C][C]20.32[/C][C]20.3768[/C][C]20.32[/C][/ROW]
[ROW][C]0.28[/C][C]20.4[/C][C]20.4[/C][C]20.4[/C][C]20.4[/C][C]20.4[/C][C]20.4[/C][C]20.4[/C][C]20.4[/C][/ROW]
[ROW][C]0.29[/C][C]20.4378[/C][C]20.4581[/C][C]20.47[/C][C]20.47[/C][C]20.47[/C][C]20.47[/C][C]20.4119[/C][C]20.47[/C][/ROW]
[ROW][C]0.3[/C][C]20.47[/C][C]20.485[/C][C]20.47[/C][C]20.47[/C][C]20.545[/C][C]20.47[/C][C]20.605[/C][C]20.47[/C][/ROW]
[ROW][C]0.31[/C][C]20.62[/C][C]20.62[/C][C]20.62[/C][C]20.62[/C][C]20.62[/C][C]20.62[/C][C]20.62[/C][C]20.62[/C][/ROW]
[ROW][C]0.32[/C][C]20.6744[/C][C]20.7288[/C][C]20.79[/C][C]20.79[/C][C]20.79[/C][C]20.62[/C][C]20.6812[/C][C]20.79[/C][/ROW]
[ROW][C]0.33[/C][C]20.79[/C][C]20.79[/C][C]20.79[/C][C]20.79[/C][C]20.82[/C][C]20.79[/C][C]20.79[/C][C]20.79[/C][/ROW]
[ROW][C]0.34[/C][C]20.8908[/C][C]20.91[/C][C]20.91[/C][C]20.91[/C][C]20.91[/C][C]20.91[/C][C]20.91[/C][C]20.91[/C][/ROW]
[ROW][C]0.35[/C][C]20.93[/C][C]21[/C][C]21.11[/C][C]21.11[/C][C]21.06[/C][C]20.91[/C][C]21.02[/C][C]20.91[/C][/ROW]
[ROW][C]0.36[/C][C]21.11[/C][C]21.11[/C][C]21.11[/C][C]21.11[/C][C]21.11[/C][C]21.11[/C][C]21.11[/C][C]21.11[/C][/ROW]
[ROW][C]0.37[/C][C]21.1472[/C][C]21.1694[/C][C]21.17[/C][C]21.17[/C][C]21.17[/C][C]21.17[/C][C]21.1106[/C][C]21.17[/C][/ROW]
[ROW][C]0.38[/C][C]21.17[/C][C]21.1726[/C][C]21.17[/C][C]21.17[/C][C]21.175[/C][C]21.17[/C][C]21.1774[/C][C]21.17[/C][/ROW]
[ROW][C]0.39[/C][C]21.18[/C][C]21.18[/C][C]21.18[/C][C]21.18[/C][C]21.18[/C][C]21.18[/C][C]21.18[/C][C]21.18[/C][/ROW]
[ROW][C]0.4[/C][C]21.192[/C][C]21.204[/C][C]21.21[/C][C]21.21[/C][C]21.21[/C][C]21.18[/C][C]21.186[/C][C]21.21[/C][/ROW]
[ROW][C]0.41[/C][C]21.21[/C][C]21.2128[/C][C]21.21[/C][C]21.21[/C][C]21.22[/C][C]21.21[/C][C]21.2472[/C][C]21.21[/C][/ROW]
[ROW][C]0.42[/C][C]21.2468[/C][C]21.25[/C][C]21.25[/C][C]21.25[/C][C]21.25[/C][C]21.25[/C][C]21.25[/C][C]21.25[/C][/ROW]
[ROW][C]0.43[/C][C]21.2986[/C][C]21.4147[/C][C]21.52[/C][C]21.52[/C][C]21.4525[/C][C]21.25[/C][C]21.3553[/C][C]21.52[/C][/ROW]
[ROW][C]0.44[/C][C]21.52[/C][C]21.52[/C][C]21.52[/C][C]21.52[/C][C]21.52[/C][C]21.52[/C][C]21.52[/C][C]21.52[/C][/ROW]
[ROW][C]0.45[/C][C]21.618[/C][C]21.66[/C][C]21.66[/C][C]21.66[/C][C]21.66[/C][C]21.66[/C][C]21.66[/C][C]21.66[/C][/ROW]
[ROW][C]0.46[/C][C]21.66[/C][C]21.7314[/C][C]21.66[/C][C]21.66[/C][C]21.745[/C][C]21.66[/C][C]21.7586[/C][C]21.66[/C][/ROW]
[ROW][C]0.47[/C][C]21.83[/C][C]21.83[/C][C]21.83[/C][C]21.83[/C][C]21.83[/C][C]21.83[/C][C]21.83[/C][C]21.83[/C][/ROW]
[ROW][C]0.48[/C][C]21.8492[/C][C]21.8684[/C][C]21.87[/C][C]21.87[/C][C]21.87[/C][C]21.83[/C][C]21.8316[/C][C]21.87[/C][/ROW]
[ROW][C]0.49[/C][C]21.87[/C][C]21.8861[/C][C]21.87[/C][C]21.87[/C][C]21.8875[/C][C]21.87[/C][C]21.9239[/C][C]21.87[/C][/ROW]
[ROW][C]0.5[/C][C]21.94[/C][C]21.94[/C][C]21.94[/C][C]21.94[/C][C]21.94[/C][C]21.94[/C][C]21.94[/C][C]21.94[/C][/ROW]
[ROW][C]0.51[/C][C]21.9426[/C][C]21.9477[/C][C]21.95[/C][C]21.95[/C][C]21.9475[/C][C]21.94[/C][C]21.9423[/C][C]21.95[/C][/ROW]
[ROW][C]0.52[/C][C]21.95[/C][C]21.9516[/C][C]21.95[/C][C]21.95[/C][C]21.95[/C][C]21.95[/C][C]21.9884[/C][C]21.95[/C][/ROW]
[ROW][C]0.53[/C][C]21.9812[/C][C]21.99[/C][C]21.99[/C][C]21.99[/C][C]21.99[/C][C]21.99[/C][C]21.99[/C][C]21.99[/C][/ROW]
[ROW][C]0.54[/C][C]21.9904[/C][C]21.9958[/C][C]22[/C][C]22[/C][C]21.995[/C][C]21.99[/C][C]21.9942[/C][C]22[/C][/ROW]
[ROW][C]0.55[/C][C]22[/C][C]22[/C][C]22[/C][C]22[/C][C]22[/C][C]22[/C][C]22[/C][C]22[/C][/ROW]
[ROW][C]0.56[/C][C]22.0952[/C][C]22.17[/C][C]22.17[/C][C]22.17[/C][C]22.17[/C][C]22.17[/C][C]22.17[/C][C]22.17[/C][/ROW]
[ROW][C]0.57[/C][C]22.17[/C][C]22.209[/C][C]22.17[/C][C]22.17[/C][C]22.195[/C][C]22.17[/C][C]22.231[/C][C]22.17[/C][/ROW]
[ROW][C]0.58[/C][C]22.27[/C][C]22.27[/C][C]22.27[/C][C]22.27[/C][C]22.27[/C][C]22.27[/C][C]22.27[/C][C]22.27[/C][/ROW]
[ROW][C]0.59[/C][C]22.3006[/C][C]22.3537[/C][C]22.36[/C][C]22.36[/C][C]22.3375[/C][C]22.27[/C][C]22.2763[/C][C]22.36[/C][/ROW]
[ROW][C]0.6[/C][C]22.36[/C][C]22.4[/C][C]22.36[/C][C]22.36[/C][C]22.36[/C][C]22.36[/C][C]22.52[/C][C]22.36[/C][/ROW]
[ROW][C]0.61[/C][C]22.532[/C][C]22.56[/C][C]22.56[/C][C]22.56[/C][C]22.56[/C][C]22.56[/C][C]22.56[/C][C]22.56[/C][/ROW]
[ROW][C]0.62[/C][C]22.5636[/C][C]22.5822[/C][C]22.59[/C][C]22.59[/C][C]22.575[/C][C]22.56[/C][C]22.5678[/C][C]22.59[/C][/ROW]
[ROW][C]0.63[/C][C]22.59[/C][C]22.5927[/C][C]22.59[/C][C]22.59[/C][C]22.59[/C][C]22.59[/C][C]22.8573[/C][C]22.59[/C][/ROW]
[ROW][C]0.64[/C][C]22.7628[/C][C]22.86[/C][C]22.86[/C][C]22.86[/C][C]22.86[/C][C]22.86[/C][C]22.86[/C][C]22.86[/C][/ROW]
[ROW][C]0.65[/C][C]22.86[/C][C]22.893[/C][C]22.86[/C][C]22.86[/C][C]22.875[/C][C]22.86[/C][C]22.887[/C][C]22.92[/C][/ROW]
[ROW][C]0.66[/C][C]22.92[/C][C]22.92[/C][C]22.92[/C][C]22.92[/C][C]22.92[/C][C]22.92[/C][C]22.92[/C][C]22.92[/C][/ROW]
[ROW][C]0.67[/C][C]22.9956[/C][C]23.1[/C][C]23.1[/C][C]23.1[/C][C]23.055[/C][C]22.92[/C][C]23.1[/C][C]23.1[/C][/ROW]
[ROW][C]0.68[/C][C]23.1[/C][C]23.1468[/C][C]23.1[/C][C]23.1[/C][C]23.1[/C][C]23.1[/C][C]23.1832[/C][C]23.1[/C][/ROW]
[ROW][C]0.69[/C][C]23.2222[/C][C]23.23[/C][C]23.23[/C][C]23.23[/C][C]23.23[/C][C]23.23[/C][C]23.23[/C][C]23.23[/C][/ROW]
[ROW][C]0.7[/C][C]23.242[/C][C]23.284[/C][C]23.29[/C][C]23.29[/C][C]23.26[/C][C]23.23[/C][C]23.236[/C][C]23.29[/C][/ROW]
[ROW][C]0.71[/C][C]23.29[/C][C]23.3359[/C][C]23.29[/C][C]23.29[/C][C]23.29[/C][C]23.29[/C][C]23.5141[/C][C]23.29[/C][/ROW]
[ROW][C]0.72[/C][C]23.4844[/C][C]23.56[/C][C]23.56[/C][C]23.56[/C][C]23.56[/C][C]23.56[/C][C]23.56[/C][C]23.56[/C][/ROW]
[ROW][C]0.73[/C][C]23.56[/C][C]23.8724[/C][C]23.56[/C][C]23.56[/C][C]23.67[/C][C]23.56[/C][C]23.6876[/C][C]24[/C][/ROW]
[ROW][C]0.74[/C][C]24[/C][C]24[/C][C]24[/C][C]24[/C][C]24[/C][C]24[/C][C]24[/C][C]24[/C][/ROW]
[ROW][C]0.75[/C][C]24.16[/C][C]24.32[/C][C]24.32[/C][C]24.32[/C][C]24.24[/C][C]24.32[/C][C]24.32[/C][C]24.32[/C][/ROW]
[ROW][C]0.76[/C][C]24.32[/C][C]25.1624[/C][C]24.32[/C][C]24.32[/C][C]24.32[/C][C]24.32[/C][C]25.0976[/C][C]25.94[/C][/ROW]
[ROW][C]0.77[/C][C]25.94[/C][C]25.94[/C][C]25.94[/C][C]25.94[/C][C]25.94[/C][C]25.94[/C][C]25.94[/C][C]25.94[/C][/ROW]
[ROW][C]0.78[/C][C]25.9988[/C][C]26.15[/C][C]26.15[/C][C]26.15[/C][C]26.045[/C][C]25.94[/C][C]26.15[/C][C]26.15[/C][/ROW]
[ROW][C]0.79[/C][C]26.15[/C][C]26.2193[/C][C]26.15[/C][C]26.15[/C][C]26.15[/C][C]26.15[/C][C]26.2907[/C][C]26.15[/C][/ROW]
[ROW][C]0.8[/C][C]26.318[/C][C]26.36[/C][C]26.36[/C][C]26.36[/C][C]26.36[/C][C]26.36[/C][C]26.36[/C][C]26.36[/C][/ROW]
[ROW][C]0.81[/C][C]26.387[/C][C]26.7515[/C][C]26.81[/C][C]26.81[/C][C]26.4725[/C][C]26.36[/C][C]26.4185[/C][C]26.81[/C][/ROW]
[ROW][C]0.82[/C][C]26.81[/C][C]26.8324[/C][C]26.81[/C][C]26.81[/C][C]26.81[/C][C]26.81[/C][C]26.9476[/C][C]26.81[/C][/ROW]
[ROW][C]0.83[/C][C]26.9028[/C][C]26.97[/C][C]26.97[/C][C]26.97[/C][C]26.93[/C][C]26.97[/C][C]26.97[/C][C]26.97[/C][/ROW]
[ROW][C]0.84[/C][C]26.97[/C][C]27.0176[/C][C]26.97[/C][C]26.97[/C][C]26.97[/C][C]26.97[/C][C]26.9924[/C][C]27.04[/C][/ROW]
[ROW][C]0.85[/C][C]27.04[/C][C]27.04[/C][C]27.04[/C][C]27.04[/C][C]27.04[/C][C]27.04[/C][C]27.04[/C][C]27.04[/C][/ROW]
[ROW][C]0.86[/C][C]27.1408[/C][C]27.32[/C][C]27.32[/C][C]27.32[/C][C]27.18[/C][C]27.04[/C][C]27.32[/C][C]27.32[/C][/ROW]
[ROW][C]0.87[/C][C]27.32[/C][C]27.3886[/C][C]27.32[/C][C]27.32[/C][C]27.32[/C][C]27.32[/C][C]27.3914[/C][C]27.32[/C][/ROW]
[ROW][C]0.88[/C][C]27.4432[/C][C]27.46[/C][C]27.46[/C][C]27.46[/C][C]27.46[/C][C]27.46[/C][C]27.46[/C][C]27.46[/C][/ROW]
[ROW][C]0.89[/C][C]27.4642[/C][C]27.49[/C][C]27.49[/C][C]27.49[/C][C]27.4675[/C][C]27.46[/C][C]27.49[/C][C]27.49[/C][/ROW]
[ROW][C]0.9[/C][C]27.49[/C][C]27.517[/C][C]27.49[/C][C]27.49[/C][C]27.49[/C][C]27.49[/C][C]27.553[/C][C]27.49[/C][/ROW]
[ROW][C]0.91[/C][C]27.5494[/C][C]27.58[/C][C]27.58[/C][C]27.58[/C][C]27.5575[/C][C]27.58[/C][C]27.58[/C][C]27.58[/C][/ROW]
[ROW][C]0.92[/C][C]27.58[/C][C]27.6892[/C][C]27.58[/C][C]27.58[/C][C]27.58[/C][C]27.58[/C][C]27.6008[/C][C]27.71[/C][/ROW]
[ROW][C]0.93[/C][C]27.71[/C][C]27.7243[/C][C]27.71[/C][C]27.71[/C][C]27.71[/C][C]27.71[/C][C]27.8257[/C][C]27.71[/C][/ROW]
[ROW][C]0.94[/C][C]27.7672[/C][C]27.84[/C][C]27.84[/C][C]27.84[/C][C]27.775[/C][C]27.71[/C][C]27.84[/C][C]27.84[/C][/ROW]
[ROW][C]0.95[/C][C]27.84[/C][C]27.931[/C][C]27.84[/C][C]27.84[/C][C]27.84[/C][C]27.84[/C][C]27.889[/C][C]27.98[/C][/ROW]
[ROW][C]0.96[/C][C]27.9744[/C][C]27.98[/C][C]27.98[/C][C]27.98[/C][C]27.98[/C][C]27.98[/C][C]27.98[/C][C]27.98[/C][/ROW]
[ROW][C]0.97[/C][C]27.9844[/C][C]28[/C][C]28[/C][C]28[/C][C]27.985[/C][C]27.98[/C][C]28[/C][C]28[/C][/ROW]
[ROW][C]0.98[/C][C]28[/C][C]28.1104[/C][C]28[/C][C]28[/C][C]28[/C][C]28[/C][C]28.1296[/C][C]28[/C][/ROW]
[ROW][C]0.99[/C][C]28.1776[/C][C]28.24[/C][C]28.24[/C][C]28.24[/C][C]28.18[/C][C]28.24[/C][C]28.24[/C][C]28.24[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=202783&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=202783&T=1

As an alternative you can also use a QR Code:  

The GUIDs for individual cells are displayed in the table below:

Percentiles - Ungrouped Data
pWeighted Average at XnpWeighted Average at X(n+1)pEmpirical Distribution FunctionEmpirical Distribution Function - AveragingEmpirical Distribution Function - InterpolationClosest ObservationTrue Basic - Statistics Graphics ToolkitMS Excel (old versions)
0.0118.9818.9818.9818.9818.98518.9818.9818.98
0.0218.990418.99081919191918.989219
0.031919191919.1575191919
0.0419.2119.2119.2119.2119.2119.2119.2119.21
0.0519.24319.248519.3219.3219.3219.2119.281519.21
0.0619.3219.3219.3219.3219.419.3219.3219.32
0.0719.451219.462419.4819.4819.4819.4819.337619.48
0.0819.481619.483219.519.519.519.4819.496819.48
0.0919.519.519.519.519.50519.519.519.5
0.119.51219.51419.5219.5219.5219.5219.50619.52
0.1119.5219.5219.5219.5219.5219.5219.5219.52
0.1219.5219.5219.5219.5219.5219.5219.5219.52
0.1319.565619.581219.6419.6419.6419.5219.578819.64
0.1419.6419.6419.6419.6419.69519.6419.6419.64
0.1519.73919.7519.7519.7519.7519.7519.7519.75
0.1619.767619.785219.8619.8619.8619.7519.824819.75
0.1719.8619.8619.8619.8619.86519.8619.8619.86
0.1819.873619.877219.8819.8819.8819.8819.862819.88
0.1919.8819.894319.8819.8819.962519.8819.975719.88
0.219.9919.9919.9919.9919.9919.9919.9919.99
0.2120.026820.043620.0720.0720.0719.9920.016420.07
0.2220.0720.0720.0720.0720.1520.0720.0720.07
0.2320.226820.2320.2320.2320.2320.2320.2320.23
0.2420.24220.25420.2820.2820.2820.2320.25620.23
0.2520.2820.2820.2820.2820.2920.2820.2820.28
0.2620.310420.3220.3220.3220.3220.3220.3220.32
0.2720.321620.343220.420.420.3820.3220.376820.32
0.2820.420.420.420.420.420.420.420.4
0.2920.437820.458120.4720.4720.4720.4720.411920.47
0.320.4720.48520.4720.4720.54520.4720.60520.47
0.3120.6220.6220.6220.6220.6220.6220.6220.62
0.3220.674420.728820.7920.7920.7920.6220.681220.79
0.3320.7920.7920.7920.7920.8220.7920.7920.79
0.3420.890820.9120.9120.9120.9120.9120.9120.91
0.3520.932121.1121.1121.0620.9121.0220.91
0.3621.1121.1121.1121.1121.1121.1121.1121.11
0.3721.147221.169421.1721.1721.1721.1721.110621.17
0.3821.1721.172621.1721.1721.17521.1721.177421.17
0.3921.1821.1821.1821.1821.1821.1821.1821.18
0.421.19221.20421.2121.2121.2121.1821.18621.21
0.4121.2121.212821.2121.2121.2221.2121.247221.21
0.4221.246821.2521.2521.2521.2521.2521.2521.25
0.4321.298621.414721.5221.5221.452521.2521.355321.52
0.4421.5221.5221.5221.5221.5221.5221.5221.52
0.4521.61821.6621.6621.6621.6621.6621.6621.66
0.4621.6621.731421.6621.6621.74521.6621.758621.66
0.4721.8321.8321.8321.8321.8321.8321.8321.83
0.4821.849221.868421.8721.8721.8721.8321.831621.87
0.4921.8721.886121.8721.8721.887521.8721.923921.87
0.521.9421.9421.9421.9421.9421.9421.9421.94
0.5121.942621.947721.9521.9521.947521.9421.942321.95
0.5221.9521.951621.9521.9521.9521.9521.988421.95
0.5321.981221.9921.9921.9921.9921.9921.9921.99
0.5421.990421.9958222221.99521.9921.994222
0.552222222222222222
0.5622.095222.1722.1722.1722.1722.1722.1722.17
0.5722.1722.20922.1722.1722.19522.1722.23122.17
0.5822.2722.2722.2722.2722.2722.2722.2722.27
0.5922.300622.353722.3622.3622.337522.2722.276322.36
0.622.3622.422.3622.3622.3622.3622.5222.36
0.6122.53222.5622.5622.5622.5622.5622.5622.56
0.6222.563622.582222.5922.5922.57522.5622.567822.59
0.6322.5922.592722.5922.5922.5922.5922.857322.59
0.6422.762822.8622.8622.8622.8622.8622.8622.86
0.6522.8622.89322.8622.8622.87522.8622.88722.92
0.6622.9222.9222.9222.9222.9222.9222.9222.92
0.6722.995623.123.123.123.05522.9223.123.1
0.6823.123.146823.123.123.123.123.183223.1
0.6923.222223.2323.2323.2323.2323.2323.2323.23
0.723.24223.28423.2923.2923.2623.2323.23623.29
0.7123.2923.335923.2923.2923.2923.2923.514123.29
0.7223.484423.5623.5623.5623.5623.5623.5623.56
0.7323.5623.872423.5623.5623.6723.5623.687624
0.742424242424242424
0.7524.1624.3224.3224.3224.2424.3224.3224.32
0.7624.3225.162424.3224.3224.3224.3225.097625.94
0.7725.9425.9425.9425.9425.9425.9425.9425.94
0.7825.998826.1526.1526.1526.04525.9426.1526.15
0.7926.1526.219326.1526.1526.1526.1526.290726.15
0.826.31826.3626.3626.3626.3626.3626.3626.36
0.8126.38726.751526.8126.8126.472526.3626.418526.81
0.8226.8126.832426.8126.8126.8126.8126.947626.81
0.8326.902826.9726.9726.9726.9326.9726.9726.97
0.8426.9727.017626.9726.9726.9726.9726.992427.04
0.8527.0427.0427.0427.0427.0427.0427.0427.04
0.8627.140827.3227.3227.3227.1827.0427.3227.32
0.8727.3227.388627.3227.3227.3227.3227.391427.32
0.8827.443227.4627.4627.4627.4627.4627.4627.46
0.8927.464227.4927.4927.4927.467527.4627.4927.49
0.927.4927.51727.4927.4927.4927.4927.55327.49
0.9127.549427.5827.5827.5827.557527.5827.5827.58
0.9227.5827.689227.5827.5827.5827.5827.600827.71
0.9327.7127.724327.7127.7127.7127.7127.825727.71
0.9427.767227.8427.8427.8427.77527.7127.8427.84
0.9527.8427.93127.8427.8427.8427.8427.88927.98
0.9627.974427.9827.9827.9827.9827.9827.9827.98
0.9727.984428282827.98527.982828
0.982828.11042828282828.129628
0.9928.177628.2428.2428.2428.1828.2428.2428.24



Parameters (Session):
par1 = grey ;
Parameters (R input):
R code (references can be found in the software module):
x <-sort(x[!is.na(x)])
q1 <- function(data,n,p,i,f) {
np <- n*p;
i <<- floor(np)
f <<- np - i
qvalue <- (1-f)*data[i] + f*data[i+1]
}
q2 <- function(data,n,p,i,f) {
np <- (n+1)*p
i <<- floor(np)
f <<- np - i
qvalue <- (1-f)*data[i] + f*data[i+1]
}
q3 <- function(data,n,p,i,f) {
np <- n*p
i <<- floor(np)
f <<- np - i
if (f==0) {
qvalue <- data[i]
} else {
qvalue <- data[i+1]
}
}
q4 <- function(data,n,p,i,f) {
np <- n*p
i <<- floor(np)
f <<- np - i
if (f==0) {
qvalue <- (data[i]+data[i+1])/2
} else {
qvalue <- data[i+1]
}
}
q5 <- function(data,n,p,i,f) {
np <- (n-1)*p
i <<- floor(np)
f <<- np - i
if (f==0) {
qvalue <- data[i+1]
} else {
qvalue <- data[i+1] + f*(data[i+2]-data[i+1])
}
}
q6 <- function(data,n,p,i,f) {
np <- n*p+0.5
i <<- floor(np)
f <<- np - i
qvalue <- data[i]
}
q7 <- function(data,n,p,i,f) {
np <- (n+1)*p
i <<- floor(np)
f <<- np - i
if (f==0) {
qvalue <- data[i]
} else {
qvalue <- f*data[i] + (1-f)*data[i+1]
}
}
q8 <- function(data,n,p,i,f) {
np <- (n+1)*p
i <<- floor(np)
f <<- np - i
if (f==0) {
qvalue <- data[i]
} else {
if (f == 0.5) {
qvalue <- (data[i]+data[i+1])/2
} else {
if (f < 0.5) {
qvalue <- data[i]
} else {
qvalue <- data[i+1]
}
}
}
}
lx <- length(x)
qval <- array(NA,dim=c(99,8))
mystep <- 25
mystart <- 25
if (lx>10){
mystep=10
mystart=10
}
if (lx>20){
mystep=5
mystart=5
}
if (lx>50){
mystep=2
mystart=2
}
if (lx>=100){
mystep=1
mystart=1
}
for (perc in seq(mystart,99,mystep)) {
qval[perc,1] <- q1(x,lx,perc/100,i,f)
qval[perc,2] <- q2(x,lx,perc/100,i,f)
qval[perc,3] <- q3(x,lx,perc/100,i,f)
qval[perc,4] <- q4(x,lx,perc/100,i,f)
qval[perc,5] <- q5(x,lx,perc/100,i,f)
qval[perc,6] <- q6(x,lx,perc/100,i,f)
qval[perc,7] <- q7(x,lx,perc/100,i,f)
qval[perc,8] <- q8(x,lx,perc/100,i,f)
}
bitmap(file='test1.png')
myqqnorm <- qqnorm(x,col=2)
qqline(x)
grid()
dev.off()
load(file='createtable')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Percentiles - Ungrouped Data',9,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'p',1,TRUE)
a<-table.element(a,hyperlink('method_1.htm', 'Weighted Average at Xnp',''),1,TRUE)
a<-table.element(a,hyperlink('method_2.htm','Weighted Average at X(n+1)p',''),1,TRUE)
a<-table.element(a,hyperlink('method_3.htm','Empirical Distribution Function',''),1,TRUE)
a<-table.element(a,hyperlink('method_4.htm','Empirical Distribution Function - Averaging',''),1,TRUE)
a<-table.element(a,hyperlink('method_5.htm','Empirical Distribution Function - Interpolation',''),1,TRUE)
a<-table.element(a,hyperlink('method_6.htm','Closest Observation',''),1,TRUE)
a<-table.element(a,hyperlink('method_7.htm','True Basic - Statistics Graphics Toolkit',''),1,TRUE)
a<-table.element(a,hyperlink('method_8.htm','MS Excel (old versions)',''),1,TRUE)
a<-table.row.end(a)
for (perc in seq(mystart,99,mystep)) {
a<-table.row.start(a)
a<-table.element(a,round(perc/100,2),1,TRUE)
for (j in 1:8) {
a<-table.element(a,round(qval[perc,j],6))
}
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable.tab')