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 computationTue, 03 Nov 2009 13:48:25 -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/2009/Nov/03/t1257281451oigp7a57bao7yfn.htm/, Retrieved Wed, 01 May 2024 17:49:39 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=53409, Retrieved Wed, 01 May 2024 17:49:39 +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)
-       [Central Tendency] [workshop 5] [2009-11-03 20:48:25] [6198946fb53eb5eb18db46bb758f7fde] [Current]
Feedback Forum

Post a new message
Dataseries X:
-1,161117667
-1,197361043
-1,268548669
-1,250030129
-1,181498709
-1,145549801
-1,168825331
-1,173996676
-1,21966283
-1,197994422
-1,125711444
-1,14817898
-1,130973126
-1,129059185
-1,092081874
-1,078772911
-1,064417799
-1,076663385
-1,16061239
-1,174213429
-1,172076813
-1,165186586
-1,162032096
-1,175929997
-1,165461265
-1,150610815
-1,127389839
-1,141792203
-1,144400609
-1,160595836
-1,140712871
-1,127403742
-1,126685148
-1,119308039
-1,094290307
-1,102727222
-1,10579285
-1,121051499
-1,127920622
-1,101110572
-1,148561933
-1,167160812
-1,147140226
-1,158269453
-1,171455297
-1,133042108
-1,086516441
-1,155099633
-1,13871362
-1,113433816
-1,120805736
-1,122534785
-1,104960302
-1,057737964
-1,071366872
-1,079073911
-1,072191137
-1,061967969
-1,06658001
-1,066168104




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time3 seconds
R Server'RServer@AstonUniversity' @ vre.aston.ac.uk

\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 & 3 seconds \tabularnewline
R Server & 'RServer@AstonUniversity' @ vre.aston.ac.uk \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=53409&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]3 seconds[/C][/ROW]
[ROW][C]R Server[/C][C]'RServer@AstonUniversity' @ vre.aston.ac.uk[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=53409&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=53409&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 time3 seconds
R Server'RServer@AstonUniversity' @ vre.aston.ac.uk







Central Tendency - Ungrouped Data
MeasureValueS.E.Value/S.E.
Arithmetic Mean-1.135342147666670.00580370590450322-195.623652601992
Geometric MeanNaN
Harmonic Mean-1.13361393659313
Quadratic Mean1.13621700805774
Winsorized Mean ( 1 / 20 )-1.135104005416670.00567493103781164-200.020757583406
Winsorized Mean ( 2 / 20 )-1.134173423116670.00534496078362286-212.194900773044
Winsorized Mean ( 3 / 20 )-1.133177517966670.00506020330357059-223.939128526135
Winsorized Mean ( 4 / 20 )-1.13316275310.0050449128528811-224.614931148486
Winsorized Mean ( 5 / 20 )-1.13223979710.00469547239946247-241.134373876762
Winsorized Mean ( 6 / 20 )-1.13176535240.00458229325673028-246.986669990558
Winsorized Mean ( 7 / 20 )-1.13208684840.00443706386136659-255.143239712426
Winsorized Mean ( 8 / 20 )-1.132339218133330.00437343220793289-258.913174892571
Winsorized Mean ( 9 / 20 )-1.132096388683330.00431820178228829-262.168477936067
Winsorized Mean ( 10 / 20 )-1.133233224350.00405125154771106-279.72423114291
Winsorized Mean ( 11 / 20 )-1.13377139330.0037795420893347-299.975861229150
Winsorized Mean ( 12 / 20 )-1.13388017610.00364566729137061-311.021298839837
Winsorized Mean ( 13 / 20 )-1.1349896650.00332458698598529-341.392681191534
Winsorized Mean ( 14 / 20 )-1.135302791566670.00324998992984844-349.32501825309
Winsorized Mean ( 15 / 20 )-1.135072439066670.00303471146646026-374.029772389081
Winsorized Mean ( 16 / 20 )-1.135050604133330.00296089664094992-383.346918779706
Winsorized Mean ( 17 / 20 )-1.137072382683330.00258951080948459-439.107023040253
Winsorized Mean ( 18 / 20 )-1.138829683383330.00232650023368392-489.503360840004
Winsorized Mean ( 19 / 20 )-1.138567266150.00214362299448029-531.141562243803
Winsorized Mean ( 20 / 20 )-1.137592580483330.0019700572923846-577.441369284427
Trimmed Mean ( 1 / 20 )-1.134383486672410.00537234683711005-211.152317798349
Trimmed Mean ( 2 / 20 )-1.133611502303570.0049924166715669-227.066684709988
Trimmed Mean ( 3 / 20 )-1.133299324074070.00474981144378791-238.598802812746
Trimmed Mean ( 4 / 20 )-1.133346172576920.00459016334296109-246.907590840941
Trimmed Mean ( 5 / 20 )-1.133401198420.00439483938650346-257.893656341725
Trimmed Mean ( 6 / 20 )-1.133691548750.00427112644819056-265.431511452976
Trimmed Mean ( 7 / 20 )-1.134110287086960.00414592954474293-273.547891937772
Trimmed Mean ( 8 / 20 )-1.134504463454550.00402590907059502-281.800816551197
Trimmed Mean ( 9 / 20 )-1.134891114404760.00388522245780008-292.104538860142
Trimmed Mean ( 10 / 20 )-1.1353569020250.00371125240687920-305.922846939889
Trimmed Mean ( 11 / 20 )-1.135692219552630.00355746744471523-319.241774436966
Trimmed Mean ( 12 / 20 )-1.135983253833330.00342620890127459-331.556915111258
Trimmed Mean ( 13 / 20 )-1.136292529970590.00328088360080061-346.337349393715
Trimmed Mean ( 14 / 20 )-1.13648044318750.00317305217536367-358.166327049837
Trimmed Mean ( 15 / 20 )-1.136648679133330.00303685074911938-374.285328135713
Trimmed Mean ( 16 / 20 )-1.136873856285710.00290357641193562-391.542599537733
Trimmed Mean ( 17 / 20 )-1.137136825346150.00272257294604915-417.669920284892
Trimmed Mean ( 18 / 20 )-1.137146302208330.00259078820224923-438.919052210097
Trimmed Mean ( 19 / 20 )-1.136891244454550.00247743488585776-458.898536928014
Trimmed Mean ( 20 / 20 )-1.136626609450.00236110913552488-481.395202088922
Median-1.135877864
Midrange-1.1631433165
Midmean - Weighted Average at Xnp-1.13756925677419
Midmean - Weighted Average at X(n+1)p-1.13664867913333
Midmean - Empirical Distribution Function-1.13756925677419
Midmean - Empirical Distribution Function - Averaging-1.13664867913333
Midmean - Empirical Distribution Function - Interpolation-1.13664867913333
Midmean - Closest Observation-1.13756925677419
Midmean - True Basic - Statistics Graphics Toolkit-1.13664867913333
Midmean - MS Excel (old versions)-1.1364804431875
Number of observations60

\begin{tabular}{lllllllll}
\hline
Central Tendency - Ungrouped Data \tabularnewline
Measure & Value & S.E. & Value/S.E. \tabularnewline
Arithmetic Mean & -1.13534214766667 & 0.00580370590450322 & -195.623652601992 \tabularnewline
Geometric Mean & NaN &  &  \tabularnewline
Harmonic Mean & -1.13361393659313 &  &  \tabularnewline
Quadratic Mean & 1.13621700805774 &  &  \tabularnewline
Winsorized Mean ( 1 / 20 ) & -1.13510400541667 & 0.00567493103781164 & -200.020757583406 \tabularnewline
Winsorized Mean ( 2 / 20 ) & -1.13417342311667 & 0.00534496078362286 & -212.194900773044 \tabularnewline
Winsorized Mean ( 3 / 20 ) & -1.13317751796667 & 0.00506020330357059 & -223.939128526135 \tabularnewline
Winsorized Mean ( 4 / 20 ) & -1.1331627531 & 0.0050449128528811 & -224.614931148486 \tabularnewline
Winsorized Mean ( 5 / 20 ) & -1.1322397971 & 0.00469547239946247 & -241.134373876762 \tabularnewline
Winsorized Mean ( 6 / 20 ) & -1.1317653524 & 0.00458229325673028 & -246.986669990558 \tabularnewline
Winsorized Mean ( 7 / 20 ) & -1.1320868484 & 0.00443706386136659 & -255.143239712426 \tabularnewline
Winsorized Mean ( 8 / 20 ) & -1.13233921813333 & 0.00437343220793289 & -258.913174892571 \tabularnewline
Winsorized Mean ( 9 / 20 ) & -1.13209638868333 & 0.00431820178228829 & -262.168477936067 \tabularnewline
Winsorized Mean ( 10 / 20 ) & -1.13323322435 & 0.00405125154771106 & -279.72423114291 \tabularnewline
Winsorized Mean ( 11 / 20 ) & -1.1337713933 & 0.0037795420893347 & -299.975861229150 \tabularnewline
Winsorized Mean ( 12 / 20 ) & -1.1338801761 & 0.00364566729137061 & -311.021298839837 \tabularnewline
Winsorized Mean ( 13 / 20 ) & -1.134989665 & 0.00332458698598529 & -341.392681191534 \tabularnewline
Winsorized Mean ( 14 / 20 ) & -1.13530279156667 & 0.00324998992984844 & -349.32501825309 \tabularnewline
Winsorized Mean ( 15 / 20 ) & -1.13507243906667 & 0.00303471146646026 & -374.029772389081 \tabularnewline
Winsorized Mean ( 16 / 20 ) & -1.13505060413333 & 0.00296089664094992 & -383.346918779706 \tabularnewline
Winsorized Mean ( 17 / 20 ) & -1.13707238268333 & 0.00258951080948459 & -439.107023040253 \tabularnewline
Winsorized Mean ( 18 / 20 ) & -1.13882968338333 & 0.00232650023368392 & -489.503360840004 \tabularnewline
Winsorized Mean ( 19 / 20 ) & -1.13856726615 & 0.00214362299448029 & -531.141562243803 \tabularnewline
Winsorized Mean ( 20 / 20 ) & -1.13759258048333 & 0.0019700572923846 & -577.441369284427 \tabularnewline
Trimmed Mean ( 1 / 20 ) & -1.13438348667241 & 0.00537234683711005 & -211.152317798349 \tabularnewline
Trimmed Mean ( 2 / 20 ) & -1.13361150230357 & 0.0049924166715669 & -227.066684709988 \tabularnewline
Trimmed Mean ( 3 / 20 ) & -1.13329932407407 & 0.00474981144378791 & -238.598802812746 \tabularnewline
Trimmed Mean ( 4 / 20 ) & -1.13334617257692 & 0.00459016334296109 & -246.907590840941 \tabularnewline
Trimmed Mean ( 5 / 20 ) & -1.13340119842 & 0.00439483938650346 & -257.893656341725 \tabularnewline
Trimmed Mean ( 6 / 20 ) & -1.13369154875 & 0.00427112644819056 & -265.431511452976 \tabularnewline
Trimmed Mean ( 7 / 20 ) & -1.13411028708696 & 0.00414592954474293 & -273.547891937772 \tabularnewline
Trimmed Mean ( 8 / 20 ) & -1.13450446345455 & 0.00402590907059502 & -281.800816551197 \tabularnewline
Trimmed Mean ( 9 / 20 ) & -1.13489111440476 & 0.00388522245780008 & -292.104538860142 \tabularnewline
Trimmed Mean ( 10 / 20 ) & -1.135356902025 & 0.00371125240687920 & -305.922846939889 \tabularnewline
Trimmed Mean ( 11 / 20 ) & -1.13569221955263 & 0.00355746744471523 & -319.241774436966 \tabularnewline
Trimmed Mean ( 12 / 20 ) & -1.13598325383333 & 0.00342620890127459 & -331.556915111258 \tabularnewline
Trimmed Mean ( 13 / 20 ) & -1.13629252997059 & 0.00328088360080061 & -346.337349393715 \tabularnewline
Trimmed Mean ( 14 / 20 ) & -1.1364804431875 & 0.00317305217536367 & -358.166327049837 \tabularnewline
Trimmed Mean ( 15 / 20 ) & -1.13664867913333 & 0.00303685074911938 & -374.285328135713 \tabularnewline
Trimmed Mean ( 16 / 20 ) & -1.13687385628571 & 0.00290357641193562 & -391.542599537733 \tabularnewline
Trimmed Mean ( 17 / 20 ) & -1.13713682534615 & 0.00272257294604915 & -417.669920284892 \tabularnewline
Trimmed Mean ( 18 / 20 ) & -1.13714630220833 & 0.00259078820224923 & -438.919052210097 \tabularnewline
Trimmed Mean ( 19 / 20 ) & -1.13689124445455 & 0.00247743488585776 & -458.898536928014 \tabularnewline
Trimmed Mean ( 20 / 20 ) & -1.13662660945 & 0.00236110913552488 & -481.395202088922 \tabularnewline
Median & -1.135877864 &  &  \tabularnewline
Midrange & -1.1631433165 &  &  \tabularnewline
Midmean - Weighted Average at Xnp & -1.13756925677419 &  &  \tabularnewline
Midmean - Weighted Average at X(n+1)p & -1.13664867913333 &  &  \tabularnewline
Midmean - Empirical Distribution Function & -1.13756925677419 &  &  \tabularnewline
Midmean - Empirical Distribution Function - Averaging & -1.13664867913333 &  &  \tabularnewline
Midmean - Empirical Distribution Function - Interpolation & -1.13664867913333 &  &  \tabularnewline
Midmean - Closest Observation & -1.13756925677419 &  &  \tabularnewline
Midmean - True Basic - Statistics Graphics Toolkit & -1.13664867913333 &  &  \tabularnewline
Midmean - MS Excel (old versions) & -1.1364804431875 &  &  \tabularnewline
Number of observations & 60 &  &  \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=53409&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]-1.13534214766667[/C][C]0.00580370590450322[/C][C]-195.623652601992[/C][/ROW]
[ROW][C]Geometric Mean[/C][C]NaN[/C][C][/C][C][/C][/ROW]
[ROW][C]Harmonic Mean[/C][C]-1.13361393659313[/C][C][/C][C][/C][/ROW]
[ROW][C]Quadratic Mean[/C][C]1.13621700805774[/C][C][/C][C][/C][/ROW]
[ROW][C]Winsorized Mean ( 1 / 20 )[/C][C]-1.13510400541667[/C][C]0.00567493103781164[/C][C]-200.020757583406[/C][/ROW]
[ROW][C]Winsorized Mean ( 2 / 20 )[/C][C]-1.13417342311667[/C][C]0.00534496078362286[/C][C]-212.194900773044[/C][/ROW]
[ROW][C]Winsorized Mean ( 3 / 20 )[/C][C]-1.13317751796667[/C][C]0.00506020330357059[/C][C]-223.939128526135[/C][/ROW]
[ROW][C]Winsorized Mean ( 4 / 20 )[/C][C]-1.1331627531[/C][C]0.0050449128528811[/C][C]-224.614931148486[/C][/ROW]
[ROW][C]Winsorized Mean ( 5 / 20 )[/C][C]-1.1322397971[/C][C]0.00469547239946247[/C][C]-241.134373876762[/C][/ROW]
[ROW][C]Winsorized Mean ( 6 / 20 )[/C][C]-1.1317653524[/C][C]0.00458229325673028[/C][C]-246.986669990558[/C][/ROW]
[ROW][C]Winsorized Mean ( 7 / 20 )[/C][C]-1.1320868484[/C][C]0.00443706386136659[/C][C]-255.143239712426[/C][/ROW]
[ROW][C]Winsorized Mean ( 8 / 20 )[/C][C]-1.13233921813333[/C][C]0.00437343220793289[/C][C]-258.913174892571[/C][/ROW]
[ROW][C]Winsorized Mean ( 9 / 20 )[/C][C]-1.13209638868333[/C][C]0.00431820178228829[/C][C]-262.168477936067[/C][/ROW]
[ROW][C]Winsorized Mean ( 10 / 20 )[/C][C]-1.13323322435[/C][C]0.00405125154771106[/C][C]-279.72423114291[/C][/ROW]
[ROW][C]Winsorized Mean ( 11 / 20 )[/C][C]-1.1337713933[/C][C]0.0037795420893347[/C][C]-299.975861229150[/C][/ROW]
[ROW][C]Winsorized Mean ( 12 / 20 )[/C][C]-1.1338801761[/C][C]0.00364566729137061[/C][C]-311.021298839837[/C][/ROW]
[ROW][C]Winsorized Mean ( 13 / 20 )[/C][C]-1.134989665[/C][C]0.00332458698598529[/C][C]-341.392681191534[/C][/ROW]
[ROW][C]Winsorized Mean ( 14 / 20 )[/C][C]-1.13530279156667[/C][C]0.00324998992984844[/C][C]-349.32501825309[/C][/ROW]
[ROW][C]Winsorized Mean ( 15 / 20 )[/C][C]-1.13507243906667[/C][C]0.00303471146646026[/C][C]-374.029772389081[/C][/ROW]
[ROW][C]Winsorized Mean ( 16 / 20 )[/C][C]-1.13505060413333[/C][C]0.00296089664094992[/C][C]-383.346918779706[/C][/ROW]
[ROW][C]Winsorized Mean ( 17 / 20 )[/C][C]-1.13707238268333[/C][C]0.00258951080948459[/C][C]-439.107023040253[/C][/ROW]
[ROW][C]Winsorized Mean ( 18 / 20 )[/C][C]-1.13882968338333[/C][C]0.00232650023368392[/C][C]-489.503360840004[/C][/ROW]
[ROW][C]Winsorized Mean ( 19 / 20 )[/C][C]-1.13856726615[/C][C]0.00214362299448029[/C][C]-531.141562243803[/C][/ROW]
[ROW][C]Winsorized Mean ( 20 / 20 )[/C][C]-1.13759258048333[/C][C]0.0019700572923846[/C][C]-577.441369284427[/C][/ROW]
[ROW][C]Trimmed Mean ( 1 / 20 )[/C][C]-1.13438348667241[/C][C]0.00537234683711005[/C][C]-211.152317798349[/C][/ROW]
[ROW][C]Trimmed Mean ( 2 / 20 )[/C][C]-1.13361150230357[/C][C]0.0049924166715669[/C][C]-227.066684709988[/C][/ROW]
[ROW][C]Trimmed Mean ( 3 / 20 )[/C][C]-1.13329932407407[/C][C]0.00474981144378791[/C][C]-238.598802812746[/C][/ROW]
[ROW][C]Trimmed Mean ( 4 / 20 )[/C][C]-1.13334617257692[/C][C]0.00459016334296109[/C][C]-246.907590840941[/C][/ROW]
[ROW][C]Trimmed Mean ( 5 / 20 )[/C][C]-1.13340119842[/C][C]0.00439483938650346[/C][C]-257.893656341725[/C][/ROW]
[ROW][C]Trimmed Mean ( 6 / 20 )[/C][C]-1.13369154875[/C][C]0.00427112644819056[/C][C]-265.431511452976[/C][/ROW]
[ROW][C]Trimmed Mean ( 7 / 20 )[/C][C]-1.13411028708696[/C][C]0.00414592954474293[/C][C]-273.547891937772[/C][/ROW]
[ROW][C]Trimmed Mean ( 8 / 20 )[/C][C]-1.13450446345455[/C][C]0.00402590907059502[/C][C]-281.800816551197[/C][/ROW]
[ROW][C]Trimmed Mean ( 9 / 20 )[/C][C]-1.13489111440476[/C][C]0.00388522245780008[/C][C]-292.104538860142[/C][/ROW]
[ROW][C]Trimmed Mean ( 10 / 20 )[/C][C]-1.135356902025[/C][C]0.00371125240687920[/C][C]-305.922846939889[/C][/ROW]
[ROW][C]Trimmed Mean ( 11 / 20 )[/C][C]-1.13569221955263[/C][C]0.00355746744471523[/C][C]-319.241774436966[/C][/ROW]
[ROW][C]Trimmed Mean ( 12 / 20 )[/C][C]-1.13598325383333[/C][C]0.00342620890127459[/C][C]-331.556915111258[/C][/ROW]
[ROW][C]Trimmed Mean ( 13 / 20 )[/C][C]-1.13629252997059[/C][C]0.00328088360080061[/C][C]-346.337349393715[/C][/ROW]
[ROW][C]Trimmed Mean ( 14 / 20 )[/C][C]-1.1364804431875[/C][C]0.00317305217536367[/C][C]-358.166327049837[/C][/ROW]
[ROW][C]Trimmed Mean ( 15 / 20 )[/C][C]-1.13664867913333[/C][C]0.00303685074911938[/C][C]-374.285328135713[/C][/ROW]
[ROW][C]Trimmed Mean ( 16 / 20 )[/C][C]-1.13687385628571[/C][C]0.00290357641193562[/C][C]-391.542599537733[/C][/ROW]
[ROW][C]Trimmed Mean ( 17 / 20 )[/C][C]-1.13713682534615[/C][C]0.00272257294604915[/C][C]-417.669920284892[/C][/ROW]
[ROW][C]Trimmed Mean ( 18 / 20 )[/C][C]-1.13714630220833[/C][C]0.00259078820224923[/C][C]-438.919052210097[/C][/ROW]
[ROW][C]Trimmed Mean ( 19 / 20 )[/C][C]-1.13689124445455[/C][C]0.00247743488585776[/C][C]-458.898536928014[/C][/ROW]
[ROW][C]Trimmed Mean ( 20 / 20 )[/C][C]-1.13662660945[/C][C]0.00236110913552488[/C][C]-481.395202088922[/C][/ROW]
[ROW][C]Median[/C][C]-1.135877864[/C][C][/C][C][/C][/ROW]
[ROW][C]Midrange[/C][C]-1.1631433165[/C][C][/C][C][/C][/ROW]
[ROW][C]Midmean - Weighted Average at Xnp[/C][C]-1.13756925677419[/C][C][/C][C][/C][/ROW]
[ROW][C]Midmean - Weighted Average at X(n+1)p[/C][C]-1.13664867913333[/C][C][/C][C][/C][/ROW]
[ROW][C]Midmean - Empirical Distribution Function[/C][C]-1.13756925677419[/C][C][/C][C][/C][/ROW]
[ROW][C]Midmean - Empirical Distribution Function - Averaging[/C][C]-1.13664867913333[/C][C][/C][C][/C][/ROW]
[ROW][C]Midmean - Empirical Distribution Function - Interpolation[/C][C]-1.13664867913333[/C][C][/C][C][/C][/ROW]
[ROW][C]Midmean - Closest Observation[/C][C]-1.13756925677419[/C][C][/C][C][/C][/ROW]
[ROW][C]Midmean - True Basic - Statistics Graphics Toolkit[/C][C]-1.13664867913333[/C][C][/C][C][/C][/ROW]
[ROW][C]Midmean - MS Excel (old versions)[/C][C]-1.1364804431875[/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=53409&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=53409&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-1.135342147666670.00580370590450322-195.623652601992
Geometric MeanNaN
Harmonic Mean-1.13361393659313
Quadratic Mean1.13621700805774
Winsorized Mean ( 1 / 20 )-1.135104005416670.00567493103781164-200.020757583406
Winsorized Mean ( 2 / 20 )-1.134173423116670.00534496078362286-212.194900773044
Winsorized Mean ( 3 / 20 )-1.133177517966670.00506020330357059-223.939128526135
Winsorized Mean ( 4 / 20 )-1.13316275310.0050449128528811-224.614931148486
Winsorized Mean ( 5 / 20 )-1.13223979710.00469547239946247-241.134373876762
Winsorized Mean ( 6 / 20 )-1.13176535240.00458229325673028-246.986669990558
Winsorized Mean ( 7 / 20 )-1.13208684840.00443706386136659-255.143239712426
Winsorized Mean ( 8 / 20 )-1.132339218133330.00437343220793289-258.913174892571
Winsorized Mean ( 9 / 20 )-1.132096388683330.00431820178228829-262.168477936067
Winsorized Mean ( 10 / 20 )-1.133233224350.00405125154771106-279.72423114291
Winsorized Mean ( 11 / 20 )-1.13377139330.0037795420893347-299.975861229150
Winsorized Mean ( 12 / 20 )-1.13388017610.00364566729137061-311.021298839837
Winsorized Mean ( 13 / 20 )-1.1349896650.00332458698598529-341.392681191534
Winsorized Mean ( 14 / 20 )-1.135302791566670.00324998992984844-349.32501825309
Winsorized Mean ( 15 / 20 )-1.135072439066670.00303471146646026-374.029772389081
Winsorized Mean ( 16 / 20 )-1.135050604133330.00296089664094992-383.346918779706
Winsorized Mean ( 17 / 20 )-1.137072382683330.00258951080948459-439.107023040253
Winsorized Mean ( 18 / 20 )-1.138829683383330.00232650023368392-489.503360840004
Winsorized Mean ( 19 / 20 )-1.138567266150.00214362299448029-531.141562243803
Winsorized Mean ( 20 / 20 )-1.137592580483330.0019700572923846-577.441369284427
Trimmed Mean ( 1 / 20 )-1.134383486672410.00537234683711005-211.152317798349
Trimmed Mean ( 2 / 20 )-1.133611502303570.0049924166715669-227.066684709988
Trimmed Mean ( 3 / 20 )-1.133299324074070.00474981144378791-238.598802812746
Trimmed Mean ( 4 / 20 )-1.133346172576920.00459016334296109-246.907590840941
Trimmed Mean ( 5 / 20 )-1.133401198420.00439483938650346-257.893656341725
Trimmed Mean ( 6 / 20 )-1.133691548750.00427112644819056-265.431511452976
Trimmed Mean ( 7 / 20 )-1.134110287086960.00414592954474293-273.547891937772
Trimmed Mean ( 8 / 20 )-1.134504463454550.00402590907059502-281.800816551197
Trimmed Mean ( 9 / 20 )-1.134891114404760.00388522245780008-292.104538860142
Trimmed Mean ( 10 / 20 )-1.1353569020250.00371125240687920-305.922846939889
Trimmed Mean ( 11 / 20 )-1.135692219552630.00355746744471523-319.241774436966
Trimmed Mean ( 12 / 20 )-1.135983253833330.00342620890127459-331.556915111258
Trimmed Mean ( 13 / 20 )-1.136292529970590.00328088360080061-346.337349393715
Trimmed Mean ( 14 / 20 )-1.13648044318750.00317305217536367-358.166327049837
Trimmed Mean ( 15 / 20 )-1.136648679133330.00303685074911938-374.285328135713
Trimmed Mean ( 16 / 20 )-1.136873856285710.00290357641193562-391.542599537733
Trimmed Mean ( 17 / 20 )-1.137136825346150.00272257294604915-417.669920284892
Trimmed Mean ( 18 / 20 )-1.137146302208330.00259078820224923-438.919052210097
Trimmed Mean ( 19 / 20 )-1.136891244454550.00247743488585776-458.898536928014
Trimmed Mean ( 20 / 20 )-1.136626609450.00236110913552488-481.395202088922
Median-1.135877864
Midrange-1.1631433165
Midmean - Weighted Average at Xnp-1.13756925677419
Midmean - Weighted Average at X(n+1)p-1.13664867913333
Midmean - Empirical Distribution Function-1.13756925677419
Midmean - Empirical Distribution Function - Averaging-1.13664867913333
Midmean - Empirical Distribution Function - Interpolation-1.13664867913333
Midmean - Closest Observation-1.13756925677419
Midmean - True Basic - Statistics Graphics Toolkit-1.13664867913333
Midmean - MS Excel (old versions)-1.1364804431875
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')