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:59:24 -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/t1318877972hngcuk2hb8gc5gp.htm/, Retrieved Wed, 15 May 2024 17:04:25 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=131018, Retrieved Wed, 15 May 2024 17:04:25 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact76
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:59:24] [2e63149daec6ba44c7d6fab36a0b0c34] [Current]
Feedback Forum

Post a new message
Dataseries X:
23
20
20
21
24
22
23
20
25
23
27
27
22
24
25
22
28
28
27
25
16
28
21
24
27
14
14
27
20
21
22
10




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

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=131018&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 time0 seconds
R Server'Herman Ole Andreas Wold' @ wold.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.0512.412.61414141411.414
0.114.414.6161616.41415.414
0.1519.219.82020202016.220
0.22020202020202020
0.252020.252020.520.752020.7520
0.32121212121212121
0.3521.221.55222221.852121.4522
0.42222222222222222
0.452222222222222222
0.52323232323232323
0.552323.15232323.052323.8523
0.62424242424242424
0.652424.45242424.152424.5524
0.72525252525252525
0.752526.5252625.52525.527
0.82727272727272727
0.852727272727272727
0.92727.72727272727.328
0.952828282828282828

\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 & 12.4 & 12.6 & 14 & 14 & 14 & 14 & 11.4 & 14 \tabularnewline
0.1 & 14.4 & 14.6 & 16 & 16 & 16.4 & 14 & 15.4 & 14 \tabularnewline
0.15 & 19.2 & 19.8 & 20 & 20 & 20 & 20 & 16.2 & 20 \tabularnewline
0.2 & 20 & 20 & 20 & 20 & 20 & 20 & 20 & 20 \tabularnewline
0.25 & 20 & 20.25 & 20 & 20.5 & 20.75 & 20 & 20.75 & 20 \tabularnewline
0.3 & 21 & 21 & 21 & 21 & 21 & 21 & 21 & 21 \tabularnewline
0.35 & 21.2 & 21.55 & 22 & 22 & 21.85 & 21 & 21.45 & 22 \tabularnewline
0.4 & 22 & 22 & 22 & 22 & 22 & 22 & 22 & 22 \tabularnewline
0.45 & 22 & 22 & 22 & 22 & 22 & 22 & 22 & 22 \tabularnewline
0.5 & 23 & 23 & 23 & 23 & 23 & 23 & 23 & 23 \tabularnewline
0.55 & 23 & 23.15 & 23 & 23 & 23.05 & 23 & 23.85 & 23 \tabularnewline
0.6 & 24 & 24 & 24 & 24 & 24 & 24 & 24 & 24 \tabularnewline
0.65 & 24 & 24.45 & 24 & 24 & 24.15 & 24 & 24.55 & 24 \tabularnewline
0.7 & 25 & 25 & 25 & 25 & 25 & 25 & 25 & 25 \tabularnewline
0.75 & 25 & 26.5 & 25 & 26 & 25.5 & 25 & 25.5 & 27 \tabularnewline
0.8 & 27 & 27 & 27 & 27 & 27 & 27 & 27 & 27 \tabularnewline
0.85 & 27 & 27 & 27 & 27 & 27 & 27 & 27 & 27 \tabularnewline
0.9 & 27 & 27.7 & 27 & 27 & 27 & 27 & 27.3 & 28 \tabularnewline
0.95 & 28 & 28 & 28 & 28 & 28 & 28 & 28 & 28 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=131018&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]12.4[/C][C]12.6[/C][C]14[/C][C]14[/C][C]14[/C][C]14[/C][C]11.4[/C][C]14[/C][/ROW]
[ROW][C]0.1[/C][C]14.4[/C][C]14.6[/C][C]16[/C][C]16[/C][C]16.4[/C][C]14[/C][C]15.4[/C][C]14[/C][/ROW]
[ROW][C]0.15[/C][C]19.2[/C][C]19.8[/C][C]20[/C][C]20[/C][C]20[/C][C]20[/C][C]16.2[/C][C]20[/C][/ROW]
[ROW][C]0.2[/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.25[/C][C]20[/C][C]20.25[/C][C]20[/C][C]20.5[/C][C]20.75[/C][C]20[/C][C]20.75[/C][C]20[/C][/ROW]
[ROW][C]0.3[/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.35[/C][C]21.2[/C][C]21.55[/C][C]22[/C][C]22[/C][C]21.85[/C][C]21[/C][C]21.45[/C][C]22[/C][/ROW]
[ROW][C]0.4[/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.45[/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.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.15[/C][C]23[/C][C]23[/C][C]23.05[/C][C]23[/C][C]23.85[/C][C]23[/C][/ROW]
[ROW][C]0.6[/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.65[/C][C]24[/C][C]24.45[/C][C]24[/C][C]24[/C][C]24.15[/C][C]24[/C][C]24.55[/C][C]24[/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]26.5[/C][C]25[/C][C]26[/C][C]25.5[/C][C]25[/C][C]25.5[/C][C]27[/C][/ROW]
[ROW][C]0.8[/C][C]27[/C][C]27[/C][C]27[/C][C]27[/C][C]27[/C][C]27[/C][C]27[/C][C]27[/C][/ROW]
[ROW][C]0.85[/C][C]27[/C][C]27[/C][C]27[/C][C]27[/C][C]27[/C][C]27[/C][C]27[/C][C]27[/C][/ROW]
[ROW][C]0.9[/C][C]27[/C][C]27.7[/C][C]27[/C][C]27[/C][C]27[/C][C]27[/C][C]27.3[/C][C]28[/C][/ROW]
[ROW][C]0.95[/C][C]28[/C][C]28[/C][C]28[/C][C]28[/C][C]28[/C][C]28[/C][C]28[/C][C]28[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=131018&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=131018&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.0512.412.61414141411.414
0.114.414.6161616.41415.414
0.1519.219.82020202016.220
0.22020202020202020
0.252020.252020.520.752020.7520
0.32121212121212121
0.3521.221.55222221.852121.4522
0.42222222222222222
0.452222222222222222
0.52323232323232323
0.552323.15232323.052323.8523
0.62424242424242424
0.652424.45242424.152424.5524
0.72525252525252525
0.752526.5252625.52525.527
0.82727272727272727
0.852727272727272727
0.92727.72727272727.328
0.952828282828282828



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