Free Statistics

of Irreproducible Research!

Author's title

Author*Unverified author*
R Software Modulerwasp_centraltendency.wasp
Title produced by softwareCentral Tendency
Date of computationWed, 12 Dec 2007 14:27:48 -0700
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2007/Dec/12/t1197493974ngind4xzrjzycq8.htm/, Retrieved Thu, 02 May 2024 18:54:36 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=3279, Retrieved Thu, 02 May 2024 18:54:36 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact160
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-       [Central Tendency] [G3Centraltendency...] [2007-12-12 21:27:48] [142ab5472309a9ae9a3b52678758dc4a] [Current]
Feedback Forum

Post a new message
Dataseries X:
-148.1310345
82.26896552
39.46896552
-478.7310345
-171.1310345
372.3586207
-616.6413793
651.1586207
-418.6413793
78.75862069
103.9586207
-57.44137931
24.86896552
152.2689655
254.4689655
-121.7310345
252.8689655
-210.0896552
-692.0896552
314.7103448
-422.0896552
15.31034483
-75.48965517
-93.88965517
70.42068966
195.8206897
-170.9793103
234.8206897
-4.579310345
-228.0896552
462.9103448
-458.2896552
-230.0896552
81.31034483
14.51034483
-39.88965517
63.42068966
-152.1793103
-205.9793103
228.8206897
-42.57931034
-317.0896552
528.9103448
-352.2896552
105.9103448
-61.68965517
18.51034483
-29.88965517
-10.57931034
-278.1793103
83.02068966
136.8206897
-34.57931034
382.9103448
316.9103448
-155.2896552
964.9103448
-113.6896552
-61.48965517
221.1103448




Summary of compuational 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 compuational 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=3279&T=0

[TABLE]
[ROW][C]Summary of compuational 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=3279&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=3279&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 compuational 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-2.41666889023532e-0937.9248545910749-6.37225617947142e-11
Geometric MeanNaN
Harmonic Mean-341.297583331805
Quadratic Mean291.306335580770
Winsorized Mean ( 1 / 20 )-3.9717241390833435.5935564736646-0.111585481546976
Winsorized Mean ( 2 / 20 )-3.4496551757533.1680099515013-0.104005491459817
Winsorized Mean ( 3 / 20 )-5.7275862107532.0633068172251-0.178633671299088
Winsorized Mean ( 4 / 20 )-8.6475862107530.2468978888948-0.285899937326299
Winsorized Mean ( 5 / 20 )-9.2395402274166629.9890718890809-0.308096904818878
Winsorized Mean ( 6 / 20 )-8.1491954074166727.3530413343878-0.29792648312097
Winsorized Mean ( 7 / 20 )-4.2991954074166626.4511176818311-0.162533601004305
Winsorized Mean ( 8 / 20 )-7.1433333274166723.8595665981857-0.299390741152852
Winsorized Mean ( 9 / 20 )-0.16988506241667322.4930578880878-0.00755277753971563
Winsorized Mean ( 10 / 20 )-2.8445976957521.8711710737238-0.130061517335371
Winsorized Mean ( 11 / 20 )-0.6445976957521.1027423361422-0.0305456838491561
Winsorized Mean ( 12 / 20 )-1.3645976957500020.6819784033940-0.065980036780527
Winsorized Mean ( 13 / 20 )0.70643678924999818.46038991579430.0382677068291816
Winsorized Mean ( 14 / 20 )-9.4202298774166716.7072041153430-0.563842388731315
Winsorized Mean ( 15 / 20 )-9.3598850524166715.4445957356133-0.606029786252932
Winsorized Mean ( 16 / 20 )-16.7732183857514.0363133343071-1.19498745762204
Winsorized Mean ( 17 / 20 )-16.179195404083313.7675172760158-1.17517160717633
Winsorized Mean ( 18 / 20 )-14.540574716083311.5873030140903-1.25487136207639
Winsorized Mean ( 19 / 20 )-12.232183915416711.1573046885047-1.09633861016805
Winsorized Mean ( 20 / 20 )-5.9517241354166610.1150593461582-0.588402295205238
Trimmed Mean ( 1 / 20 )-4.7038049956034533.3646533559103-0.140981683382909
Trimmed Mean ( 2 / 20 )-5.48817734187530.5553677750009-0.179614180470287
Trimmed Mean ( 3 / 20 )-6.6206896563888928.7521280938368-0.230267813039136
Trimmed Mean ( 4 / 20 )-6.9641909816346127.0571549917345-0.257388146823347
Trimmed Mean ( 5 / 20 )-6.459172412925.6917175444885-0.251410689134158
Trimmed Mean ( 6 / 20 )-5.7640804592708324.0395044173412-0.239775344749322
Trimmed Mean ( 7 / 20 )-5.2455772096739122.8365992532842-0.229700453710048
Trimmed Mean ( 8 / 20 )-5.4299373010227321.5654056149359-0.251789249781698
Trimmed Mean ( 9 / 20 )-5.1239737248809520.7014427875147-0.247517710599925
Trimmed Mean ( 10 / 20 )-5.94965516862519.9480970195702-0.298256779219996
Trimmed Mean ( 11 / 20 )-6.4399274011842119.1096220729232-0.336999202632535
Trimmed Mean ( 12 / 20 )-7.3180076595833318.1831785494557-0.402460309108189
Trimmed Mean ( 13 / 20 )-8.1935091248529417.0173281471231-0.481480350735207
Trimmed Mean ( 14 / 20 )-9.4771551701562516.0862159438950-0.58914757847404
Trimmed Mean ( 15 / 20 )-9.4852873548333315.3297643397274-0.61874971751862
Trimmed Mean ( 16 / 20 )-9.5032019694642914.6288787832609-0.649619298256699
Trimmed Mean ( 17 / 20 )-8.4546419094230814.0374088288729-0.602293629293827
Trimmed Mean ( 18 / 20 )-7.3186781602083313.1810514059528-0.555242365332335
Trimmed Mean ( 19 / 20 )-6.2244514093181812.7094414026423-0.489750195317325
Trimmed Mean ( 20 / 20 )-5.2758620662512.0556781614146-0.43762466081219
Median-7.5793103425
Midrange136.4103448
Midmean - Weighted Average at Xnp-14.6947719659677
Midmean - Weighted Average at X(n+1)p-9.48528735483332
Midmean - Empirical Distribution Function-14.6947719659677
Midmean - Empirical Distribution Function - Averaging-9.48528735483332
Midmean - Empirical Distribution Function - Interpolation-9.48528735483332
Midmean - Closest Observation-14.6947719659677
Midmean - True Basic - Statistics Graphics Toolkit-9.48528735483332
Midmean - MS Excel (old versions)-9.47715517015624
Number of observations60

\begin{tabular}{lllllllll}
\hline
Central Tendency - Ungrouped Data \tabularnewline
Measure & Value & S.E. & Value/S.E. \tabularnewline
Arithmetic Mean & -2.41666889023532e-09 & 37.9248545910749 & -6.37225617947142e-11 \tabularnewline
Geometric Mean & NaN &  &  \tabularnewline
Harmonic Mean & -341.297583331805 &  &  \tabularnewline
Quadratic Mean & 291.306335580770 &  &  \tabularnewline
Winsorized Mean ( 1 / 20 ) & -3.97172413908334 & 35.5935564736646 & -0.111585481546976 \tabularnewline
Winsorized Mean ( 2 / 20 ) & -3.44965517575 & 33.1680099515013 & -0.104005491459817 \tabularnewline
Winsorized Mean ( 3 / 20 ) & -5.72758621075 & 32.0633068172251 & -0.178633671299088 \tabularnewline
Winsorized Mean ( 4 / 20 ) & -8.64758621075 & 30.2468978888948 & -0.285899937326299 \tabularnewline
Winsorized Mean ( 5 / 20 ) & -9.23954022741666 & 29.9890718890809 & -0.308096904818878 \tabularnewline
Winsorized Mean ( 6 / 20 ) & -8.14919540741667 & 27.3530413343878 & -0.29792648312097 \tabularnewline
Winsorized Mean ( 7 / 20 ) & -4.29919540741666 & 26.4511176818311 & -0.162533601004305 \tabularnewline
Winsorized Mean ( 8 / 20 ) & -7.14333332741667 & 23.8595665981857 & -0.299390741152852 \tabularnewline
Winsorized Mean ( 9 / 20 ) & -0.169885062416673 & 22.4930578880878 & -0.00755277753971563 \tabularnewline
Winsorized Mean ( 10 / 20 ) & -2.84459769575 & 21.8711710737238 & -0.130061517335371 \tabularnewline
Winsorized Mean ( 11 / 20 ) & -0.64459769575 & 21.1027423361422 & -0.0305456838491561 \tabularnewline
Winsorized Mean ( 12 / 20 ) & -1.36459769575000 & 20.6819784033940 & -0.065980036780527 \tabularnewline
Winsorized Mean ( 13 / 20 ) & 0.706436789249998 & 18.4603899157943 & 0.0382677068291816 \tabularnewline
Winsorized Mean ( 14 / 20 ) & -9.42022987741667 & 16.7072041153430 & -0.563842388731315 \tabularnewline
Winsorized Mean ( 15 / 20 ) & -9.35988505241667 & 15.4445957356133 & -0.606029786252932 \tabularnewline
Winsorized Mean ( 16 / 20 ) & -16.77321838575 & 14.0363133343071 & -1.19498745762204 \tabularnewline
Winsorized Mean ( 17 / 20 ) & -16.1791954040833 & 13.7675172760158 & -1.17517160717633 \tabularnewline
Winsorized Mean ( 18 / 20 ) & -14.5405747160833 & 11.5873030140903 & -1.25487136207639 \tabularnewline
Winsorized Mean ( 19 / 20 ) & -12.2321839154167 & 11.1573046885047 & -1.09633861016805 \tabularnewline
Winsorized Mean ( 20 / 20 ) & -5.95172413541666 & 10.1150593461582 & -0.588402295205238 \tabularnewline
Trimmed Mean ( 1 / 20 ) & -4.70380499560345 & 33.3646533559103 & -0.140981683382909 \tabularnewline
Trimmed Mean ( 2 / 20 ) & -5.488177341875 & 30.5553677750009 & -0.179614180470287 \tabularnewline
Trimmed Mean ( 3 / 20 ) & -6.62068965638889 & 28.7521280938368 & -0.230267813039136 \tabularnewline
Trimmed Mean ( 4 / 20 ) & -6.96419098163461 & 27.0571549917345 & -0.257388146823347 \tabularnewline
Trimmed Mean ( 5 / 20 ) & -6.4591724129 & 25.6917175444885 & -0.251410689134158 \tabularnewline
Trimmed Mean ( 6 / 20 ) & -5.76408045927083 & 24.0395044173412 & -0.239775344749322 \tabularnewline
Trimmed Mean ( 7 / 20 ) & -5.24557720967391 & 22.8365992532842 & -0.229700453710048 \tabularnewline
Trimmed Mean ( 8 / 20 ) & -5.42993730102273 & 21.5654056149359 & -0.251789249781698 \tabularnewline
Trimmed Mean ( 9 / 20 ) & -5.12397372488095 & 20.7014427875147 & -0.247517710599925 \tabularnewline
Trimmed Mean ( 10 / 20 ) & -5.949655168625 & 19.9480970195702 & -0.298256779219996 \tabularnewline
Trimmed Mean ( 11 / 20 ) & -6.43992740118421 & 19.1096220729232 & -0.336999202632535 \tabularnewline
Trimmed Mean ( 12 / 20 ) & -7.31800765958333 & 18.1831785494557 & -0.402460309108189 \tabularnewline
Trimmed Mean ( 13 / 20 ) & -8.19350912485294 & 17.0173281471231 & -0.481480350735207 \tabularnewline
Trimmed Mean ( 14 / 20 ) & -9.47715517015625 & 16.0862159438950 & -0.58914757847404 \tabularnewline
Trimmed Mean ( 15 / 20 ) & -9.48528735483333 & 15.3297643397274 & -0.61874971751862 \tabularnewline
Trimmed Mean ( 16 / 20 ) & -9.50320196946429 & 14.6288787832609 & -0.649619298256699 \tabularnewline
Trimmed Mean ( 17 / 20 ) & -8.45464190942308 & 14.0374088288729 & -0.602293629293827 \tabularnewline
Trimmed Mean ( 18 / 20 ) & -7.31867816020833 & 13.1810514059528 & -0.555242365332335 \tabularnewline
Trimmed Mean ( 19 / 20 ) & -6.22445140931818 & 12.7094414026423 & -0.489750195317325 \tabularnewline
Trimmed Mean ( 20 / 20 ) & -5.27586206625 & 12.0556781614146 & -0.43762466081219 \tabularnewline
Median & -7.5793103425 &  &  \tabularnewline
Midrange & 136.4103448 &  &  \tabularnewline
Midmean - Weighted Average at Xnp & -14.6947719659677 &  &  \tabularnewline
Midmean - Weighted Average at X(n+1)p & -9.48528735483332 &  &  \tabularnewline
Midmean - Empirical Distribution Function & -14.6947719659677 &  &  \tabularnewline
Midmean - Empirical Distribution Function - Averaging & -9.48528735483332 &  &  \tabularnewline
Midmean - Empirical Distribution Function - Interpolation & -9.48528735483332 &  &  \tabularnewline
Midmean - Closest Observation & -14.6947719659677 &  &  \tabularnewline
Midmean - True Basic - Statistics Graphics Toolkit & -9.48528735483332 &  &  \tabularnewline
Midmean - MS Excel (old versions) & -9.47715517015624 &  &  \tabularnewline
Number of observations & 60 &  &  \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=3279&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]-2.41666889023532e-09[/C][C]37.9248545910749[/C][C]-6.37225617947142e-11[/C][/ROW]
[ROW][C]Geometric Mean[/C][C]NaN[/C][C][/C][C][/C][/ROW]
[ROW][C]Harmonic Mean[/C][C]-341.297583331805[/C][C][/C][C][/C][/ROW]
[ROW][C]Quadratic Mean[/C][C]291.306335580770[/C][C][/C][C][/C][/ROW]
[ROW][C]Winsorized Mean ( 1 / 20 )[/C][C]-3.97172413908334[/C][C]35.5935564736646[/C][C]-0.111585481546976[/C][/ROW]
[ROW][C]Winsorized Mean ( 2 / 20 )[/C][C]-3.44965517575[/C][C]33.1680099515013[/C][C]-0.104005491459817[/C][/ROW]
[ROW][C]Winsorized Mean ( 3 / 20 )[/C][C]-5.72758621075[/C][C]32.0633068172251[/C][C]-0.178633671299088[/C][/ROW]
[ROW][C]Winsorized Mean ( 4 / 20 )[/C][C]-8.64758621075[/C][C]30.2468978888948[/C][C]-0.285899937326299[/C][/ROW]
[ROW][C]Winsorized Mean ( 5 / 20 )[/C][C]-9.23954022741666[/C][C]29.9890718890809[/C][C]-0.308096904818878[/C][/ROW]
[ROW][C]Winsorized Mean ( 6 / 20 )[/C][C]-8.14919540741667[/C][C]27.3530413343878[/C][C]-0.29792648312097[/C][/ROW]
[ROW][C]Winsorized Mean ( 7 / 20 )[/C][C]-4.29919540741666[/C][C]26.4511176818311[/C][C]-0.162533601004305[/C][/ROW]
[ROW][C]Winsorized Mean ( 8 / 20 )[/C][C]-7.14333332741667[/C][C]23.8595665981857[/C][C]-0.299390741152852[/C][/ROW]
[ROW][C]Winsorized Mean ( 9 / 20 )[/C][C]-0.169885062416673[/C][C]22.4930578880878[/C][C]-0.00755277753971563[/C][/ROW]
[ROW][C]Winsorized Mean ( 10 / 20 )[/C][C]-2.84459769575[/C][C]21.8711710737238[/C][C]-0.130061517335371[/C][/ROW]
[ROW][C]Winsorized Mean ( 11 / 20 )[/C][C]-0.64459769575[/C][C]21.1027423361422[/C][C]-0.0305456838491561[/C][/ROW]
[ROW][C]Winsorized Mean ( 12 / 20 )[/C][C]-1.36459769575000[/C][C]20.6819784033940[/C][C]-0.065980036780527[/C][/ROW]
[ROW][C]Winsorized Mean ( 13 / 20 )[/C][C]0.706436789249998[/C][C]18.4603899157943[/C][C]0.0382677068291816[/C][/ROW]
[ROW][C]Winsorized Mean ( 14 / 20 )[/C][C]-9.42022987741667[/C][C]16.7072041153430[/C][C]-0.563842388731315[/C][/ROW]
[ROW][C]Winsorized Mean ( 15 / 20 )[/C][C]-9.35988505241667[/C][C]15.4445957356133[/C][C]-0.606029786252932[/C][/ROW]
[ROW][C]Winsorized Mean ( 16 / 20 )[/C][C]-16.77321838575[/C][C]14.0363133343071[/C][C]-1.19498745762204[/C][/ROW]
[ROW][C]Winsorized Mean ( 17 / 20 )[/C][C]-16.1791954040833[/C][C]13.7675172760158[/C][C]-1.17517160717633[/C][/ROW]
[ROW][C]Winsorized Mean ( 18 / 20 )[/C][C]-14.5405747160833[/C][C]11.5873030140903[/C][C]-1.25487136207639[/C][/ROW]
[ROW][C]Winsorized Mean ( 19 / 20 )[/C][C]-12.2321839154167[/C][C]11.1573046885047[/C][C]-1.09633861016805[/C][/ROW]
[ROW][C]Winsorized Mean ( 20 / 20 )[/C][C]-5.95172413541666[/C][C]10.1150593461582[/C][C]-0.588402295205238[/C][/ROW]
[ROW][C]Trimmed Mean ( 1 / 20 )[/C][C]-4.70380499560345[/C][C]33.3646533559103[/C][C]-0.140981683382909[/C][/ROW]
[ROW][C]Trimmed Mean ( 2 / 20 )[/C][C]-5.488177341875[/C][C]30.5553677750009[/C][C]-0.179614180470287[/C][/ROW]
[ROW][C]Trimmed Mean ( 3 / 20 )[/C][C]-6.62068965638889[/C][C]28.7521280938368[/C][C]-0.230267813039136[/C][/ROW]
[ROW][C]Trimmed Mean ( 4 / 20 )[/C][C]-6.96419098163461[/C][C]27.0571549917345[/C][C]-0.257388146823347[/C][/ROW]
[ROW][C]Trimmed Mean ( 5 / 20 )[/C][C]-6.4591724129[/C][C]25.6917175444885[/C][C]-0.251410689134158[/C][/ROW]
[ROW][C]Trimmed Mean ( 6 / 20 )[/C][C]-5.76408045927083[/C][C]24.0395044173412[/C][C]-0.239775344749322[/C][/ROW]
[ROW][C]Trimmed Mean ( 7 / 20 )[/C][C]-5.24557720967391[/C][C]22.8365992532842[/C][C]-0.229700453710048[/C][/ROW]
[ROW][C]Trimmed Mean ( 8 / 20 )[/C][C]-5.42993730102273[/C][C]21.5654056149359[/C][C]-0.251789249781698[/C][/ROW]
[ROW][C]Trimmed Mean ( 9 / 20 )[/C][C]-5.12397372488095[/C][C]20.7014427875147[/C][C]-0.247517710599925[/C][/ROW]
[ROW][C]Trimmed Mean ( 10 / 20 )[/C][C]-5.949655168625[/C][C]19.9480970195702[/C][C]-0.298256779219996[/C][/ROW]
[ROW][C]Trimmed Mean ( 11 / 20 )[/C][C]-6.43992740118421[/C][C]19.1096220729232[/C][C]-0.336999202632535[/C][/ROW]
[ROW][C]Trimmed Mean ( 12 / 20 )[/C][C]-7.31800765958333[/C][C]18.1831785494557[/C][C]-0.402460309108189[/C][/ROW]
[ROW][C]Trimmed Mean ( 13 / 20 )[/C][C]-8.19350912485294[/C][C]17.0173281471231[/C][C]-0.481480350735207[/C][/ROW]
[ROW][C]Trimmed Mean ( 14 / 20 )[/C][C]-9.47715517015625[/C][C]16.0862159438950[/C][C]-0.58914757847404[/C][/ROW]
[ROW][C]Trimmed Mean ( 15 / 20 )[/C][C]-9.48528735483333[/C][C]15.3297643397274[/C][C]-0.61874971751862[/C][/ROW]
[ROW][C]Trimmed Mean ( 16 / 20 )[/C][C]-9.50320196946429[/C][C]14.6288787832609[/C][C]-0.649619298256699[/C][/ROW]
[ROW][C]Trimmed Mean ( 17 / 20 )[/C][C]-8.45464190942308[/C][C]14.0374088288729[/C][C]-0.602293629293827[/C][/ROW]
[ROW][C]Trimmed Mean ( 18 / 20 )[/C][C]-7.31867816020833[/C][C]13.1810514059528[/C][C]-0.555242365332335[/C][/ROW]
[ROW][C]Trimmed Mean ( 19 / 20 )[/C][C]-6.22445140931818[/C][C]12.7094414026423[/C][C]-0.489750195317325[/C][/ROW]
[ROW][C]Trimmed Mean ( 20 / 20 )[/C][C]-5.27586206625[/C][C]12.0556781614146[/C][C]-0.43762466081219[/C][/ROW]
[ROW][C]Median[/C][C]-7.5793103425[/C][C][/C][C][/C][/ROW]
[ROW][C]Midrange[/C][C]136.4103448[/C][C][/C][C][/C][/ROW]
[ROW][C]Midmean - Weighted Average at Xnp[/C][C]-14.6947719659677[/C][C][/C][C][/C][/ROW]
[ROW][C]Midmean - Weighted Average at X(n+1)p[/C][C]-9.48528735483332[/C][C][/C][C][/C][/ROW]
[ROW][C]Midmean - Empirical Distribution Function[/C][C]-14.6947719659677[/C][C][/C][C][/C][/ROW]
[ROW][C]Midmean - Empirical Distribution Function - Averaging[/C][C]-9.48528735483332[/C][C][/C][C][/C][/ROW]
[ROW][C]Midmean - Empirical Distribution Function - Interpolation[/C][C]-9.48528735483332[/C][C][/C][C][/C][/ROW]
[ROW][C]Midmean - Closest Observation[/C][C]-14.6947719659677[/C][C][/C][C][/C][/ROW]
[ROW][C]Midmean - True Basic - Statistics Graphics Toolkit[/C][C]-9.48528735483332[/C][C][/C][C][/C][/ROW]
[ROW][C]Midmean - MS Excel (old versions)[/C][C]-9.47715517015624[/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=3279&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=3279&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-2.41666889023532e-0937.9248545910749-6.37225617947142e-11
Geometric MeanNaN
Harmonic Mean-341.297583331805
Quadratic Mean291.306335580770
Winsorized Mean ( 1 / 20 )-3.9717241390833435.5935564736646-0.111585481546976
Winsorized Mean ( 2 / 20 )-3.4496551757533.1680099515013-0.104005491459817
Winsorized Mean ( 3 / 20 )-5.7275862107532.0633068172251-0.178633671299088
Winsorized Mean ( 4 / 20 )-8.6475862107530.2468978888948-0.285899937326299
Winsorized Mean ( 5 / 20 )-9.2395402274166629.9890718890809-0.308096904818878
Winsorized Mean ( 6 / 20 )-8.1491954074166727.3530413343878-0.29792648312097
Winsorized Mean ( 7 / 20 )-4.2991954074166626.4511176818311-0.162533601004305
Winsorized Mean ( 8 / 20 )-7.1433333274166723.8595665981857-0.299390741152852
Winsorized Mean ( 9 / 20 )-0.16988506241667322.4930578880878-0.00755277753971563
Winsorized Mean ( 10 / 20 )-2.8445976957521.8711710737238-0.130061517335371
Winsorized Mean ( 11 / 20 )-0.6445976957521.1027423361422-0.0305456838491561
Winsorized Mean ( 12 / 20 )-1.3645976957500020.6819784033940-0.065980036780527
Winsorized Mean ( 13 / 20 )0.70643678924999818.46038991579430.0382677068291816
Winsorized Mean ( 14 / 20 )-9.4202298774166716.7072041153430-0.563842388731315
Winsorized Mean ( 15 / 20 )-9.3598850524166715.4445957356133-0.606029786252932
Winsorized Mean ( 16 / 20 )-16.7732183857514.0363133343071-1.19498745762204
Winsorized Mean ( 17 / 20 )-16.179195404083313.7675172760158-1.17517160717633
Winsorized Mean ( 18 / 20 )-14.540574716083311.5873030140903-1.25487136207639
Winsorized Mean ( 19 / 20 )-12.232183915416711.1573046885047-1.09633861016805
Winsorized Mean ( 20 / 20 )-5.9517241354166610.1150593461582-0.588402295205238
Trimmed Mean ( 1 / 20 )-4.7038049956034533.3646533559103-0.140981683382909
Trimmed Mean ( 2 / 20 )-5.48817734187530.5553677750009-0.179614180470287
Trimmed Mean ( 3 / 20 )-6.6206896563888928.7521280938368-0.230267813039136
Trimmed Mean ( 4 / 20 )-6.9641909816346127.0571549917345-0.257388146823347
Trimmed Mean ( 5 / 20 )-6.459172412925.6917175444885-0.251410689134158
Trimmed Mean ( 6 / 20 )-5.7640804592708324.0395044173412-0.239775344749322
Trimmed Mean ( 7 / 20 )-5.2455772096739122.8365992532842-0.229700453710048
Trimmed Mean ( 8 / 20 )-5.4299373010227321.5654056149359-0.251789249781698
Trimmed Mean ( 9 / 20 )-5.1239737248809520.7014427875147-0.247517710599925
Trimmed Mean ( 10 / 20 )-5.94965516862519.9480970195702-0.298256779219996
Trimmed Mean ( 11 / 20 )-6.4399274011842119.1096220729232-0.336999202632535
Trimmed Mean ( 12 / 20 )-7.3180076595833318.1831785494557-0.402460309108189
Trimmed Mean ( 13 / 20 )-8.1935091248529417.0173281471231-0.481480350735207
Trimmed Mean ( 14 / 20 )-9.4771551701562516.0862159438950-0.58914757847404
Trimmed Mean ( 15 / 20 )-9.4852873548333315.3297643397274-0.61874971751862
Trimmed Mean ( 16 / 20 )-9.5032019694642914.6288787832609-0.649619298256699
Trimmed Mean ( 17 / 20 )-8.4546419094230814.0374088288729-0.602293629293827
Trimmed Mean ( 18 / 20 )-7.3186781602083313.1810514059528-0.555242365332335
Trimmed Mean ( 19 / 20 )-6.2244514093181812.7094414026423-0.489750195317325
Trimmed Mean ( 20 / 20 )-5.2758620662512.0556781614146-0.43762466081219
Median-7.5793103425
Midrange136.4103448
Midmean - Weighted Average at Xnp-14.6947719659677
Midmean - Weighted Average at X(n+1)p-9.48528735483332
Midmean - Empirical Distribution Function-14.6947719659677
Midmean - Empirical Distribution Function - Averaging-9.48528735483332
Midmean - Empirical Distribution Function - Interpolation-9.48528735483332
Midmean - Closest Observation-14.6947719659677
Midmean - True Basic - Statistics Graphics Toolkit-9.48528735483332
Midmean - MS Excel (old versions)-9.47715517015624
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')