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 12:30:04 -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/t1318869035697nf8rwlb2hb42.htm/, Retrieved Wed, 15 May 2024 05:37:11 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=130662, Retrieved Wed, 15 May 2024 05:37:11 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact52
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] [Workshop 3, task ...] [2011-10-17 16:30:04] [79818163420d1233b8d9d93d595e6c9e] [Current]
Feedback Forum

Post a new message
Dataseries X:
23
27
23
21
26
23
21
27
19
23
25
23
22
22
25
25
28
28
20
25
19
25
22
18
20




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=130662&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=130662&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=130662&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.0518.2518.31919191818.718
0.11919191919.4191919
0.1519.7519.92020202019.120
0.22020.22020.520.82020.820
0.252121212121212121
0.321.521.82222222221.222
0.352222222222222222
0.42222.42222.522.62222.622
0.452323232323232323
0.52323232323232323
0.552323232323232323
0.62324.2232423.82323.825
0.652525252525252525
0.72525252525252525
0.752525252525252525
0.82525.82525.525.22525.226
0.8526.2527272726.4262727
0.92727.42727272727.627
0.9527.7528282827.8282828

\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 & 18.25 & 18.3 & 19 & 19 & 19 & 18 & 18.7 & 18 \tabularnewline
0.1 & 19 & 19 & 19 & 19 & 19.4 & 19 & 19 & 19 \tabularnewline
0.15 & 19.75 & 19.9 & 20 & 20 & 20 & 20 & 19.1 & 20 \tabularnewline
0.2 & 20 & 20.2 & 20 & 20.5 & 20.8 & 20 & 20.8 & 20 \tabularnewline
0.25 & 21 & 21 & 21 & 21 & 21 & 21 & 21 & 21 \tabularnewline
0.3 & 21.5 & 21.8 & 22 & 22 & 22 & 22 & 21.2 & 22 \tabularnewline
0.35 & 22 & 22 & 22 & 22 & 22 & 22 & 22 & 22 \tabularnewline
0.4 & 22 & 22.4 & 22 & 22.5 & 22.6 & 22 & 22.6 & 22 \tabularnewline
0.45 & 23 & 23 & 23 & 23 & 23 & 23 & 23 & 23 \tabularnewline
0.5 & 23 & 23 & 23 & 23 & 23 & 23 & 23 & 23 \tabularnewline
0.55 & 23 & 23 & 23 & 23 & 23 & 23 & 23 & 23 \tabularnewline
0.6 & 23 & 24.2 & 23 & 24 & 23.8 & 23 & 23.8 & 25 \tabularnewline
0.65 & 25 & 25 & 25 & 25 & 25 & 25 & 25 & 25 \tabularnewline
0.7 & 25 & 25 & 25 & 25 & 25 & 25 & 25 & 25 \tabularnewline
0.75 & 25 & 25 & 25 & 25 & 25 & 25 & 25 & 25 \tabularnewline
0.8 & 25 & 25.8 & 25 & 25.5 & 25.2 & 25 & 25.2 & 26 \tabularnewline
0.85 & 26.25 & 27 & 27 & 27 & 26.4 & 26 & 27 & 27 \tabularnewline
0.9 & 27 & 27.4 & 27 & 27 & 27 & 27 & 27.6 & 27 \tabularnewline
0.95 & 27.75 & 28 & 28 & 28 & 27.8 & 28 & 28 & 28 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=130662&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]18.25[/C][C]18.3[/C][C]19[/C][C]19[/C][C]19[/C][C]18[/C][C]18.7[/C][C]18[/C][/ROW]
[ROW][C]0.1[/C][C]19[/C][C]19[/C][C]19[/C][C]19[/C][C]19.4[/C][C]19[/C][C]19[/C][C]19[/C][/ROW]
[ROW][C]0.15[/C][C]19.75[/C][C]19.9[/C][C]20[/C][C]20[/C][C]20[/C][C]20[/C][C]19.1[/C][C]20[/C][/ROW]
[ROW][C]0.2[/C][C]20[/C][C]20.2[/C][C]20[/C][C]20.5[/C][C]20.8[/C][C]20[/C][C]20.8[/C][C]20[/C][/ROW]
[ROW][C]0.25[/C][C]21[/C][C]21[/C][C]21[/C][C]21[/C][C]21[/C][C]21[/C][C]21[/C][C]21[/C][/ROW]
[ROW][C]0.3[/C][C]21.5[/C][C]21.8[/C][C]22[/C][C]22[/C][C]22[/C][C]22[/C][C]21.2[/C][C]22[/C][/ROW]
[ROW][C]0.35[/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.4[/C][C]22[/C][C]22.4[/C][C]22[/C][C]22.5[/C][C]22.6[/C][C]22[/C][C]22.6[/C][C]22[/C][/ROW]
[ROW][C]0.45[/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.5[/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.55[/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.6[/C][C]23[/C][C]24.2[/C][C]23[/C][C]24[/C][C]23.8[/C][C]23[/C][C]23.8[/C][C]25[/C][/ROW]
[ROW][C]0.65[/C][C]25[/C][C]25[/C][C]25[/C][C]25[/C][C]25[/C][C]25[/C][C]25[/C][C]25[/C][/ROW]
[ROW][C]0.7[/C][C]25[/C][C]25[/C][C]25[/C][C]25[/C][C]25[/C][C]25[/C][C]25[/C][C]25[/C][/ROW]
[ROW][C]0.75[/C][C]25[/C][C]25[/C][C]25[/C][C]25[/C][C]25[/C][C]25[/C][C]25[/C][C]25[/C][/ROW]
[ROW][C]0.8[/C][C]25[/C][C]25.8[/C][C]25[/C][C]25.5[/C][C]25.2[/C][C]25[/C][C]25.2[/C][C]26[/C][/ROW]
[ROW][C]0.85[/C][C]26.25[/C][C]27[/C][C]27[/C][C]27[/C][C]26.4[/C][C]26[/C][C]27[/C][C]27[/C][/ROW]
[ROW][C]0.9[/C][C]27[/C][C]27.4[/C][C]27[/C][C]27[/C][C]27[/C][C]27[/C][C]27.6[/C][C]27[/C][/ROW]
[ROW][C]0.95[/C][C]27.75[/C][C]28[/C][C]28[/C][C]28[/C][C]27.8[/C][C]28[/C][C]28[/C][C]28[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=130662&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=130662&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.0518.2518.31919191818.718
0.11919191919.4191919
0.1519.7519.92020202019.120
0.22020.22020.520.82020.820
0.252121212121212121
0.321.521.82222222221.222
0.352222222222222222
0.42222.42222.522.62222.622
0.452323232323232323
0.52323232323232323
0.552323232323232323
0.62324.2232423.82323.825
0.652525252525252525
0.72525252525252525
0.752525252525252525
0.82525.82525.525.22525.226
0.8526.2527272726.4262727
0.92727.42727272727.627
0.9527.7528282827.8282828



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')