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 computationWed, 15 Oct 2014 17:36:26 +0100
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2014/Oct/15/t1413391000aykt3a14pid6jwb.htm/, Retrieved Tue, 14 May 2024 03:44:57 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=241853, Retrieved Tue, 14 May 2024 03:44:57 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact77
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  D  [Percentiles] [] [2011-10-18 22:34:54] [b98453cac15ba1066b407e146608df68]
- RMPD      [Percentiles] [q-q] [2014-10-15 16:36:26] [c74d77b31b20c44b46a6349cc3b2e683] [Current]
Feedback Forum

Post a new message
Dataseries X:
28	
20
23	
13	
18
23
19	
23
12
16
23
13	
22	
18
23
20	
10	
17	
18	
15
23	
17	
17
22
20
20
19	
18	
22	
20
22
18
16	
16	
16	
16	
17
18	




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

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=241853&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'Gertrude Mary Cox' @ cox.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.0511.811.9121212.851210.112
0.11313131314.4131313
0.1515.715.851616161615.1516
0.21616161616161616
0.251616161616.25161616
0.31717171717171717
0.351717171717171717
0.41818181818181818
0.451818181818181818
0.51818181818181818
0.5518.919191919191919
0.619.820202020202020
0.652020202020202020
0.72020.62020202021.420
0.752222222222222222
0.82222.22222222222.822
0.852323232323232323
0.92323232323232323
0.952323.252323232327.7523

\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 & 11.8 & 11.9 & 12 & 12 & 12.85 & 12 & 10.1 & 12 \tabularnewline
0.1 & 13 & 13 & 13 & 13 & 14.4 & 13 & 13 & 13 \tabularnewline
0.15 & 15.7 & 15.85 & 16 & 16 & 16 & 16 & 15.15 & 16 \tabularnewline
0.2 & 16 & 16 & 16 & 16 & 16 & 16 & 16 & 16 \tabularnewline
0.25 & 16 & 16 & 16 & 16 & 16.25 & 16 & 16 & 16 \tabularnewline
0.3 & 17 & 17 & 17 & 17 & 17 & 17 & 17 & 17 \tabularnewline
0.35 & 17 & 17 & 17 & 17 & 17 & 17 & 17 & 17 \tabularnewline
0.4 & 18 & 18 & 18 & 18 & 18 & 18 & 18 & 18 \tabularnewline
0.45 & 18 & 18 & 18 & 18 & 18 & 18 & 18 & 18 \tabularnewline
0.5 & 18 & 18 & 18 & 18 & 18 & 18 & 18 & 18 \tabularnewline
0.55 & 18.9 & 19 & 19 & 19 & 19 & 19 & 19 & 19 \tabularnewline
0.6 & 19.8 & 20 & 20 & 20 & 20 & 20 & 20 & 20 \tabularnewline
0.65 & 20 & 20 & 20 & 20 & 20 & 20 & 20 & 20 \tabularnewline
0.7 & 20 & 20.6 & 20 & 20 & 20 & 20 & 21.4 & 20 \tabularnewline
0.75 & 22 & 22 & 22 & 22 & 22 & 22 & 22 & 22 \tabularnewline
0.8 & 22 & 22.2 & 22 & 22 & 22 & 22 & 22.8 & 22 \tabularnewline
0.85 & 23 & 23 & 23 & 23 & 23 & 23 & 23 & 23 \tabularnewline
0.9 & 23 & 23 & 23 & 23 & 23 & 23 & 23 & 23 \tabularnewline
0.95 & 23 & 23.25 & 23 & 23 & 23 & 23 & 27.75 & 23 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=241853&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]11.8[/C][C]11.9[/C][C]12[/C][C]12[/C][C]12.85[/C][C]12[/C][C]10.1[/C][C]12[/C][/ROW]
[ROW][C]0.1[/C][C]13[/C][C]13[/C][C]13[/C][C]13[/C][C]14.4[/C][C]13[/C][C]13[/C][C]13[/C][/ROW]
[ROW][C]0.15[/C][C]15.7[/C][C]15.85[/C][C]16[/C][C]16[/C][C]16[/C][C]16[/C][C]15.15[/C][C]16[/C][/ROW]
[ROW][C]0.2[/C][C]16[/C][C]16[/C][C]16[/C][C]16[/C][C]16[/C][C]16[/C][C]16[/C][C]16[/C][/ROW]
[ROW][C]0.25[/C][C]16[/C][C]16[/C][C]16[/C][C]16[/C][C]16.25[/C][C]16[/C][C]16[/C][C]16[/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[/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.4[/C][C]18[/C][C]18[/C][C]18[/C][C]18[/C][C]18[/C][C]18[/C][C]18[/C][C]18[/C][/ROW]
[ROW][C]0.45[/C][C]18[/C][C]18[/C][C]18[/C][C]18[/C][C]18[/C][C]18[/C][C]18[/C][C]18[/C][/ROW]
[ROW][C]0.5[/C][C]18[/C][C]18[/C][C]18[/C][C]18[/C][C]18[/C][C]18[/C][C]18[/C][C]18[/C][/ROW]
[ROW][C]0.55[/C][C]18.9[/C][C]19[/C][C]19[/C][C]19[/C][C]19[/C][C]19[/C][C]19[/C][C]19[/C][/ROW]
[ROW][C]0.6[/C][C]19.8[/C][C]20[/C][C]20[/C][C]20[/C][C]20[/C][C]20[/C][C]20[/C][C]20[/C][/ROW]
[ROW][C]0.65[/C][C]20[/C][C]20[/C][C]20[/C][C]20[/C][C]20[/C][C]20[/C][C]20[/C][C]20[/C][/ROW]
[ROW][C]0.7[/C][C]20[/C][C]20.6[/C][C]20[/C][C]20[/C][C]20[/C][C]20[/C][C]21.4[/C][C]20[/C][/ROW]
[ROW][C]0.75[/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.8[/C][C]22[/C][C]22.2[/C][C]22[/C][C]22[/C][C]22[/C][C]22[/C][C]22.8[/C][C]22[/C][/ROW]
[ROW][C]0.85[/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.9[/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.95[/C][C]23[/C][C]23.25[/C][C]23[/C][C]23[/C][C]23[/C][C]23[/C][C]27.75[/C][C]23[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=241853&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=241853&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.0511.811.9121212.851210.112
0.11313131314.4131313
0.1515.715.851616161615.1516
0.21616161616161616
0.251616161616.25161616
0.31717171717171717
0.351717171717171717
0.41818181818181818
0.451818181818181818
0.51818181818181818
0.5518.919191919191919
0.619.820202020202020
0.652020202020202020
0.72020.62020202021.420
0.752222222222222222
0.82222.22222222222.822
0.852323232323232323
0.92323232323232323
0.952323.252323232327.7523



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