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, 17 Oct 2011 14:58:28 -0400
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2011/Oct/17/t1318877915yyok3no44gul440.htm/, Retrieved Wed, 15 May 2024 15:35:54 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=131014, Retrieved Wed, 15 May 2024 15:35:54 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact66
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Percentiles] [Intrinsic Motivat...] [2010-10-12 12:10:58] [b98453cac15ba1066b407e146608df68]
- R PD  [Percentiles] [] [2011-10-17 18:57:51] [0fa8c500575976cf9d2f7efbe256ddfb]
-    D      [Percentiles] [] [2011-10-17 18:58:28] [2e63149daec6ba44c7d6fab36a0b0c34] [Current]
Feedback Forum

Post a new message
Dataseries X:
17
17
18
21
20
28
19
22
16
18
25
17
14
11
27
20
22
22
21
23
17
24
14
17
23
24
24
8
22
23
25
5




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time1 seconds
R Server'AstonUniversity' @ aston.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 & 1 seconds \tabularnewline
R Server & 'AstonUniversity' @ aston.wessa.net \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=131014&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]1 seconds[/C][/ROW]
[ROW][C]R Server[/C][C]'AstonUniversity' @ aston.wessa.net[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=131014&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=131014&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 time1 seconds
R Server'AstonUniversity' @ aston.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.056.86.95889.6586.058
0.111.611.91414141113.111
0.151414141415.3141414
0.216.416.61717171616.417
0.251717171717171717
0.31717171717171717
0.3517.217.55181817.851717.4518
0.41818.2181818.41818.818
0.4519.419.85202019.951919.1520
0.52020.52020.520.52020.520.5
0.552121.15212121.052121.8521
0.62222222222222222
0.652222222222222222
0.722.423232322.7222323
0.752323232323232323
0.823.624242423.8242424
0.852424.052424242424.9524
0.924.825252524.9252525
0.9525.827.35272725.92527.6527

\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.05 & 6.8 & 6.95 & 8 & 8 & 9.65 & 8 & 6.05 & 8 \tabularnewline
0.1 & 11.6 & 11.9 & 14 & 14 & 14 & 11 & 13.1 & 11 \tabularnewline
0.15 & 14 & 14 & 14 & 14 & 15.3 & 14 & 14 & 14 \tabularnewline
0.2 & 16.4 & 16.6 & 17 & 17 & 17 & 16 & 16.4 & 17 \tabularnewline
0.25 & 17 & 17 & 17 & 17 & 17 & 17 & 17 & 17 \tabularnewline
0.3 & 17 & 17 & 17 & 17 & 17 & 17 & 17 & 17 \tabularnewline
0.35 & 17.2 & 17.55 & 18 & 18 & 17.85 & 17 & 17.45 & 18 \tabularnewline
0.4 & 18 & 18.2 & 18 & 18 & 18.4 & 18 & 18.8 & 18 \tabularnewline
0.45 & 19.4 & 19.85 & 20 & 20 & 19.95 & 19 & 19.15 & 20 \tabularnewline
0.5 & 20 & 20.5 & 20 & 20.5 & 20.5 & 20 & 20.5 & 20.5 \tabularnewline
0.55 & 21 & 21.15 & 21 & 21 & 21.05 & 21 & 21.85 & 21 \tabularnewline
0.6 & 22 & 22 & 22 & 22 & 22 & 22 & 22 & 22 \tabularnewline
0.65 & 22 & 22 & 22 & 22 & 22 & 22 & 22 & 22 \tabularnewline
0.7 & 22.4 & 23 & 23 & 23 & 22.7 & 22 & 23 & 23 \tabularnewline
0.75 & 23 & 23 & 23 & 23 & 23 & 23 & 23 & 23 \tabularnewline
0.8 & 23.6 & 24 & 24 & 24 & 23.8 & 24 & 24 & 24 \tabularnewline
0.85 & 24 & 24.05 & 24 & 24 & 24 & 24 & 24.95 & 24 \tabularnewline
0.9 & 24.8 & 25 & 25 & 25 & 24.9 & 25 & 25 & 25 \tabularnewline
0.95 & 25.8 & 27.35 & 27 & 27 & 25.9 & 25 & 27.65 & 27 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=131014&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.05[/C][C]6.8[/C][C]6.95[/C][C]8[/C][C]8[/C][C]9.65[/C][C]8[/C][C]6.05[/C][C]8[/C][/ROW]
[ROW][C]0.1[/C][C]11.6[/C][C]11.9[/C][C]14[/C][C]14[/C][C]14[/C][C]11[/C][C]13.1[/C][C]11[/C][/ROW]
[ROW][C]0.15[/C][C]14[/C][C]14[/C][C]14[/C][C]14[/C][C]15.3[/C][C]14[/C][C]14[/C][C]14[/C][/ROW]
[ROW][C]0.2[/C][C]16.4[/C][C]16.6[/C][C]17[/C][C]17[/C][C]17[/C][C]16[/C][C]16.4[/C][C]17[/C][/ROW]
[ROW][C]0.25[/C][C]17[/C][C]17[/C][C]17[/C][C]17[/C][C]17[/C][C]17[/C][C]17[/C][C]17[/C][/ROW]
[ROW][C]0.3[/C][C]17[/C][C]17[/C][C]17[/C][C]17[/C][C]17[/C][C]17[/C][C]17[/C][C]17[/C][/ROW]
[ROW][C]0.35[/C][C]17.2[/C][C]17.55[/C][C]18[/C][C]18[/C][C]17.85[/C][C]17[/C][C]17.45[/C][C]18[/C][/ROW]
[ROW][C]0.4[/C][C]18[/C][C]18.2[/C][C]18[/C][C]18[/C][C]18.4[/C][C]18[/C][C]18.8[/C][C]18[/C][/ROW]
[ROW][C]0.45[/C][C]19.4[/C][C]19.85[/C][C]20[/C][C]20[/C][C]19.95[/C][C]19[/C][C]19.15[/C][C]20[/C][/ROW]
[ROW][C]0.5[/C][C]20[/C][C]20.5[/C][C]20[/C][C]20.5[/C][C]20.5[/C][C]20[/C][C]20.5[/C][C]20.5[/C][/ROW]
[ROW][C]0.55[/C][C]21[/C][C]21.15[/C][C]21[/C][C]21[/C][C]21.05[/C][C]21[/C][C]21.85[/C][C]21[/C][/ROW]
[ROW][C]0.6[/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.65[/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.7[/C][C]22.4[/C][C]23[/C][C]23[/C][C]23[/C][C]22.7[/C][C]22[/C][C]23[/C][C]23[/C][/ROW]
[ROW][C]0.75[/C][C]23[/C][C]23[/C][C]23[/C][C]23[/C][C]23[/C][C]23[/C][C]23[/C][C]23[/C][/ROW]
[ROW][C]0.8[/C][C]23.6[/C][C]24[/C][C]24[/C][C]24[/C][C]23.8[/C][C]24[/C][C]24[/C][C]24[/C][/ROW]
[ROW][C]0.85[/C][C]24[/C][C]24.05[/C][C]24[/C][C]24[/C][C]24[/C][C]24[/C][C]24.95[/C][C]24[/C][/ROW]
[ROW][C]0.9[/C][C]24.8[/C][C]25[/C][C]25[/C][C]25[/C][C]24.9[/C][C]25[/C][C]25[/C][C]25[/C][/ROW]
[ROW][C]0.95[/C][C]25.8[/C][C]27.35[/C][C]27[/C][C]27[/C][C]25.9[/C][C]25[/C][C]27.65[/C][C]27[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=131014&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=131014&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.056.86.95889.6586.058
0.111.611.91414141113.111
0.151414141415.3141414
0.216.416.61717171616.417
0.251717171717171717
0.31717171717171717
0.3517.217.55181817.851717.4518
0.41818.2181818.41818.818
0.4519.419.85202019.951919.1520
0.52020.52020.520.52020.520.5
0.552121.15212121.052121.8521
0.62222222222222222
0.652222222222222222
0.722.423232322.7222323
0.752323232323232323
0.823.624242423.8242424
0.852424.052424242424.9524
0.924.825252524.9252525
0.9525.827.35272725.92527.6527



Parameters (Session):
par1 = 8 ; par2 = 0 ;
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')