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 computationMon, 04 Oct 2010 18:16:30 +0000
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2010/Oct/04/t1286216757sy4y20mr91v8yp8.htm/, Retrieved Sun, 28 Apr 2024 05:31:28 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=80892, Retrieved Sun, 28 Apr 2024 05:31:28 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact136
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
F     [Percentiles] [Percentiles of ti...] [2010-09-25 09:52:29] [b98453cac15ba1066b407e146608df68]
F   PD    [Percentiles] [Percentiles] [2010-10-04 18:16:30] [6e52d1bada9435d33ddf990b22ee4b00] [Current]
Feedback Forum
2010-10-09 08:48:14 [abfc2690eac87da053eb0d612ccdbe5b] [reply
1) Er zijn verkeerde data ingevoerd. Je had wel inderdaad naar de rij van 5% gekeken, maar i.p.v. het gewogen gemiddelde (2e kolom), kan je beter de gegevens aflezen in de 5e kolom (Empirical Distribution Function – Interpolation). Bij input van de juiste data kan je dus zien dat de tijd dat 5% van de studenten nodig hebben om een enquete in te vullen 61.9013 seconden bedraagt. Dus vanaf 62 seconden wordt er een deftige poging ondernemen.

2) Door de verkeerde input, geeft het berekende resultaat een vertekend beeld. Nadat je de eerste kolom van het Excel bestand invoerde, kijk je opnieuw naar de 5e kolom. 2 minuten (120') ligt volgens de 5e kolom dan tussen de 10% en 11%. Dus we hebben ongeveer 10% kans dat studenten de enquete invullen in minder dan 2 minuten tijd.
2010-10-09 08:48:17 [abfc2690eac87da053eb0d612ccdbe5b] [reply
1) Er zijn verkeerde data ingevoerd. Je had wel inderdaad naar de rij van 5% gekeken, maar i.p.v. het gewogen gemiddelde (2e kolom), kan je beter de gegevens aflezen in de 5e kolom (Empirical Distribution Function – Interpolation). Bij input van de juiste data kan je dus zien dat de tijd dat 5% van de studenten nodig hebben om een enquete in te vullen 61.9013 seconden bedraagt. Dus vanaf 62 seconden wordt er een deftige poging ondernemen.

2) Door de verkeerde input, geeft het berekende resultaat een vertekend beeld. Nadat je de eerste kolom van het Excel bestand invoerde, kijk je opnieuw naar de 5e kolom. 2 minuten (120') ligt volgens de 5e kolom dan tussen de 10% en 11%. Dus we hebben ongeveer 10% kans dat studenten de enquete invullen in minder dan 2 minuten tijd.

Post a new message
Dataseries X:
8,95
57,47
86,58
137,55
171,26
236,71
239,89
252,64
259,7
308,16
324,04
388,3
392,25
440,31
694,87
756,46
4813
33999
37028
39047
59609
62156
64016
70939
72844
85094
103898
109215
131812
136452
136813
140321
150034
156187
158047
169861
171328
180818
183186
183613
184641
187881
190157
190379
191835
192797
193299
197549
198296
199297
199746
200156
203077
204386
206771
206893
207533
208108
211655
213361
213511
213923
216046
216548
216886
217465
218761
220553
221588
223166
226731
229641
232444
232669
235577
236302
238502
240755
241171
242205
242344
246542
249148
250407
251422
257102
257567
260642
261596
262517
262875
263906
265777
266793
274482
275562
278741
287069
289714
293671
295281
308174
308532
313906
315955
330563
348821
350089
356725
366936
380155
380531
383703
386688
401422
401915
403064
403556
406167
421403
426113
435956
438555
441437
449594
475834
506652
556277
601162
611281
645285
653641
662883
699645
947293
1030944
1305923
2763544
4202361




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time2 seconds
R Server'Sir Ronald Aylmer Fisher' @ 193.190.124.24

\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 & 2 seconds \tabularnewline
R Server & 'Sir Ronald Aylmer Fisher' @ 193.190.124.24 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=80892&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]2 seconds[/C][/ROW]
[ROW][C]R Server[/C][C]'Sir Ronald Aylmer Fisher' @ 193.190.124.24[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=80892&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=80892&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 time2 seconds
R Server'Sir Ronald Aylmer Fisher' @ 193.190.124.24







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.0127.872828.35857.4757.4768.53188.9538.0628.95
0.0280.175880.75886.5886.58125.317286.5863.29286.58
0.03143.2807144.292171.26171.26180.423137.55164.518137.55
0.04207.912210.53236.71236.71238.3636236.71197.44236.71
0.05239.731239.89239.89239.89251.365239.89239.89239.89
0.06255.0404255.464259.7259.7273.2688252.64256.876252.64
0.07295.0758298.468308.16308.16318.6408308.16269.392308.16
0.08331.7512336.892388.3388.3388.458324.04375.448324.04
0.09390.3145390.67392.25392.25412.4352392.25389.88392.25
0.1435.504440.31440.31440.31643.958440.31440.31440.31
0.11712.7311719.506756.46756.461486.6372694.87731.824694.87
0.123514.90724001.6924813481321157.1648131567.7684813
0.1334211.0334604.8370283702836846.263399936422.233999
0.1437956.7438239.4390473904745626.843702837835.639047
0.1556524.759609596095960961391.9596095960959609
0.1662602.462900640166401664569.84621566327262156
0.1768377.4969554.4709397093971815.37093965400.670939
0.187308975294850948509483134728448264472844
0.1992803.6496376.4103898103898105067.748509492615.6103898
0.2108151.6109215109215109215122773.2109215109215109215
0.21132693.6133668136452136452136359.2131812134596131812
0.22136661.38136740.8136813136813138075.88136813136524.2136813
0.23140215.76142263.6140321140321147508.62140321148091.4140321
0.24152249.08153725.8156187156187156410.2150034152495.2156187
0.25157582158047158047158047163954158047158047158047
0.26170066.38170447.8171328171328171151.96169861170741.2169861
0.27176357.7178920180818180818181433.68180818173226180818
0.28182996.56183271.4183186183186183459.28183186183527.6183186
0.29183931.68184229.8184641184641184705.8183613184024.2184641
0.3186909187881187881187881188791.4187881187881187881
0.31190176.98190245.8190379190379190330.16190157190290.2190157
0.32191077.88191543.8191835191835191988.92190379190670.2191835
0.33192671.94192897.4192797192797193068.08192797193198.6192797
0.34194404195849197549197549197209193299194999197549
0.35198034.55198296198296198296198596.3198296198296198296
0.36199314.96199476.6199746199746199602.32199297199566.4199297
0.37199922.3200074200156200156200331.26199746199828200156
0.38202551.22203338.8203077203077203652.96203077204124.2203077
0.39204886.85205817206771206771206341.7204386205340206771
0.4206844.2206893206893206893207021206893206893206893
0.41207526.6207763207533207533207866.5207533207878207533
0.42209455.86210945.6211655211655211513.12208108208817.4211655
0.43212968.62213391213361213361213412213361213481213361
0.44213576.92213758.2213923213923213807.64213511213675.8213923
0.45215090.65216046216046216046216096.2216046216046216046
0.46216517.88216683.2216548216548216710.24216548216750.8216548
0.47217077.07217349.2217465217465217383.94216886217001.8217465
0.48218398.12219119.4218761218761219191.08218761220194.6218761
0.49220666.85221174221588221588221194.7220553220967221588
0.5222377223166223166223166223166223166223166223166
0.51226338.85227895226731226731227836.8226731228477226731
0.52230425.84231883.4232444232444231771.28229641230201.6232444
0.53232594.75233250.6232669232669233076.12232669234995.4232669
0.54235620.5236012236302236302235954235577235867236302
0.55237292238502238502238502238282236302238502238502
0.56240394.52240921.4240755240755240871.48240755241004.6240755
0.57241408.82241998.2242205242205241853.44241171241377.8242205
0.58242291.18243183.6242344242344242511.92242344245702.4242344
0.59246568.06248105.6249148249148247636.52246542247584.4249148
0.6249651.6250407250407250407250155.2249148250407250407
0.61251208.85253694251422251422252444.4251422254830251422
0.62257185.7257474257567257567257362.4257102257195257567
0.63259319.75260832.8260642260642260457.5260642261405.2260642
0.64261557.84262148.6261596261596261890.72261596261964.4262517
0.65262642.3262875262875262875262767.6262517262875262875
0.66263637.94264654.4263906263906264055.68263906265028.6263906
0.67265909.08266589.8266793266793266244.36265777265980.2266793
0.68270791.28274698274482274482273251.76274482275346274482
0.69275464.8277469.4275562275562276261.38275562276833.6278741
0.7281239.4287069287069287069283737.8278741287069287069
0.71288894.05291296.8289714289714289661.1289714292088.2289714
0.72293799.8294959295281295281294250.6293671293993295281
0.73301340.71308245.6308174308174304821.82295281308460.4308174
0.74308481.88311756.4308532308532309176.88308532310681.6313906
0.75314418.25315955315955315955314930.5313906315955315955
0.76325304.12337866.2330563330563328810.04330563341517.8330563
0.77348859.04349835.4350089350089349150.68348821349074.6350089
0.78352876.12358767.2356725356725354336.04350089364893.8356725
0.79364995.91374867.4366936366936367200.38366936372223.6380155
0.8380230.2380531380531380531380305.4380155380531380531
0.81382402.48384897383703383703383005.16383703385494383703
0.82386628.3398475.2386688386688389045.44386688389634.8401422
0.83401604.41402144.8401915401915401688.22401422402834.2401915
0.84402788.24403359.2403064403064402972.08403064403260.8403556
0.85403947.65406167406167406167404339.3403556406167406167
0.86414394.44423287421403421403416527.48421403424229421403
0.87425783.3433987.4426113426113426703.58426113428081.6435956
0.88436787.68439131.4438555438555437099.56435956440860.6438555
0.89440601.22446331.2441437441437440918.24441437444699.8449594
0.9452218475834475834475834454842449594475834475834
0.91490934.82526502506652506652493708.44475834536427506652
0.92550322592185556277556277554292556277565254601162
0.93603894.13618081.8611281611281604602.46601162638484.2611281
0.94633723.64650298.6645285645285635763.88645285648627.4653641
0.95654103.1662883662883662883654565.2653641662883662883
0.96679058.28798704.2699645699645680528.76662883848233.8699645
0.97905192.841014213.8947293947293912622.28947293964023.21030944
0.981091439.381597447.2130592313059231096938.9610309442472019.81305923
0.992195071.813626834.2276354427635442209648.0227635443339070.84202361

\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 & 27.8728 & 28.358 & 57.47 & 57.47 & 68.5318 & 8.95 & 38.062 & 8.95 \tabularnewline
0.02 & 80.1758 & 80.758 & 86.58 & 86.58 & 125.3172 & 86.58 & 63.292 & 86.58 \tabularnewline
0.03 & 143.2807 & 144.292 & 171.26 & 171.26 & 180.423 & 137.55 & 164.518 & 137.55 \tabularnewline
0.04 & 207.912 & 210.53 & 236.71 & 236.71 & 238.3636 & 236.71 & 197.44 & 236.71 \tabularnewline
0.05 & 239.731 & 239.89 & 239.89 & 239.89 & 251.365 & 239.89 & 239.89 & 239.89 \tabularnewline
0.06 & 255.0404 & 255.464 & 259.7 & 259.7 & 273.2688 & 252.64 & 256.876 & 252.64 \tabularnewline
0.07 & 295.0758 & 298.468 & 308.16 & 308.16 & 318.6408 & 308.16 & 269.392 & 308.16 \tabularnewline
0.08 & 331.7512 & 336.892 & 388.3 & 388.3 & 388.458 & 324.04 & 375.448 & 324.04 \tabularnewline
0.09 & 390.3145 & 390.67 & 392.25 & 392.25 & 412.4352 & 392.25 & 389.88 & 392.25 \tabularnewline
0.1 & 435.504 & 440.31 & 440.31 & 440.31 & 643.958 & 440.31 & 440.31 & 440.31 \tabularnewline
0.11 & 712.7311 & 719.506 & 756.46 & 756.46 & 1486.6372 & 694.87 & 731.824 & 694.87 \tabularnewline
0.12 & 3514.9072 & 4001.692 & 4813 & 4813 & 21157.16 & 4813 & 1567.768 & 4813 \tabularnewline
0.13 & 34211.03 & 34604.8 & 37028 & 37028 & 36846.26 & 33999 & 36422.2 & 33999 \tabularnewline
0.14 & 37956.74 & 38239.4 & 39047 & 39047 & 45626.84 & 37028 & 37835.6 & 39047 \tabularnewline
0.15 & 56524.7 & 59609 & 59609 & 59609 & 61391.9 & 59609 & 59609 & 59609 \tabularnewline
0.16 & 62602.4 & 62900 & 64016 & 64016 & 64569.84 & 62156 & 63272 & 62156 \tabularnewline
0.17 & 68377.49 & 69554.4 & 70939 & 70939 & 71815.3 & 70939 & 65400.6 & 70939 \tabularnewline
0.18 & 73089 & 75294 & 85094 & 85094 & 83134 & 72844 & 82644 & 72844 \tabularnewline
0.19 & 92803.64 & 96376.4 & 103898 & 103898 & 105067.74 & 85094 & 92615.6 & 103898 \tabularnewline
0.2 & 108151.6 & 109215 & 109215 & 109215 & 122773.2 & 109215 & 109215 & 109215 \tabularnewline
0.21 & 132693.6 & 133668 & 136452 & 136452 & 136359.2 & 131812 & 134596 & 131812 \tabularnewline
0.22 & 136661.38 & 136740.8 & 136813 & 136813 & 138075.88 & 136813 & 136524.2 & 136813 \tabularnewline
0.23 & 140215.76 & 142263.6 & 140321 & 140321 & 147508.62 & 140321 & 148091.4 & 140321 \tabularnewline
0.24 & 152249.08 & 153725.8 & 156187 & 156187 & 156410.2 & 150034 & 152495.2 & 156187 \tabularnewline
0.25 & 157582 & 158047 & 158047 & 158047 & 163954 & 158047 & 158047 & 158047 \tabularnewline
0.26 & 170066.38 & 170447.8 & 171328 & 171328 & 171151.96 & 169861 & 170741.2 & 169861 \tabularnewline
0.27 & 176357.7 & 178920 & 180818 & 180818 & 181433.68 & 180818 & 173226 & 180818 \tabularnewline
0.28 & 182996.56 & 183271.4 & 183186 & 183186 & 183459.28 & 183186 & 183527.6 & 183186 \tabularnewline
0.29 & 183931.68 & 184229.8 & 184641 & 184641 & 184705.8 & 183613 & 184024.2 & 184641 \tabularnewline
0.3 & 186909 & 187881 & 187881 & 187881 & 188791.4 & 187881 & 187881 & 187881 \tabularnewline
0.31 & 190176.98 & 190245.8 & 190379 & 190379 & 190330.16 & 190157 & 190290.2 & 190157 \tabularnewline
0.32 & 191077.88 & 191543.8 & 191835 & 191835 & 191988.92 & 190379 & 190670.2 & 191835 \tabularnewline
0.33 & 192671.94 & 192897.4 & 192797 & 192797 & 193068.08 & 192797 & 193198.6 & 192797 \tabularnewline
0.34 & 194404 & 195849 & 197549 & 197549 & 197209 & 193299 & 194999 & 197549 \tabularnewline
0.35 & 198034.55 & 198296 & 198296 & 198296 & 198596.3 & 198296 & 198296 & 198296 \tabularnewline
0.36 & 199314.96 & 199476.6 & 199746 & 199746 & 199602.32 & 199297 & 199566.4 & 199297 \tabularnewline
0.37 & 199922.3 & 200074 & 200156 & 200156 & 200331.26 & 199746 & 199828 & 200156 \tabularnewline
0.38 & 202551.22 & 203338.8 & 203077 & 203077 & 203652.96 & 203077 & 204124.2 & 203077 \tabularnewline
0.39 & 204886.85 & 205817 & 206771 & 206771 & 206341.7 & 204386 & 205340 & 206771 \tabularnewline
0.4 & 206844.2 & 206893 & 206893 & 206893 & 207021 & 206893 & 206893 & 206893 \tabularnewline
0.41 & 207526.6 & 207763 & 207533 & 207533 & 207866.5 & 207533 & 207878 & 207533 \tabularnewline
0.42 & 209455.86 & 210945.6 & 211655 & 211655 & 211513.12 & 208108 & 208817.4 & 211655 \tabularnewline
0.43 & 212968.62 & 213391 & 213361 & 213361 & 213412 & 213361 & 213481 & 213361 \tabularnewline
0.44 & 213576.92 & 213758.2 & 213923 & 213923 & 213807.64 & 213511 & 213675.8 & 213923 \tabularnewline
0.45 & 215090.65 & 216046 & 216046 & 216046 & 216096.2 & 216046 & 216046 & 216046 \tabularnewline
0.46 & 216517.88 & 216683.2 & 216548 & 216548 & 216710.24 & 216548 & 216750.8 & 216548 \tabularnewline
0.47 & 217077.07 & 217349.2 & 217465 & 217465 & 217383.94 & 216886 & 217001.8 & 217465 \tabularnewline
0.48 & 218398.12 & 219119.4 & 218761 & 218761 & 219191.08 & 218761 & 220194.6 & 218761 \tabularnewline
0.49 & 220666.85 & 221174 & 221588 & 221588 & 221194.7 & 220553 & 220967 & 221588 \tabularnewline
0.5 & 222377 & 223166 & 223166 & 223166 & 223166 & 223166 & 223166 & 223166 \tabularnewline
0.51 & 226338.85 & 227895 & 226731 & 226731 & 227836.8 & 226731 & 228477 & 226731 \tabularnewline
0.52 & 230425.84 & 231883.4 & 232444 & 232444 & 231771.28 & 229641 & 230201.6 & 232444 \tabularnewline
0.53 & 232594.75 & 233250.6 & 232669 & 232669 & 233076.12 & 232669 & 234995.4 & 232669 \tabularnewline
0.54 & 235620.5 & 236012 & 236302 & 236302 & 235954 & 235577 & 235867 & 236302 \tabularnewline
0.55 & 237292 & 238502 & 238502 & 238502 & 238282 & 236302 & 238502 & 238502 \tabularnewline
0.56 & 240394.52 & 240921.4 & 240755 & 240755 & 240871.48 & 240755 & 241004.6 & 240755 \tabularnewline
0.57 & 241408.82 & 241998.2 & 242205 & 242205 & 241853.44 & 241171 & 241377.8 & 242205 \tabularnewline
0.58 & 242291.18 & 243183.6 & 242344 & 242344 & 242511.92 & 242344 & 245702.4 & 242344 \tabularnewline
0.59 & 246568.06 & 248105.6 & 249148 & 249148 & 247636.52 & 246542 & 247584.4 & 249148 \tabularnewline
0.6 & 249651.6 & 250407 & 250407 & 250407 & 250155.2 & 249148 & 250407 & 250407 \tabularnewline
0.61 & 251208.85 & 253694 & 251422 & 251422 & 252444.4 & 251422 & 254830 & 251422 \tabularnewline
0.62 & 257185.7 & 257474 & 257567 & 257567 & 257362.4 & 257102 & 257195 & 257567 \tabularnewline
0.63 & 259319.75 & 260832.8 & 260642 & 260642 & 260457.5 & 260642 & 261405.2 & 260642 \tabularnewline
0.64 & 261557.84 & 262148.6 & 261596 & 261596 & 261890.72 & 261596 & 261964.4 & 262517 \tabularnewline
0.65 & 262642.3 & 262875 & 262875 & 262875 & 262767.6 & 262517 & 262875 & 262875 \tabularnewline
0.66 & 263637.94 & 264654.4 & 263906 & 263906 & 264055.68 & 263906 & 265028.6 & 263906 \tabularnewline
0.67 & 265909.08 & 266589.8 & 266793 & 266793 & 266244.36 & 265777 & 265980.2 & 266793 \tabularnewline
0.68 & 270791.28 & 274698 & 274482 & 274482 & 273251.76 & 274482 & 275346 & 274482 \tabularnewline
0.69 & 275464.8 & 277469.4 & 275562 & 275562 & 276261.38 & 275562 & 276833.6 & 278741 \tabularnewline
0.7 & 281239.4 & 287069 & 287069 & 287069 & 283737.8 & 278741 & 287069 & 287069 \tabularnewline
0.71 & 288894.05 & 291296.8 & 289714 & 289714 & 289661.1 & 289714 & 292088.2 & 289714 \tabularnewline
0.72 & 293799.8 & 294959 & 295281 & 295281 & 294250.6 & 293671 & 293993 & 295281 \tabularnewline
0.73 & 301340.71 & 308245.6 & 308174 & 308174 & 304821.82 & 295281 & 308460.4 & 308174 \tabularnewline
0.74 & 308481.88 & 311756.4 & 308532 & 308532 & 309176.88 & 308532 & 310681.6 & 313906 \tabularnewline
0.75 & 314418.25 & 315955 & 315955 & 315955 & 314930.5 & 313906 & 315955 & 315955 \tabularnewline
0.76 & 325304.12 & 337866.2 & 330563 & 330563 & 328810.04 & 330563 & 341517.8 & 330563 \tabularnewline
0.77 & 348859.04 & 349835.4 & 350089 & 350089 & 349150.68 & 348821 & 349074.6 & 350089 \tabularnewline
0.78 & 352876.12 & 358767.2 & 356725 & 356725 & 354336.04 & 350089 & 364893.8 & 356725 \tabularnewline
0.79 & 364995.91 & 374867.4 & 366936 & 366936 & 367200.38 & 366936 & 372223.6 & 380155 \tabularnewline
0.8 & 380230.2 & 380531 & 380531 & 380531 & 380305.4 & 380155 & 380531 & 380531 \tabularnewline
0.81 & 382402.48 & 384897 & 383703 & 383703 & 383005.16 & 383703 & 385494 & 383703 \tabularnewline
0.82 & 386628.3 & 398475.2 & 386688 & 386688 & 389045.44 & 386688 & 389634.8 & 401422 \tabularnewline
0.83 & 401604.41 & 402144.8 & 401915 & 401915 & 401688.22 & 401422 & 402834.2 & 401915 \tabularnewline
0.84 & 402788.24 & 403359.2 & 403064 & 403064 & 402972.08 & 403064 & 403260.8 & 403556 \tabularnewline
0.85 & 403947.65 & 406167 & 406167 & 406167 & 404339.3 & 403556 & 406167 & 406167 \tabularnewline
0.86 & 414394.44 & 423287 & 421403 & 421403 & 416527.48 & 421403 & 424229 & 421403 \tabularnewline
0.87 & 425783.3 & 433987.4 & 426113 & 426113 & 426703.58 & 426113 & 428081.6 & 435956 \tabularnewline
0.88 & 436787.68 & 439131.4 & 438555 & 438555 & 437099.56 & 435956 & 440860.6 & 438555 \tabularnewline
0.89 & 440601.22 & 446331.2 & 441437 & 441437 & 440918.24 & 441437 & 444699.8 & 449594 \tabularnewline
0.9 & 452218 & 475834 & 475834 & 475834 & 454842 & 449594 & 475834 & 475834 \tabularnewline
0.91 & 490934.82 & 526502 & 506652 & 506652 & 493708.44 & 475834 & 536427 & 506652 \tabularnewline
0.92 & 550322 & 592185 & 556277 & 556277 & 554292 & 556277 & 565254 & 601162 \tabularnewline
0.93 & 603894.13 & 618081.8 & 611281 & 611281 & 604602.46 & 601162 & 638484.2 & 611281 \tabularnewline
0.94 & 633723.64 & 650298.6 & 645285 & 645285 & 635763.88 & 645285 & 648627.4 & 653641 \tabularnewline
0.95 & 654103.1 & 662883 & 662883 & 662883 & 654565.2 & 653641 & 662883 & 662883 \tabularnewline
0.96 & 679058.28 & 798704.2 & 699645 & 699645 & 680528.76 & 662883 & 848233.8 & 699645 \tabularnewline
0.97 & 905192.84 & 1014213.8 & 947293 & 947293 & 912622.28 & 947293 & 964023.2 & 1030944 \tabularnewline
0.98 & 1091439.38 & 1597447.2 & 1305923 & 1305923 & 1096938.96 & 1030944 & 2472019.8 & 1305923 \tabularnewline
0.99 & 2195071.81 & 3626834.2 & 2763544 & 2763544 & 2209648.02 & 2763544 & 3339070.8 & 4202361 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=80892&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]27.8728[/C][C]28.358[/C][C]57.47[/C][C]57.47[/C][C]68.5318[/C][C]8.95[/C][C]38.062[/C][C]8.95[/C][/ROW]
[ROW][C]0.02[/C][C]80.1758[/C][C]80.758[/C][C]86.58[/C][C]86.58[/C][C]125.3172[/C][C]86.58[/C][C]63.292[/C][C]86.58[/C][/ROW]
[ROW][C]0.03[/C][C]143.2807[/C][C]144.292[/C][C]171.26[/C][C]171.26[/C][C]180.423[/C][C]137.55[/C][C]164.518[/C][C]137.55[/C][/ROW]
[ROW][C]0.04[/C][C]207.912[/C][C]210.53[/C][C]236.71[/C][C]236.71[/C][C]238.3636[/C][C]236.71[/C][C]197.44[/C][C]236.71[/C][/ROW]
[ROW][C]0.05[/C][C]239.731[/C][C]239.89[/C][C]239.89[/C][C]239.89[/C][C]251.365[/C][C]239.89[/C][C]239.89[/C][C]239.89[/C][/ROW]
[ROW][C]0.06[/C][C]255.0404[/C][C]255.464[/C][C]259.7[/C][C]259.7[/C][C]273.2688[/C][C]252.64[/C][C]256.876[/C][C]252.64[/C][/ROW]
[ROW][C]0.07[/C][C]295.0758[/C][C]298.468[/C][C]308.16[/C][C]308.16[/C][C]318.6408[/C][C]308.16[/C][C]269.392[/C][C]308.16[/C][/ROW]
[ROW][C]0.08[/C][C]331.7512[/C][C]336.892[/C][C]388.3[/C][C]388.3[/C][C]388.458[/C][C]324.04[/C][C]375.448[/C][C]324.04[/C][/ROW]
[ROW][C]0.09[/C][C]390.3145[/C][C]390.67[/C][C]392.25[/C][C]392.25[/C][C]412.4352[/C][C]392.25[/C][C]389.88[/C][C]392.25[/C][/ROW]
[ROW][C]0.1[/C][C]435.504[/C][C]440.31[/C][C]440.31[/C][C]440.31[/C][C]643.958[/C][C]440.31[/C][C]440.31[/C][C]440.31[/C][/ROW]
[ROW][C]0.11[/C][C]712.7311[/C][C]719.506[/C][C]756.46[/C][C]756.46[/C][C]1486.6372[/C][C]694.87[/C][C]731.824[/C][C]694.87[/C][/ROW]
[ROW][C]0.12[/C][C]3514.9072[/C][C]4001.692[/C][C]4813[/C][C]4813[/C][C]21157.16[/C][C]4813[/C][C]1567.768[/C][C]4813[/C][/ROW]
[ROW][C]0.13[/C][C]34211.03[/C][C]34604.8[/C][C]37028[/C][C]37028[/C][C]36846.26[/C][C]33999[/C][C]36422.2[/C][C]33999[/C][/ROW]
[ROW][C]0.14[/C][C]37956.74[/C][C]38239.4[/C][C]39047[/C][C]39047[/C][C]45626.84[/C][C]37028[/C][C]37835.6[/C][C]39047[/C][/ROW]
[ROW][C]0.15[/C][C]56524.7[/C][C]59609[/C][C]59609[/C][C]59609[/C][C]61391.9[/C][C]59609[/C][C]59609[/C][C]59609[/C][/ROW]
[ROW][C]0.16[/C][C]62602.4[/C][C]62900[/C][C]64016[/C][C]64016[/C][C]64569.84[/C][C]62156[/C][C]63272[/C][C]62156[/C][/ROW]
[ROW][C]0.17[/C][C]68377.49[/C][C]69554.4[/C][C]70939[/C][C]70939[/C][C]71815.3[/C][C]70939[/C][C]65400.6[/C][C]70939[/C][/ROW]
[ROW][C]0.18[/C][C]73089[/C][C]75294[/C][C]85094[/C][C]85094[/C][C]83134[/C][C]72844[/C][C]82644[/C][C]72844[/C][/ROW]
[ROW][C]0.19[/C][C]92803.64[/C][C]96376.4[/C][C]103898[/C][C]103898[/C][C]105067.74[/C][C]85094[/C][C]92615.6[/C][C]103898[/C][/ROW]
[ROW][C]0.2[/C][C]108151.6[/C][C]109215[/C][C]109215[/C][C]109215[/C][C]122773.2[/C][C]109215[/C][C]109215[/C][C]109215[/C][/ROW]
[ROW][C]0.21[/C][C]132693.6[/C][C]133668[/C][C]136452[/C][C]136452[/C][C]136359.2[/C][C]131812[/C][C]134596[/C][C]131812[/C][/ROW]
[ROW][C]0.22[/C][C]136661.38[/C][C]136740.8[/C][C]136813[/C][C]136813[/C][C]138075.88[/C][C]136813[/C][C]136524.2[/C][C]136813[/C][/ROW]
[ROW][C]0.23[/C][C]140215.76[/C][C]142263.6[/C][C]140321[/C][C]140321[/C][C]147508.62[/C][C]140321[/C][C]148091.4[/C][C]140321[/C][/ROW]
[ROW][C]0.24[/C][C]152249.08[/C][C]153725.8[/C][C]156187[/C][C]156187[/C][C]156410.2[/C][C]150034[/C][C]152495.2[/C][C]156187[/C][/ROW]
[ROW][C]0.25[/C][C]157582[/C][C]158047[/C][C]158047[/C][C]158047[/C][C]163954[/C][C]158047[/C][C]158047[/C][C]158047[/C][/ROW]
[ROW][C]0.26[/C][C]170066.38[/C][C]170447.8[/C][C]171328[/C][C]171328[/C][C]171151.96[/C][C]169861[/C][C]170741.2[/C][C]169861[/C][/ROW]
[ROW][C]0.27[/C][C]176357.7[/C][C]178920[/C][C]180818[/C][C]180818[/C][C]181433.68[/C][C]180818[/C][C]173226[/C][C]180818[/C][/ROW]
[ROW][C]0.28[/C][C]182996.56[/C][C]183271.4[/C][C]183186[/C][C]183186[/C][C]183459.28[/C][C]183186[/C][C]183527.6[/C][C]183186[/C][/ROW]
[ROW][C]0.29[/C][C]183931.68[/C][C]184229.8[/C][C]184641[/C][C]184641[/C][C]184705.8[/C][C]183613[/C][C]184024.2[/C][C]184641[/C][/ROW]
[ROW][C]0.3[/C][C]186909[/C][C]187881[/C][C]187881[/C][C]187881[/C][C]188791.4[/C][C]187881[/C][C]187881[/C][C]187881[/C][/ROW]
[ROW][C]0.31[/C][C]190176.98[/C][C]190245.8[/C][C]190379[/C][C]190379[/C][C]190330.16[/C][C]190157[/C][C]190290.2[/C][C]190157[/C][/ROW]
[ROW][C]0.32[/C][C]191077.88[/C][C]191543.8[/C][C]191835[/C][C]191835[/C][C]191988.92[/C][C]190379[/C][C]190670.2[/C][C]191835[/C][/ROW]
[ROW][C]0.33[/C][C]192671.94[/C][C]192897.4[/C][C]192797[/C][C]192797[/C][C]193068.08[/C][C]192797[/C][C]193198.6[/C][C]192797[/C][/ROW]
[ROW][C]0.34[/C][C]194404[/C][C]195849[/C][C]197549[/C][C]197549[/C][C]197209[/C][C]193299[/C][C]194999[/C][C]197549[/C][/ROW]
[ROW][C]0.35[/C][C]198034.55[/C][C]198296[/C][C]198296[/C][C]198296[/C][C]198596.3[/C][C]198296[/C][C]198296[/C][C]198296[/C][/ROW]
[ROW][C]0.36[/C][C]199314.96[/C][C]199476.6[/C][C]199746[/C][C]199746[/C][C]199602.32[/C][C]199297[/C][C]199566.4[/C][C]199297[/C][/ROW]
[ROW][C]0.37[/C][C]199922.3[/C][C]200074[/C][C]200156[/C][C]200156[/C][C]200331.26[/C][C]199746[/C][C]199828[/C][C]200156[/C][/ROW]
[ROW][C]0.38[/C][C]202551.22[/C][C]203338.8[/C][C]203077[/C][C]203077[/C][C]203652.96[/C][C]203077[/C][C]204124.2[/C][C]203077[/C][/ROW]
[ROW][C]0.39[/C][C]204886.85[/C][C]205817[/C][C]206771[/C][C]206771[/C][C]206341.7[/C][C]204386[/C][C]205340[/C][C]206771[/C][/ROW]
[ROW][C]0.4[/C][C]206844.2[/C][C]206893[/C][C]206893[/C][C]206893[/C][C]207021[/C][C]206893[/C][C]206893[/C][C]206893[/C][/ROW]
[ROW][C]0.41[/C][C]207526.6[/C][C]207763[/C][C]207533[/C][C]207533[/C][C]207866.5[/C][C]207533[/C][C]207878[/C][C]207533[/C][/ROW]
[ROW][C]0.42[/C][C]209455.86[/C][C]210945.6[/C][C]211655[/C][C]211655[/C][C]211513.12[/C][C]208108[/C][C]208817.4[/C][C]211655[/C][/ROW]
[ROW][C]0.43[/C][C]212968.62[/C][C]213391[/C][C]213361[/C][C]213361[/C][C]213412[/C][C]213361[/C][C]213481[/C][C]213361[/C][/ROW]
[ROW][C]0.44[/C][C]213576.92[/C][C]213758.2[/C][C]213923[/C][C]213923[/C][C]213807.64[/C][C]213511[/C][C]213675.8[/C][C]213923[/C][/ROW]
[ROW][C]0.45[/C][C]215090.65[/C][C]216046[/C][C]216046[/C][C]216046[/C][C]216096.2[/C][C]216046[/C][C]216046[/C][C]216046[/C][/ROW]
[ROW][C]0.46[/C][C]216517.88[/C][C]216683.2[/C][C]216548[/C][C]216548[/C][C]216710.24[/C][C]216548[/C][C]216750.8[/C][C]216548[/C][/ROW]
[ROW][C]0.47[/C][C]217077.07[/C][C]217349.2[/C][C]217465[/C][C]217465[/C][C]217383.94[/C][C]216886[/C][C]217001.8[/C][C]217465[/C][/ROW]
[ROW][C]0.48[/C][C]218398.12[/C][C]219119.4[/C][C]218761[/C][C]218761[/C][C]219191.08[/C][C]218761[/C][C]220194.6[/C][C]218761[/C][/ROW]
[ROW][C]0.49[/C][C]220666.85[/C][C]221174[/C][C]221588[/C][C]221588[/C][C]221194.7[/C][C]220553[/C][C]220967[/C][C]221588[/C][/ROW]
[ROW][C]0.5[/C][C]222377[/C][C]223166[/C][C]223166[/C][C]223166[/C][C]223166[/C][C]223166[/C][C]223166[/C][C]223166[/C][/ROW]
[ROW][C]0.51[/C][C]226338.85[/C][C]227895[/C][C]226731[/C][C]226731[/C][C]227836.8[/C][C]226731[/C][C]228477[/C][C]226731[/C][/ROW]
[ROW][C]0.52[/C][C]230425.84[/C][C]231883.4[/C][C]232444[/C][C]232444[/C][C]231771.28[/C][C]229641[/C][C]230201.6[/C][C]232444[/C][/ROW]
[ROW][C]0.53[/C][C]232594.75[/C][C]233250.6[/C][C]232669[/C][C]232669[/C][C]233076.12[/C][C]232669[/C][C]234995.4[/C][C]232669[/C][/ROW]
[ROW][C]0.54[/C][C]235620.5[/C][C]236012[/C][C]236302[/C][C]236302[/C][C]235954[/C][C]235577[/C][C]235867[/C][C]236302[/C][/ROW]
[ROW][C]0.55[/C][C]237292[/C][C]238502[/C][C]238502[/C][C]238502[/C][C]238282[/C][C]236302[/C][C]238502[/C][C]238502[/C][/ROW]
[ROW][C]0.56[/C][C]240394.52[/C][C]240921.4[/C][C]240755[/C][C]240755[/C][C]240871.48[/C][C]240755[/C][C]241004.6[/C][C]240755[/C][/ROW]
[ROW][C]0.57[/C][C]241408.82[/C][C]241998.2[/C][C]242205[/C][C]242205[/C][C]241853.44[/C][C]241171[/C][C]241377.8[/C][C]242205[/C][/ROW]
[ROW][C]0.58[/C][C]242291.18[/C][C]243183.6[/C][C]242344[/C][C]242344[/C][C]242511.92[/C][C]242344[/C][C]245702.4[/C][C]242344[/C][/ROW]
[ROW][C]0.59[/C][C]246568.06[/C][C]248105.6[/C][C]249148[/C][C]249148[/C][C]247636.52[/C][C]246542[/C][C]247584.4[/C][C]249148[/C][/ROW]
[ROW][C]0.6[/C][C]249651.6[/C][C]250407[/C][C]250407[/C][C]250407[/C][C]250155.2[/C][C]249148[/C][C]250407[/C][C]250407[/C][/ROW]
[ROW][C]0.61[/C][C]251208.85[/C][C]253694[/C][C]251422[/C][C]251422[/C][C]252444.4[/C][C]251422[/C][C]254830[/C][C]251422[/C][/ROW]
[ROW][C]0.62[/C][C]257185.7[/C][C]257474[/C][C]257567[/C][C]257567[/C][C]257362.4[/C][C]257102[/C][C]257195[/C][C]257567[/C][/ROW]
[ROW][C]0.63[/C][C]259319.75[/C][C]260832.8[/C][C]260642[/C][C]260642[/C][C]260457.5[/C][C]260642[/C][C]261405.2[/C][C]260642[/C][/ROW]
[ROW][C]0.64[/C][C]261557.84[/C][C]262148.6[/C][C]261596[/C][C]261596[/C][C]261890.72[/C][C]261596[/C][C]261964.4[/C][C]262517[/C][/ROW]
[ROW][C]0.65[/C][C]262642.3[/C][C]262875[/C][C]262875[/C][C]262875[/C][C]262767.6[/C][C]262517[/C][C]262875[/C][C]262875[/C][/ROW]
[ROW][C]0.66[/C][C]263637.94[/C][C]264654.4[/C][C]263906[/C][C]263906[/C][C]264055.68[/C][C]263906[/C][C]265028.6[/C][C]263906[/C][/ROW]
[ROW][C]0.67[/C][C]265909.08[/C][C]266589.8[/C][C]266793[/C][C]266793[/C][C]266244.36[/C][C]265777[/C][C]265980.2[/C][C]266793[/C][/ROW]
[ROW][C]0.68[/C][C]270791.28[/C][C]274698[/C][C]274482[/C][C]274482[/C][C]273251.76[/C][C]274482[/C][C]275346[/C][C]274482[/C][/ROW]
[ROW][C]0.69[/C][C]275464.8[/C][C]277469.4[/C][C]275562[/C][C]275562[/C][C]276261.38[/C][C]275562[/C][C]276833.6[/C][C]278741[/C][/ROW]
[ROW][C]0.7[/C][C]281239.4[/C][C]287069[/C][C]287069[/C][C]287069[/C][C]283737.8[/C][C]278741[/C][C]287069[/C][C]287069[/C][/ROW]
[ROW][C]0.71[/C][C]288894.05[/C][C]291296.8[/C][C]289714[/C][C]289714[/C][C]289661.1[/C][C]289714[/C][C]292088.2[/C][C]289714[/C][/ROW]
[ROW][C]0.72[/C][C]293799.8[/C][C]294959[/C][C]295281[/C][C]295281[/C][C]294250.6[/C][C]293671[/C][C]293993[/C][C]295281[/C][/ROW]
[ROW][C]0.73[/C][C]301340.71[/C][C]308245.6[/C][C]308174[/C][C]308174[/C][C]304821.82[/C][C]295281[/C][C]308460.4[/C][C]308174[/C][/ROW]
[ROW][C]0.74[/C][C]308481.88[/C][C]311756.4[/C][C]308532[/C][C]308532[/C][C]309176.88[/C][C]308532[/C][C]310681.6[/C][C]313906[/C][/ROW]
[ROW][C]0.75[/C][C]314418.25[/C][C]315955[/C][C]315955[/C][C]315955[/C][C]314930.5[/C][C]313906[/C][C]315955[/C][C]315955[/C][/ROW]
[ROW][C]0.76[/C][C]325304.12[/C][C]337866.2[/C][C]330563[/C][C]330563[/C][C]328810.04[/C][C]330563[/C][C]341517.8[/C][C]330563[/C][/ROW]
[ROW][C]0.77[/C][C]348859.04[/C][C]349835.4[/C][C]350089[/C][C]350089[/C][C]349150.68[/C][C]348821[/C][C]349074.6[/C][C]350089[/C][/ROW]
[ROW][C]0.78[/C][C]352876.12[/C][C]358767.2[/C][C]356725[/C][C]356725[/C][C]354336.04[/C][C]350089[/C][C]364893.8[/C][C]356725[/C][/ROW]
[ROW][C]0.79[/C][C]364995.91[/C][C]374867.4[/C][C]366936[/C][C]366936[/C][C]367200.38[/C][C]366936[/C][C]372223.6[/C][C]380155[/C][/ROW]
[ROW][C]0.8[/C][C]380230.2[/C][C]380531[/C][C]380531[/C][C]380531[/C][C]380305.4[/C][C]380155[/C][C]380531[/C][C]380531[/C][/ROW]
[ROW][C]0.81[/C][C]382402.48[/C][C]384897[/C][C]383703[/C][C]383703[/C][C]383005.16[/C][C]383703[/C][C]385494[/C][C]383703[/C][/ROW]
[ROW][C]0.82[/C][C]386628.3[/C][C]398475.2[/C][C]386688[/C][C]386688[/C][C]389045.44[/C][C]386688[/C][C]389634.8[/C][C]401422[/C][/ROW]
[ROW][C]0.83[/C][C]401604.41[/C][C]402144.8[/C][C]401915[/C][C]401915[/C][C]401688.22[/C][C]401422[/C][C]402834.2[/C][C]401915[/C][/ROW]
[ROW][C]0.84[/C][C]402788.24[/C][C]403359.2[/C][C]403064[/C][C]403064[/C][C]402972.08[/C][C]403064[/C][C]403260.8[/C][C]403556[/C][/ROW]
[ROW][C]0.85[/C][C]403947.65[/C][C]406167[/C][C]406167[/C][C]406167[/C][C]404339.3[/C][C]403556[/C][C]406167[/C][C]406167[/C][/ROW]
[ROW][C]0.86[/C][C]414394.44[/C][C]423287[/C][C]421403[/C][C]421403[/C][C]416527.48[/C][C]421403[/C][C]424229[/C][C]421403[/C][/ROW]
[ROW][C]0.87[/C][C]425783.3[/C][C]433987.4[/C][C]426113[/C][C]426113[/C][C]426703.58[/C][C]426113[/C][C]428081.6[/C][C]435956[/C][/ROW]
[ROW][C]0.88[/C][C]436787.68[/C][C]439131.4[/C][C]438555[/C][C]438555[/C][C]437099.56[/C][C]435956[/C][C]440860.6[/C][C]438555[/C][/ROW]
[ROW][C]0.89[/C][C]440601.22[/C][C]446331.2[/C][C]441437[/C][C]441437[/C][C]440918.24[/C][C]441437[/C][C]444699.8[/C][C]449594[/C][/ROW]
[ROW][C]0.9[/C][C]452218[/C][C]475834[/C][C]475834[/C][C]475834[/C][C]454842[/C][C]449594[/C][C]475834[/C][C]475834[/C][/ROW]
[ROW][C]0.91[/C][C]490934.82[/C][C]526502[/C][C]506652[/C][C]506652[/C][C]493708.44[/C][C]475834[/C][C]536427[/C][C]506652[/C][/ROW]
[ROW][C]0.92[/C][C]550322[/C][C]592185[/C][C]556277[/C][C]556277[/C][C]554292[/C][C]556277[/C][C]565254[/C][C]601162[/C][/ROW]
[ROW][C]0.93[/C][C]603894.13[/C][C]618081.8[/C][C]611281[/C][C]611281[/C][C]604602.46[/C][C]601162[/C][C]638484.2[/C][C]611281[/C][/ROW]
[ROW][C]0.94[/C][C]633723.64[/C][C]650298.6[/C][C]645285[/C][C]645285[/C][C]635763.88[/C][C]645285[/C][C]648627.4[/C][C]653641[/C][/ROW]
[ROW][C]0.95[/C][C]654103.1[/C][C]662883[/C][C]662883[/C][C]662883[/C][C]654565.2[/C][C]653641[/C][C]662883[/C][C]662883[/C][/ROW]
[ROW][C]0.96[/C][C]679058.28[/C][C]798704.2[/C][C]699645[/C][C]699645[/C][C]680528.76[/C][C]662883[/C][C]848233.8[/C][C]699645[/C][/ROW]
[ROW][C]0.97[/C][C]905192.84[/C][C]1014213.8[/C][C]947293[/C][C]947293[/C][C]912622.28[/C][C]947293[/C][C]964023.2[/C][C]1030944[/C][/ROW]
[ROW][C]0.98[/C][C]1091439.38[/C][C]1597447.2[/C][C]1305923[/C][C]1305923[/C][C]1096938.96[/C][C]1030944[/C][C]2472019.8[/C][C]1305923[/C][/ROW]
[ROW][C]0.99[/C][C]2195071.81[/C][C]3626834.2[/C][C]2763544[/C][C]2763544[/C][C]2209648.02[/C][C]2763544[/C][C]3339070.8[/C][C]4202361[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=80892&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=80892&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.0127.872828.35857.4757.4768.53188.9538.0628.95
0.0280.175880.75886.5886.58125.317286.5863.29286.58
0.03143.2807144.292171.26171.26180.423137.55164.518137.55
0.04207.912210.53236.71236.71238.3636236.71197.44236.71
0.05239.731239.89239.89239.89251.365239.89239.89239.89
0.06255.0404255.464259.7259.7273.2688252.64256.876252.64
0.07295.0758298.468308.16308.16318.6408308.16269.392308.16
0.08331.7512336.892388.3388.3388.458324.04375.448324.04
0.09390.3145390.67392.25392.25412.4352392.25389.88392.25
0.1435.504440.31440.31440.31643.958440.31440.31440.31
0.11712.7311719.506756.46756.461486.6372694.87731.824694.87
0.123514.90724001.6924813481321157.1648131567.7684813
0.1334211.0334604.8370283702836846.263399936422.233999
0.1437956.7438239.4390473904745626.843702837835.639047
0.1556524.759609596095960961391.9596095960959609
0.1662602.462900640166401664569.84621566327262156
0.1768377.4969554.4709397093971815.37093965400.670939
0.187308975294850948509483134728448264472844
0.1992803.6496376.4103898103898105067.748509492615.6103898
0.2108151.6109215109215109215122773.2109215109215109215
0.21132693.6133668136452136452136359.2131812134596131812
0.22136661.38136740.8136813136813138075.88136813136524.2136813
0.23140215.76142263.6140321140321147508.62140321148091.4140321
0.24152249.08153725.8156187156187156410.2150034152495.2156187
0.25157582158047158047158047163954158047158047158047
0.26170066.38170447.8171328171328171151.96169861170741.2169861
0.27176357.7178920180818180818181433.68180818173226180818
0.28182996.56183271.4183186183186183459.28183186183527.6183186
0.29183931.68184229.8184641184641184705.8183613184024.2184641
0.3186909187881187881187881188791.4187881187881187881
0.31190176.98190245.8190379190379190330.16190157190290.2190157
0.32191077.88191543.8191835191835191988.92190379190670.2191835
0.33192671.94192897.4192797192797193068.08192797193198.6192797
0.34194404195849197549197549197209193299194999197549
0.35198034.55198296198296198296198596.3198296198296198296
0.36199314.96199476.6199746199746199602.32199297199566.4199297
0.37199922.3200074200156200156200331.26199746199828200156
0.38202551.22203338.8203077203077203652.96203077204124.2203077
0.39204886.85205817206771206771206341.7204386205340206771
0.4206844.2206893206893206893207021206893206893206893
0.41207526.6207763207533207533207866.5207533207878207533
0.42209455.86210945.6211655211655211513.12208108208817.4211655
0.43212968.62213391213361213361213412213361213481213361
0.44213576.92213758.2213923213923213807.64213511213675.8213923
0.45215090.65216046216046216046216096.2216046216046216046
0.46216517.88216683.2216548216548216710.24216548216750.8216548
0.47217077.07217349.2217465217465217383.94216886217001.8217465
0.48218398.12219119.4218761218761219191.08218761220194.6218761
0.49220666.85221174221588221588221194.7220553220967221588
0.5222377223166223166223166223166223166223166223166
0.51226338.85227895226731226731227836.8226731228477226731
0.52230425.84231883.4232444232444231771.28229641230201.6232444
0.53232594.75233250.6232669232669233076.12232669234995.4232669
0.54235620.5236012236302236302235954235577235867236302
0.55237292238502238502238502238282236302238502238502
0.56240394.52240921.4240755240755240871.48240755241004.6240755
0.57241408.82241998.2242205242205241853.44241171241377.8242205
0.58242291.18243183.6242344242344242511.92242344245702.4242344
0.59246568.06248105.6249148249148247636.52246542247584.4249148
0.6249651.6250407250407250407250155.2249148250407250407
0.61251208.85253694251422251422252444.4251422254830251422
0.62257185.7257474257567257567257362.4257102257195257567
0.63259319.75260832.8260642260642260457.5260642261405.2260642
0.64261557.84262148.6261596261596261890.72261596261964.4262517
0.65262642.3262875262875262875262767.6262517262875262875
0.66263637.94264654.4263906263906264055.68263906265028.6263906
0.67265909.08266589.8266793266793266244.36265777265980.2266793
0.68270791.28274698274482274482273251.76274482275346274482
0.69275464.8277469.4275562275562276261.38275562276833.6278741
0.7281239.4287069287069287069283737.8278741287069287069
0.71288894.05291296.8289714289714289661.1289714292088.2289714
0.72293799.8294959295281295281294250.6293671293993295281
0.73301340.71308245.6308174308174304821.82295281308460.4308174
0.74308481.88311756.4308532308532309176.88308532310681.6313906
0.75314418.25315955315955315955314930.5313906315955315955
0.76325304.12337866.2330563330563328810.04330563341517.8330563
0.77348859.04349835.4350089350089349150.68348821349074.6350089
0.78352876.12358767.2356725356725354336.04350089364893.8356725
0.79364995.91374867.4366936366936367200.38366936372223.6380155
0.8380230.2380531380531380531380305.4380155380531380531
0.81382402.48384897383703383703383005.16383703385494383703
0.82386628.3398475.2386688386688389045.44386688389634.8401422
0.83401604.41402144.8401915401915401688.22401422402834.2401915
0.84402788.24403359.2403064403064402972.08403064403260.8403556
0.85403947.65406167406167406167404339.3403556406167406167
0.86414394.44423287421403421403416527.48421403424229421403
0.87425783.3433987.4426113426113426703.58426113428081.6435956
0.88436787.68439131.4438555438555437099.56435956440860.6438555
0.89440601.22446331.2441437441437440918.24441437444699.8449594
0.9452218475834475834475834454842449594475834475834
0.91490934.82526502506652506652493708.44475834536427506652
0.92550322592185556277556277554292556277565254601162
0.93603894.13618081.8611281611281604602.46601162638484.2611281
0.94633723.64650298.6645285645285635763.88645285648627.4653641
0.95654103.1662883662883662883654565.2653641662883662883
0.96679058.28798704.2699645699645680528.76662883848233.8699645
0.97905192.841014213.8947293947293912622.28947293964023.21030944
0.981091439.381597447.2130592313059231096938.9610309442472019.81305923
0.992195071.813626834.2276354427635442209648.0227635443339070.84202361



Parameters (Session):
par1 = 15 ; par2 = grey ; par3 = FALSE ; par4 = Unknown ;
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')