Free Statistics

of Irreproducible Research!

Author's title

Author*The author of this computation has been verified*
R Software Modulerwasp_centraltendency.wasp
Title produced by softwareCentral Tendency
Date of computationSat, 17 Oct 2009 03:38:10 -0600
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2009/Oct/17/t1255772320u9grctnwsxyo3uv.htm/, Retrieved Mon, 06 May 2024 08:10:28 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=47088, Retrieved Mon, 06 May 2024 08:10:28 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact163
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Bivariate Data Series] [Bivariate dataset] [2008-01-05 23:51:08] [74be16979710d4c4e7c6647856088456]
F RMPD  [Univariate Explorative Data Analysis] [Colombia Coffee] [2008-01-07 14:21:11] [74be16979710d4c4e7c6647856088456]
F RMPD    [Univariate Data Series] [] [2009-10-14 08:30:28] [74be16979710d4c4e7c6647856088456]
-   PD      [Univariate Data Series] [WS 3Yt] [2009-10-17 09:25:12] [6e4e01d7eb22a9f33d58ebb35753a195]
-   PD        [Univariate Data Series] [WS3 YT-XT] [2009-10-17 09:36:45] [6e4e01d7eb22a9f33d58ebb35753a195]
- RMPD            [Central Tendency] [Yt-Xt CT] [2009-10-17 09:38:10] [2e4ef2c1b76db9b31c0a03b96e94ad77] [Current]
Feedback Forum

Post a new message
Dataseries X:
3.33
5.14
8.56
10.67
11.68
14.91
17.51
19.42
21.35
23.43
22.50
22.51
21.41
20.54
18.35
18.55
18.53
15.95
15.15
16.96
16.64
16.69
14.38
13.93
10.03
6.72
5.62
7.09
5.42
5.54
5.34
4.34
2.95
-2.93
-5.06
-7.73
-15.43
-21.24
-23.46
-21.71
-17.27
-17.77
-21.17
-21.37
-22.06
-24.96
-28.66
-27.52
-38.00
-40.73
-44.50
-42.33
-35.15
-32.69
-33.59
-39.36
-41.71
-42.42
-44.97
-51.41




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time2 seconds
R Server'Gwilym Jenkins' @ 72.249.127.135

\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 & 'Gwilym Jenkins' @ 72.249.127.135 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=47088&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]'Gwilym Jenkins' @ 72.249.127.135[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=47088&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=47088&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'Gwilym Jenkins' @ 72.249.127.135







Central Tendency - Ungrouped Data
MeasureValueS.E.Value/S.E.
Arithmetic Mean-5.4012.98697209552333-1.80818562319168
Geometric MeanNaN
Harmonic Mean29.8971181428719
Quadratic Mean23.5705098940746
Winsorized Mean ( 1 / 20 )-5.3092.95828126826150-1.79462313369545
Winsorized Mean ( 2 / 20 )-5.293666666666672.95468639503958-1.79161709870592
Winsorized Mean ( 3 / 20 )-5.244166666666672.92322371862533-1.79396692536854
Winsorized Mean ( 4 / 20 )-5.242166666666672.92131387408844-1.79445512964690
Winsorized Mean ( 5 / 20 )-5.2582.89995475125424-1.81313173859899
Winsorized Mean ( 6 / 20 )-5.2722.86259469830775-1.84168579754465
Winsorized Mean ( 7 / 20 )-5.213666666666672.81469844614828-1.85230026108168
Winsorized Mean ( 8 / 20 )-5.0352.77743138763037-1.81282606023104
Winsorized Mean ( 9 / 20 )-4.63452.68939735993113-1.72324851249154
Winsorized Mean ( 10 / 20 )-4.51452.61981921816672-1.72321050578411
Winsorized Mean ( 11 / 20 )-4.450333333333332.57467137902707-1.72850538114695
Winsorized Mean ( 12 / 20 )-3.698333333333332.42154743641691-1.52726032854663
Winsorized Mean ( 13 / 20 )-3.462166666666672.37723369942378-1.45638464889079
Winsorized Mean ( 14 / 20 )-3.025833333333332.25365635482229-1.34263297368242
Winsorized Mean ( 15 / 20 )-2.850833333333332.16407481166656-1.31734509267630
Winsorized Mean ( 16 / 20 )-2.54152.09543500095334-1.21287465315971
Winsorized Mean ( 17 / 20 )-2.59252.05871146998958-1.25928282704575
Winsorized Mean ( 18 / 20 )-2.62552.02388734061808-1.29725600200562
Winsorized Mean ( 19 / 20 )-3.296833333333331.92086660191541-1.71632602183091
Winsorized Mean ( 20 / 20 )-3.610166666666671.87316337908014-1.92731008249773
Trimmed Mean ( 1 / 20 )-5.10482758620692.94282818112997-1.73466722214369
Trimmed Mean ( 2 / 20 )-4.886071428571432.92083065794215-1.67283625816701
Trimmed Mean ( 3 / 20 )-4.659629629629632.89305212386539-1.61062761060936
Trimmed Mean ( 4 / 20 )-4.434807692307692.8701227039318-1.54516309920563
Trimmed Mean ( 5 / 20 )-4.19262.83867542853554-1.47695645576604
Trimmed Mean ( 6 / 20 )-3.926252.80257840415503-1.40094207326333
Trimmed Mean ( 7 / 20 )-3.633695652173912.76417113501355-1.31456971174692
Trimmed Mean ( 8 / 20 )-3.325909090909092.72443679456653-1.22076940729259
Trimmed Mean ( 9 / 20 )-3.020714285714292.67907865038822-1.12751982300951
Trimmed Mean ( 10 / 20 )-2.751752.63940773483468-1.04256343712365
Trimmed Mean ( 11 / 20 )-2.473421052631582.59981647443741-0.95138294450835
Trimmed Mean ( 12 / 20 )-2.173888888888892.55251025767190-0.851667052994197
Trimmed Mean ( 13 / 20 )-1.949705882352942.5244296044925-0.772335215402016
Trimmed Mean ( 14 / 20 )-1.73156252.48975315808223-0.69547557129469
Trimmed Mean ( 15 / 20 )-1.546666666666672.46726994797257-0.626873710328133
Trimmed Mean ( 16 / 20 )-1.360357142857142.44951984724525-0.555356652605617
Trimmed Mean ( 17 / 20 )-1.192.43125709807151-0.489458725259422
Trimmed Mean ( 18 / 20 )-0.983752.39929071739087-0.410017007472021
Trimmed Mean ( 19 / 20 )-0.7352.34394335566060-0.313574130631179
Trimmed Mean ( 20 / 20 )-0.33052.27133214737172-0.145509321647404
Median4.74
Midrange-13.99
Midmean - Weighted Average at Xnp-2.30193548387097
Midmean - Weighted Average at X(n+1)p-1.54666666666667
Midmean - Empirical Distribution Function-2.30193548387097
Midmean - Empirical Distribution Function - Averaging-1.54666666666667
Midmean - Empirical Distribution Function - Interpolation-1.54666666666667
Midmean - Closest Observation-2.30193548387097
Midmean - True Basic - Statistics Graphics Toolkit-1.54666666666667
Midmean - MS Excel (old versions)-1.73156250000000
Number of observations60

\begin{tabular}{lllllllll}
\hline
Central Tendency - Ungrouped Data \tabularnewline
Measure & Value & S.E. & Value/S.E. \tabularnewline
Arithmetic Mean & -5.401 & 2.98697209552333 & -1.80818562319168 \tabularnewline
Geometric Mean & NaN &  &  \tabularnewline
Harmonic Mean & 29.8971181428719 &  &  \tabularnewline
Quadratic Mean & 23.5705098940746 &  &  \tabularnewline
Winsorized Mean ( 1 / 20 ) & -5.309 & 2.95828126826150 & -1.79462313369545 \tabularnewline
Winsorized Mean ( 2 / 20 ) & -5.29366666666667 & 2.95468639503958 & -1.79161709870592 \tabularnewline
Winsorized Mean ( 3 / 20 ) & -5.24416666666667 & 2.92322371862533 & -1.79396692536854 \tabularnewline
Winsorized Mean ( 4 / 20 ) & -5.24216666666667 & 2.92131387408844 & -1.79445512964690 \tabularnewline
Winsorized Mean ( 5 / 20 ) & -5.258 & 2.89995475125424 & -1.81313173859899 \tabularnewline
Winsorized Mean ( 6 / 20 ) & -5.272 & 2.86259469830775 & -1.84168579754465 \tabularnewline
Winsorized Mean ( 7 / 20 ) & -5.21366666666667 & 2.81469844614828 & -1.85230026108168 \tabularnewline
Winsorized Mean ( 8 / 20 ) & -5.035 & 2.77743138763037 & -1.81282606023104 \tabularnewline
Winsorized Mean ( 9 / 20 ) & -4.6345 & 2.68939735993113 & -1.72324851249154 \tabularnewline
Winsorized Mean ( 10 / 20 ) & -4.5145 & 2.61981921816672 & -1.72321050578411 \tabularnewline
Winsorized Mean ( 11 / 20 ) & -4.45033333333333 & 2.57467137902707 & -1.72850538114695 \tabularnewline
Winsorized Mean ( 12 / 20 ) & -3.69833333333333 & 2.42154743641691 & -1.52726032854663 \tabularnewline
Winsorized Mean ( 13 / 20 ) & -3.46216666666667 & 2.37723369942378 & -1.45638464889079 \tabularnewline
Winsorized Mean ( 14 / 20 ) & -3.02583333333333 & 2.25365635482229 & -1.34263297368242 \tabularnewline
Winsorized Mean ( 15 / 20 ) & -2.85083333333333 & 2.16407481166656 & -1.31734509267630 \tabularnewline
Winsorized Mean ( 16 / 20 ) & -2.5415 & 2.09543500095334 & -1.21287465315971 \tabularnewline
Winsorized Mean ( 17 / 20 ) & -2.5925 & 2.05871146998958 & -1.25928282704575 \tabularnewline
Winsorized Mean ( 18 / 20 ) & -2.6255 & 2.02388734061808 & -1.29725600200562 \tabularnewline
Winsorized Mean ( 19 / 20 ) & -3.29683333333333 & 1.92086660191541 & -1.71632602183091 \tabularnewline
Winsorized Mean ( 20 / 20 ) & -3.61016666666667 & 1.87316337908014 & -1.92731008249773 \tabularnewline
Trimmed Mean ( 1 / 20 ) & -5.1048275862069 & 2.94282818112997 & -1.73466722214369 \tabularnewline
Trimmed Mean ( 2 / 20 ) & -4.88607142857143 & 2.92083065794215 & -1.67283625816701 \tabularnewline
Trimmed Mean ( 3 / 20 ) & -4.65962962962963 & 2.89305212386539 & -1.61062761060936 \tabularnewline
Trimmed Mean ( 4 / 20 ) & -4.43480769230769 & 2.8701227039318 & -1.54516309920563 \tabularnewline
Trimmed Mean ( 5 / 20 ) & -4.1926 & 2.83867542853554 & -1.47695645576604 \tabularnewline
Trimmed Mean ( 6 / 20 ) & -3.92625 & 2.80257840415503 & -1.40094207326333 \tabularnewline
Trimmed Mean ( 7 / 20 ) & -3.63369565217391 & 2.76417113501355 & -1.31456971174692 \tabularnewline
Trimmed Mean ( 8 / 20 ) & -3.32590909090909 & 2.72443679456653 & -1.22076940729259 \tabularnewline
Trimmed Mean ( 9 / 20 ) & -3.02071428571429 & 2.67907865038822 & -1.12751982300951 \tabularnewline
Trimmed Mean ( 10 / 20 ) & -2.75175 & 2.63940773483468 & -1.04256343712365 \tabularnewline
Trimmed Mean ( 11 / 20 ) & -2.47342105263158 & 2.59981647443741 & -0.95138294450835 \tabularnewline
Trimmed Mean ( 12 / 20 ) & -2.17388888888889 & 2.55251025767190 & -0.851667052994197 \tabularnewline
Trimmed Mean ( 13 / 20 ) & -1.94970588235294 & 2.5244296044925 & -0.772335215402016 \tabularnewline
Trimmed Mean ( 14 / 20 ) & -1.7315625 & 2.48975315808223 & -0.69547557129469 \tabularnewline
Trimmed Mean ( 15 / 20 ) & -1.54666666666667 & 2.46726994797257 & -0.626873710328133 \tabularnewline
Trimmed Mean ( 16 / 20 ) & -1.36035714285714 & 2.44951984724525 & -0.555356652605617 \tabularnewline
Trimmed Mean ( 17 / 20 ) & -1.19 & 2.43125709807151 & -0.489458725259422 \tabularnewline
Trimmed Mean ( 18 / 20 ) & -0.98375 & 2.39929071739087 & -0.410017007472021 \tabularnewline
Trimmed Mean ( 19 / 20 ) & -0.735 & 2.34394335566060 & -0.313574130631179 \tabularnewline
Trimmed Mean ( 20 / 20 ) & -0.3305 & 2.27133214737172 & -0.145509321647404 \tabularnewline
Median & 4.74 &  &  \tabularnewline
Midrange & -13.99 &  &  \tabularnewline
Midmean - Weighted Average at Xnp & -2.30193548387097 &  &  \tabularnewline
Midmean - Weighted Average at X(n+1)p & -1.54666666666667 &  &  \tabularnewline
Midmean - Empirical Distribution Function & -2.30193548387097 &  &  \tabularnewline
Midmean - Empirical Distribution Function - Averaging & -1.54666666666667 &  &  \tabularnewline
Midmean - Empirical Distribution Function - Interpolation & -1.54666666666667 &  &  \tabularnewline
Midmean - Closest Observation & -2.30193548387097 &  &  \tabularnewline
Midmean - True Basic - Statistics Graphics Toolkit & -1.54666666666667 &  &  \tabularnewline
Midmean - MS Excel (old versions) & -1.73156250000000 &  &  \tabularnewline
Number of observations & 60 &  &  \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=47088&T=1

[TABLE]
[ROW][C]Central Tendency - Ungrouped Data[/C][/ROW]
[ROW][C]Measure[/C][C]Value[/C][C]S.E.[/C][C]Value/S.E.[/C][/ROW]
[ROW][C]Arithmetic Mean[/C][C]-5.401[/C][C]2.98697209552333[/C][C]-1.80818562319168[/C][/ROW]
[ROW][C]Geometric Mean[/C][C]NaN[/C][C][/C][C][/C][/ROW]
[ROW][C]Harmonic Mean[/C][C]29.8971181428719[/C][C][/C][C][/C][/ROW]
[ROW][C]Quadratic Mean[/C][C]23.5705098940746[/C][C][/C][C][/C][/ROW]
[ROW][C]Winsorized Mean ( 1 / 20 )[/C][C]-5.309[/C][C]2.95828126826150[/C][C]-1.79462313369545[/C][/ROW]
[ROW][C]Winsorized Mean ( 2 / 20 )[/C][C]-5.29366666666667[/C][C]2.95468639503958[/C][C]-1.79161709870592[/C][/ROW]
[ROW][C]Winsorized Mean ( 3 / 20 )[/C][C]-5.24416666666667[/C][C]2.92322371862533[/C][C]-1.79396692536854[/C][/ROW]
[ROW][C]Winsorized Mean ( 4 / 20 )[/C][C]-5.24216666666667[/C][C]2.92131387408844[/C][C]-1.79445512964690[/C][/ROW]
[ROW][C]Winsorized Mean ( 5 / 20 )[/C][C]-5.258[/C][C]2.89995475125424[/C][C]-1.81313173859899[/C][/ROW]
[ROW][C]Winsorized Mean ( 6 / 20 )[/C][C]-5.272[/C][C]2.86259469830775[/C][C]-1.84168579754465[/C][/ROW]
[ROW][C]Winsorized Mean ( 7 / 20 )[/C][C]-5.21366666666667[/C][C]2.81469844614828[/C][C]-1.85230026108168[/C][/ROW]
[ROW][C]Winsorized Mean ( 8 / 20 )[/C][C]-5.035[/C][C]2.77743138763037[/C][C]-1.81282606023104[/C][/ROW]
[ROW][C]Winsorized Mean ( 9 / 20 )[/C][C]-4.6345[/C][C]2.68939735993113[/C][C]-1.72324851249154[/C][/ROW]
[ROW][C]Winsorized Mean ( 10 / 20 )[/C][C]-4.5145[/C][C]2.61981921816672[/C][C]-1.72321050578411[/C][/ROW]
[ROW][C]Winsorized Mean ( 11 / 20 )[/C][C]-4.45033333333333[/C][C]2.57467137902707[/C][C]-1.72850538114695[/C][/ROW]
[ROW][C]Winsorized Mean ( 12 / 20 )[/C][C]-3.69833333333333[/C][C]2.42154743641691[/C][C]-1.52726032854663[/C][/ROW]
[ROW][C]Winsorized Mean ( 13 / 20 )[/C][C]-3.46216666666667[/C][C]2.37723369942378[/C][C]-1.45638464889079[/C][/ROW]
[ROW][C]Winsorized Mean ( 14 / 20 )[/C][C]-3.02583333333333[/C][C]2.25365635482229[/C][C]-1.34263297368242[/C][/ROW]
[ROW][C]Winsorized Mean ( 15 / 20 )[/C][C]-2.85083333333333[/C][C]2.16407481166656[/C][C]-1.31734509267630[/C][/ROW]
[ROW][C]Winsorized Mean ( 16 / 20 )[/C][C]-2.5415[/C][C]2.09543500095334[/C][C]-1.21287465315971[/C][/ROW]
[ROW][C]Winsorized Mean ( 17 / 20 )[/C][C]-2.5925[/C][C]2.05871146998958[/C][C]-1.25928282704575[/C][/ROW]
[ROW][C]Winsorized Mean ( 18 / 20 )[/C][C]-2.6255[/C][C]2.02388734061808[/C][C]-1.29725600200562[/C][/ROW]
[ROW][C]Winsorized Mean ( 19 / 20 )[/C][C]-3.29683333333333[/C][C]1.92086660191541[/C][C]-1.71632602183091[/C][/ROW]
[ROW][C]Winsorized Mean ( 20 / 20 )[/C][C]-3.61016666666667[/C][C]1.87316337908014[/C][C]-1.92731008249773[/C][/ROW]
[ROW][C]Trimmed Mean ( 1 / 20 )[/C][C]-5.1048275862069[/C][C]2.94282818112997[/C][C]-1.73466722214369[/C][/ROW]
[ROW][C]Trimmed Mean ( 2 / 20 )[/C][C]-4.88607142857143[/C][C]2.92083065794215[/C][C]-1.67283625816701[/C][/ROW]
[ROW][C]Trimmed Mean ( 3 / 20 )[/C][C]-4.65962962962963[/C][C]2.89305212386539[/C][C]-1.61062761060936[/C][/ROW]
[ROW][C]Trimmed Mean ( 4 / 20 )[/C][C]-4.43480769230769[/C][C]2.8701227039318[/C][C]-1.54516309920563[/C][/ROW]
[ROW][C]Trimmed Mean ( 5 / 20 )[/C][C]-4.1926[/C][C]2.83867542853554[/C][C]-1.47695645576604[/C][/ROW]
[ROW][C]Trimmed Mean ( 6 / 20 )[/C][C]-3.92625[/C][C]2.80257840415503[/C][C]-1.40094207326333[/C][/ROW]
[ROW][C]Trimmed Mean ( 7 / 20 )[/C][C]-3.63369565217391[/C][C]2.76417113501355[/C][C]-1.31456971174692[/C][/ROW]
[ROW][C]Trimmed Mean ( 8 / 20 )[/C][C]-3.32590909090909[/C][C]2.72443679456653[/C][C]-1.22076940729259[/C][/ROW]
[ROW][C]Trimmed Mean ( 9 / 20 )[/C][C]-3.02071428571429[/C][C]2.67907865038822[/C][C]-1.12751982300951[/C][/ROW]
[ROW][C]Trimmed Mean ( 10 / 20 )[/C][C]-2.75175[/C][C]2.63940773483468[/C][C]-1.04256343712365[/C][/ROW]
[ROW][C]Trimmed Mean ( 11 / 20 )[/C][C]-2.47342105263158[/C][C]2.59981647443741[/C][C]-0.95138294450835[/C][/ROW]
[ROW][C]Trimmed Mean ( 12 / 20 )[/C][C]-2.17388888888889[/C][C]2.55251025767190[/C][C]-0.851667052994197[/C][/ROW]
[ROW][C]Trimmed Mean ( 13 / 20 )[/C][C]-1.94970588235294[/C][C]2.5244296044925[/C][C]-0.772335215402016[/C][/ROW]
[ROW][C]Trimmed Mean ( 14 / 20 )[/C][C]-1.7315625[/C][C]2.48975315808223[/C][C]-0.69547557129469[/C][/ROW]
[ROW][C]Trimmed Mean ( 15 / 20 )[/C][C]-1.54666666666667[/C][C]2.46726994797257[/C][C]-0.626873710328133[/C][/ROW]
[ROW][C]Trimmed Mean ( 16 / 20 )[/C][C]-1.36035714285714[/C][C]2.44951984724525[/C][C]-0.555356652605617[/C][/ROW]
[ROW][C]Trimmed Mean ( 17 / 20 )[/C][C]-1.19[/C][C]2.43125709807151[/C][C]-0.489458725259422[/C][/ROW]
[ROW][C]Trimmed Mean ( 18 / 20 )[/C][C]-0.98375[/C][C]2.39929071739087[/C][C]-0.410017007472021[/C][/ROW]
[ROW][C]Trimmed Mean ( 19 / 20 )[/C][C]-0.735[/C][C]2.34394335566060[/C][C]-0.313574130631179[/C][/ROW]
[ROW][C]Trimmed Mean ( 20 / 20 )[/C][C]-0.3305[/C][C]2.27133214737172[/C][C]-0.145509321647404[/C][/ROW]
[ROW][C]Median[/C][C]4.74[/C][C][/C][C][/C][/ROW]
[ROW][C]Midrange[/C][C]-13.99[/C][C][/C][C][/C][/ROW]
[ROW][C]Midmean - Weighted Average at Xnp[/C][C]-2.30193548387097[/C][C][/C][C][/C][/ROW]
[ROW][C]Midmean - Weighted Average at X(n+1)p[/C][C]-1.54666666666667[/C][C][/C][C][/C][/ROW]
[ROW][C]Midmean - Empirical Distribution Function[/C][C]-2.30193548387097[/C][C][/C][C][/C][/ROW]
[ROW][C]Midmean - Empirical Distribution Function - Averaging[/C][C]-1.54666666666667[/C][C][/C][C][/C][/ROW]
[ROW][C]Midmean - Empirical Distribution Function - Interpolation[/C][C]-1.54666666666667[/C][C][/C][C][/C][/ROW]
[ROW][C]Midmean - Closest Observation[/C][C]-2.30193548387097[/C][C][/C][C][/C][/ROW]
[ROW][C]Midmean - True Basic - Statistics Graphics Toolkit[/C][C]-1.54666666666667[/C][C][/C][C][/C][/ROW]
[ROW][C]Midmean - MS Excel (old versions)[/C][C]-1.73156250000000[/C][C][/C][C][/C][/ROW]
[ROW][C]Number of observations[/C][C]60[/C][C][/C][C][/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=47088&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=47088&T=1

As an alternative you can also use a QR Code:  

The GUIDs for individual cells are displayed in the table below:

Central Tendency - Ungrouped Data
MeasureValueS.E.Value/S.E.
Arithmetic Mean-5.4012.98697209552333-1.80818562319168
Geometric MeanNaN
Harmonic Mean29.8971181428719
Quadratic Mean23.5705098940746
Winsorized Mean ( 1 / 20 )-5.3092.95828126826150-1.79462313369545
Winsorized Mean ( 2 / 20 )-5.293666666666672.95468639503958-1.79161709870592
Winsorized Mean ( 3 / 20 )-5.244166666666672.92322371862533-1.79396692536854
Winsorized Mean ( 4 / 20 )-5.242166666666672.92131387408844-1.79445512964690
Winsorized Mean ( 5 / 20 )-5.2582.89995475125424-1.81313173859899
Winsorized Mean ( 6 / 20 )-5.2722.86259469830775-1.84168579754465
Winsorized Mean ( 7 / 20 )-5.213666666666672.81469844614828-1.85230026108168
Winsorized Mean ( 8 / 20 )-5.0352.77743138763037-1.81282606023104
Winsorized Mean ( 9 / 20 )-4.63452.68939735993113-1.72324851249154
Winsorized Mean ( 10 / 20 )-4.51452.61981921816672-1.72321050578411
Winsorized Mean ( 11 / 20 )-4.450333333333332.57467137902707-1.72850538114695
Winsorized Mean ( 12 / 20 )-3.698333333333332.42154743641691-1.52726032854663
Winsorized Mean ( 13 / 20 )-3.462166666666672.37723369942378-1.45638464889079
Winsorized Mean ( 14 / 20 )-3.025833333333332.25365635482229-1.34263297368242
Winsorized Mean ( 15 / 20 )-2.850833333333332.16407481166656-1.31734509267630
Winsorized Mean ( 16 / 20 )-2.54152.09543500095334-1.21287465315971
Winsorized Mean ( 17 / 20 )-2.59252.05871146998958-1.25928282704575
Winsorized Mean ( 18 / 20 )-2.62552.02388734061808-1.29725600200562
Winsorized Mean ( 19 / 20 )-3.296833333333331.92086660191541-1.71632602183091
Winsorized Mean ( 20 / 20 )-3.610166666666671.87316337908014-1.92731008249773
Trimmed Mean ( 1 / 20 )-5.10482758620692.94282818112997-1.73466722214369
Trimmed Mean ( 2 / 20 )-4.886071428571432.92083065794215-1.67283625816701
Trimmed Mean ( 3 / 20 )-4.659629629629632.89305212386539-1.61062761060936
Trimmed Mean ( 4 / 20 )-4.434807692307692.8701227039318-1.54516309920563
Trimmed Mean ( 5 / 20 )-4.19262.83867542853554-1.47695645576604
Trimmed Mean ( 6 / 20 )-3.926252.80257840415503-1.40094207326333
Trimmed Mean ( 7 / 20 )-3.633695652173912.76417113501355-1.31456971174692
Trimmed Mean ( 8 / 20 )-3.325909090909092.72443679456653-1.22076940729259
Trimmed Mean ( 9 / 20 )-3.020714285714292.67907865038822-1.12751982300951
Trimmed Mean ( 10 / 20 )-2.751752.63940773483468-1.04256343712365
Trimmed Mean ( 11 / 20 )-2.473421052631582.59981647443741-0.95138294450835
Trimmed Mean ( 12 / 20 )-2.173888888888892.55251025767190-0.851667052994197
Trimmed Mean ( 13 / 20 )-1.949705882352942.5244296044925-0.772335215402016
Trimmed Mean ( 14 / 20 )-1.73156252.48975315808223-0.69547557129469
Trimmed Mean ( 15 / 20 )-1.546666666666672.46726994797257-0.626873710328133
Trimmed Mean ( 16 / 20 )-1.360357142857142.44951984724525-0.555356652605617
Trimmed Mean ( 17 / 20 )-1.192.43125709807151-0.489458725259422
Trimmed Mean ( 18 / 20 )-0.983752.39929071739087-0.410017007472021
Trimmed Mean ( 19 / 20 )-0.7352.34394335566060-0.313574130631179
Trimmed Mean ( 20 / 20 )-0.33052.27133214737172-0.145509321647404
Median4.74
Midrange-13.99
Midmean - Weighted Average at Xnp-2.30193548387097
Midmean - Weighted Average at X(n+1)p-1.54666666666667
Midmean - Empirical Distribution Function-2.30193548387097
Midmean - Empirical Distribution Function - Averaging-1.54666666666667
Midmean - Empirical Distribution Function - Interpolation-1.54666666666667
Midmean - Closest Observation-2.30193548387097
Midmean - True Basic - Statistics Graphics Toolkit-1.54666666666667
Midmean - MS Excel (old versions)-1.73156250000000
Number of observations60



Parameters (Session):
Parameters (R input):
R code (references can be found in the software module):
geomean <- function(x) {
return(exp(mean(log(x))))
}
harmean <- function(x) {
return(1/mean(1/x))
}
quamean <- function(x) {
return(sqrt(mean(x*x)))
}
winmean <- function(x) {
x <-sort(x[!is.na(x)])
n<-length(x)
denom <- 3
nodenom <- n/denom
if (nodenom>40) denom <- n/40
sqrtn = sqrt(n)
roundnodenom = floor(nodenom)
win <- array(NA,dim=c(roundnodenom,2))
for (j in 1:roundnodenom) {
win[j,1] <- (j*x[j+1]+sum(x[(j+1):(n-j)])+j*x[n-j])/n
win[j,2] <- sd(c(rep(x[j+1],j),x[(j+1):(n-j)],rep(x[n-j],j)))/sqrtn
}
return(win)
}
trimean <- function(x) {
x <-sort(x[!is.na(x)])
n<-length(x)
denom <- 3
nodenom <- n/denom
if (nodenom>40) denom <- n/40
sqrtn = sqrt(n)
roundnodenom = floor(nodenom)
tri <- array(NA,dim=c(roundnodenom,2))
for (j in 1:roundnodenom) {
tri[j,1] <- mean(x,trim=j/n)
tri[j,2] <- sd(x[(j+1):(n-j)]) / sqrt(n-j*2)
}
return(tri)
}
midrange <- function(x) {
return((max(x)+min(x))/2)
}
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]
}
}
}
}
midmean <- function(x,def) {
x <-sort(x[!is.na(x)])
n<-length(x)
if (def==1) {
qvalue1 <- q1(x,n,0.25,i,f)
qvalue3 <- q1(x,n,0.75,i,f)
}
if (def==2) {
qvalue1 <- q2(x,n,0.25,i,f)
qvalue3 <- q2(x,n,0.75,i,f)
}
if (def==3) {
qvalue1 <- q3(x,n,0.25,i,f)
qvalue3 <- q3(x,n,0.75,i,f)
}
if (def==4) {
qvalue1 <- q4(x,n,0.25,i,f)
qvalue3 <- q4(x,n,0.75,i,f)
}
if (def==5) {
qvalue1 <- q5(x,n,0.25,i,f)
qvalue3 <- q5(x,n,0.75,i,f)
}
if (def==6) {
qvalue1 <- q6(x,n,0.25,i,f)
qvalue3 <- q6(x,n,0.75,i,f)
}
if (def==7) {
qvalue1 <- q7(x,n,0.25,i,f)
qvalue3 <- q7(x,n,0.75,i,f)
}
if (def==8) {
qvalue1 <- q8(x,n,0.25,i,f)
qvalue3 <- q8(x,n,0.75,i,f)
}
midm <- 0
myn <- 0
roundno4 <- round(n/4)
round3no4 <- round(3*n/4)
for (i in 1:n) {
if ((x[i]>=qvalue1) & (x[i]<=qvalue3)){
midm = midm + x[i]
myn = myn + 1
}
}
midm = midm / myn
return(midm)
}
(arm <- mean(x))
sqrtn <- sqrt(length(x))
(armse <- sd(x) / sqrtn)
(armose <- arm / armse)
(geo <- geomean(x))
(har <- harmean(x))
(qua <- quamean(x))
(win <- winmean(x))
(tri <- trimean(x))
(midr <- midrange(x))
midm <- array(NA,dim=8)
for (j in 1:8) midm[j] <- midmean(x,j)
midm
bitmap(file='test1.png')
lb <- win[,1] - 2*win[,2]
ub <- win[,1] + 2*win[,2]
if ((ylimmin == '') | (ylimmax == '')) plot(win[,1],type='b',main=main, xlab='j', pch=19, ylab='Winsorized Mean(j/n)', ylim=c(min(lb),max(ub))) else plot(win[,1],type='l',main=main, xlab='j', pch=19, ylab='Winsorized Mean(j/n)', ylim=c(ylimmin,ylimmax))
lines(ub,lty=3)
lines(lb,lty=3)
grid()
dev.off()
bitmap(file='test2.png')
lb <- tri[,1] - 2*tri[,2]
ub <- tri[,1] + 2*tri[,2]
if ((ylimmin == '') | (ylimmax == '')) plot(tri[,1],type='b',main=main, xlab='j', pch=19, ylab='Trimmed Mean(j/n)', ylim=c(min(lb),max(ub))) else plot(tri[,1],type='l',main=main, xlab='j', pch=19, ylab='Trimmed Mean(j/n)', ylim=c(ylimmin,ylimmax))
lines(ub,lty=3)
lines(lb,lty=3)
grid()
dev.off()
load(file='createtable')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Central Tendency - Ungrouped Data',4,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Measure',header=TRUE)
a<-table.element(a,'Value',header=TRUE)
a<-table.element(a,'S.E.',header=TRUE)
a<-table.element(a,'Value/S.E.',header=TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,hyperlink('arithmetic_mean.htm', 'Arithmetic Mean', 'click to view the definition of the Arithmetic Mean'),header=TRUE)
a<-table.element(a,arm)
a<-table.element(a,hyperlink('arithmetic_mean_standard_error.htm', armse, 'click to view the definition of the Standard Error of the Arithmetic Mean'))
a<-table.element(a,armose)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,hyperlink('geometric_mean.htm', 'Geometric Mean', 'click to view the definition of the Geometric Mean'),header=TRUE)
a<-table.element(a,geo)
a<-table.element(a,'')
a<-table.element(a,'')
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,hyperlink('harmonic_mean.htm', 'Harmonic Mean', 'click to view the definition of the Harmonic Mean'),header=TRUE)
a<-table.element(a,har)
a<-table.element(a,'')
a<-table.element(a,'')
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,hyperlink('quadratic_mean.htm', 'Quadratic Mean', 'click to view the definition of the Quadratic Mean'),header=TRUE)
a<-table.element(a,qua)
a<-table.element(a,'')
a<-table.element(a,'')
a<-table.row.end(a)
for (j in 1:length(win[,1])) {
a<-table.row.start(a)
mylabel <- paste('Winsorized Mean (',j)
mylabel <- paste(mylabel,'/')
mylabel <- paste(mylabel,length(win[,1]))
mylabel <- paste(mylabel,')')
a<-table.element(a,hyperlink('winsorized_mean.htm', mylabel, 'click to view the definition of the Winsorized Mean'),header=TRUE)
a<-table.element(a,win[j,1])
a<-table.element(a,win[j,2])
a<-table.element(a,win[j,1]/win[j,2])
a<-table.row.end(a)
}
for (j in 1:length(tri[,1])) {
a<-table.row.start(a)
mylabel <- paste('Trimmed Mean (',j)
mylabel <- paste(mylabel,'/')
mylabel <- paste(mylabel,length(tri[,1]))
mylabel <- paste(mylabel,')')
a<-table.element(a,hyperlink('arithmetic_mean.htm', mylabel, 'click to view the definition of the Trimmed Mean'),header=TRUE)
a<-table.element(a,tri[j,1])
a<-table.element(a,tri[j,2])
a<-table.element(a,tri[j,1]/tri[j,2])
a<-table.row.end(a)
}
a<-table.row.start(a)
a<-table.element(a,hyperlink('median_1.htm', 'Median', 'click to view the definition of the Median'),header=TRUE)
a<-table.element(a,median(x))
a<-table.element(a,'')
a<-table.element(a,'')
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,hyperlink('midrange.htm', 'Midrange', 'click to view the definition of the Midrange'),header=TRUE)
a<-table.element(a,midr)
a<-table.element(a,'')
a<-table.element(a,'')
a<-table.row.end(a)
a<-table.row.start(a)
mymid <- hyperlink('midmean.htm', 'Midmean', 'click to view the definition of the Midmean')
mylabel <- paste(mymid,hyperlink('method_1.htm','Weighted Average at Xnp',''),sep=' - ')
a<-table.element(a,mylabel,header=TRUE)
a<-table.element(a,midm[1])
a<-table.element(a,'')
a<-table.element(a,'')
a<-table.row.end(a)
a<-table.row.start(a)
mymid <- hyperlink('midmean.htm', 'Midmean', 'click to view the definition of the Midmean')
mylabel <- paste(mymid,hyperlink('method_2.htm','Weighted Average at X(n+1)p',''),sep=' - ')
a<-table.element(a,mylabel,header=TRUE)
a<-table.element(a,midm[2])
a<-table.element(a,'')
a<-table.element(a,'')
a<-table.row.end(a)
a<-table.row.start(a)
mymid <- hyperlink('midmean.htm', 'Midmean', 'click to view the definition of the Midmean')
mylabel <- paste(mymid,hyperlink('method_3.htm','Empirical Distribution Function',''),sep=' - ')
a<-table.element(a,mylabel,header=TRUE)
a<-table.element(a,midm[3])
a<-table.element(a,'')
a<-table.element(a,'')
a<-table.row.end(a)
a<-table.row.start(a)
mymid <- hyperlink('midmean.htm', 'Midmean', 'click to view the definition of the Midmean')
mylabel <- paste(mymid,hyperlink('method_4.htm','Empirical Distribution Function - Averaging',''),sep=' - ')
a<-table.element(a,mylabel,header=TRUE)
a<-table.element(a,midm[4])
a<-table.element(a,'')
a<-table.element(a,'')
a<-table.row.end(a)
a<-table.row.start(a)
mymid <- hyperlink('midmean.htm', 'Midmean', 'click to view the definition of the Midmean')
mylabel <- paste(mymid,hyperlink('method_5.htm','Empirical Distribution Function - Interpolation',''),sep=' - ')
a<-table.element(a,mylabel,header=TRUE)
a<-table.element(a,midm[5])
a<-table.element(a,'')
a<-table.element(a,'')
a<-table.row.end(a)
a<-table.row.start(a)
mymid <- hyperlink('midmean.htm', 'Midmean', 'click to view the definition of the Midmean')
mylabel <- paste(mymid,hyperlink('method_6.htm','Closest Observation',''),sep=' - ')
a<-table.element(a,mylabel,header=TRUE)
a<-table.element(a,midm[6])
a<-table.element(a,'')
a<-table.element(a,'')
a<-table.row.end(a)
a<-table.row.start(a)
mymid <- hyperlink('midmean.htm', 'Midmean', 'click to view the definition of the Midmean')
mylabel <- paste(mymid,hyperlink('method_7.htm','True Basic - Statistics Graphics Toolkit',''),sep=' - ')
a<-table.element(a,mylabel,header=TRUE)
a<-table.element(a,midm[7])
a<-table.element(a,'')
a<-table.element(a,'')
a<-table.row.end(a)
a<-table.row.start(a)
mymid <- hyperlink('midmean.htm', 'Midmean', 'click to view the definition of the Midmean')
mylabel <- paste(mymid,hyperlink('method_8.htm','MS Excel (old versions)',''),sep=' - ')
a<-table.element(a,mylabel,header=TRUE)
a<-table.element(a,midm[8])
a<-table.element(a,'')
a<-table.element(a,'')
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Number of observations',header=TRUE)
a<-table.element(a,length(x))
a<-table.element(a,'')
a<-table.element(a,'')
a<-table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable.tab')