Kč - Kč ( ) - Kč - Kč Kč - Kč Kč - Kč Kč - Kč £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ € - € - € / / / / € - € Kč - Kč Kč - Kč Kč - Kč Kč - Kč - - - - - - Kč - Kč - Kč - - Kč - Kč - Kč : : : : Yes Yes No True True False On On Off ¥€ ( € ) € - € $ ($ ) € - € € - € € € - € € - € - - € - € - € - - € - € - € $ ($ ) $ ($ ) $ ($ ) ( ) - $ $ ( ) $ - $ $ ( ) $ - € ( € ) \ \- \ \- \ \- \ \- \ \ - \ - - - \ \ - \ - - - - - - - $ $( ) $- ( ) - $ $( ) $- ( ) - % % % % % % % % % % € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € % % % % % % $ ( $ ) % % - % - - - £ - £ £ - £ % - % DM - DM DM - DM DM - DM DM - DM - - DM - DM - DM - - DM - DM - DM Ouch! - - Error detected! - Result=0 - No Errordetection / / / / £ -£ £ -£ £ -£ £ -£ - - £ -£ £ - - - £ -£ £ - ￥ - ￥ DM - DM DM - DM DM - DM DM - DM DM - DM € € - tan aa zł - zł € - € : : : : € - € € - € ( ) - $ $ ( ) $ - ( ) - $ $ ( ) $ - € ( € ) ok ERR! - - Kč - Kč - Kč - - Kč - Kč - Kč ¥€ ( € ) / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) - : : : ( ) % ( ) - ( ) - ( ) - ( ) - . . : : : . . : - - - - € - € € - € € - € € - € : : : € € - € € - € € - € € - - - - - - - : : : : : : - - : - - - - - - € € - € - - - € € - € - % / / ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 TRIMMEAN Function Result TRUE Sheet Result Description 1 TRUE Simple TRIMMEAN formulas with local references and values Function Expected Correct FunctionString Comment 0.1 10 1 0 Data Data 0.428037407575175 Data 6.406 6.406 TRUE =TRIMMEAN(F1:H11,0.3) 0.15 11 2 0 Known y Known x 1.959999998 0.613157133804634 4 3.27777775 3.27777775 TRUE =TRIMMEAN(L3:M9,0.11) 0.2 12 3 0 0.2222222 6 60 0.7015356332995 5 6 6 TRUE =TRIMMEAN(H1:H11,0.876876) 0.25 13 4 0 0.3333333 5 0.287494882242754 6 0.478000198025256 0.478000198025256 TRUE =TRIMMEAN(P1:P147,0.999) 0.3 14 5 0 0.4444444 11 0.923478921176866 7 0.484078499721363 0.484078499721363 TRUE =TRIMMEAN(P2:P148,0.999) 0.35 15 6 0 0.5555555 7 0.88321171887219 2 0.478000198025256 0.478000198025256 TRUE =TRIMMEAN(P3:P149,0.999) 0.4 16 7 0 0.6666666 5 0.322987567167729 3 0.476555340108462 0.476555340108462 TRUE =TRIMMEAN(P4:P150,0.999) 0.45 17 8 0 0.7777777 4 0.775013547856361 4 0.478000198025256 0.478000198025256 TRUE =TRIMMEAN(P5:P151,0.999) 0.5 18 9 0 0.8888888 4 0.533890031743795 5 0.476555340108462 0.476555340108462 TRUE =TRIMMEAN(P6:P152,0.999) 0.55 19 10 0 0.432337608654052 1 0.475110482191667 0.475110482191667 TRUE =TRIMMEAN(P7:P153,0.999) 0.6 20 11 0 0.10197188751772 2 0.476555340108462 0.476555340108462 TRUE =TRIMMEAN(P8:P154,0.999) 0.578687170520425 3 0 0 TRUE =TRIMMEAN(I1:I11,0.1) 0.249721248168498 14.375 14.375 TRUE =TRIMMEAN(G1:H15,0) 0.038235686253756 3.77777777777778 3.77777777777778 TRUE =TRIMMEAN(R2:R12,0.2) 113 1 0.947824243456125 3.8 3.8 TRUE =TRIMMEAN(R3:R13,0) 0.455013483995572 Err:502 Err:502 TRUE =TRIMMEAN(R4:R14,1) 0.061197097180411 Err:502 Err:502 TRUE =TRIMMEAN(R3:R13,-0.1) 0.449839030392468 0.370711832074448 0.07212695479393 0.619594122748822 0.085561456857249 0.858265824383125 0.505418746965006 0.478000198025256 0.706537288846448 0.647787393536419 0.776952794287354 0.441515020793304 0.864095453638583 0.721034815069288 0.942395994905382 0.503092921804637 0.847577476641163 0.662739022402093 0.31001410773024 0.754221505019814 0.001932042185217 0.14824030129239 0.770368037512526 0.293067518621683 0.721363060409203 0.112736901268363 0.345345019828528 0.056516982382163 0.361136565217748 0.687323835212737 0.844827393768355 0.567412803182378 0.100358453812078 0.806944488547742 0.848200620384887 0.085844192886725 0.152985031483695 0.588032728526741 0.095765714300796 0.96469741826877 0.375671569257975 0.568094410467893 0.870021975133568 0.383305652532727 0.443571952171624 0.390713890315965 0.83348875050433 0.610691022826359 0.873526824405417 0.692671614000574 0.203585381619632 0.97190298163332 0.184534667991102 0.260669856797904 0.114571255864576 0.051331446506083 0.49015680141747 0.051554169971496 0.080958649516106 0.106666516046971 0.626548473257571 0.359317126683891 0.811918098246679 0.301586508518085 0.430325179127976 0.684382091276348 0.497180418344215 0.1561807426624 0.625914257252589 0.498825493967161 0.211415824946016 0.382650278043002 0.023624769877642 0.266696691978723 0.425630041630939 0.110045405570418 0.135502940276638 0.694719796767458 0.516613601474091 0.860969963949174 0.680290438467637 0.64871264481917 0.636798569699749 0.27627738751471 0.061029309174046 0.309554810402915 0.729876630939543 0.269375436240807 0.001218413701281 0.10137957171537 0.220534205669537 0.288944094441831 0.990035076625645 0.234927677782252 0.369254975346848 0.453993153525516 0.114271270576864 0.838228513719514 0.498653427232057 0.616912558907643 0.508684072410688 0.691113546956331 0.017472143750638 0.546913750004023 0.615149507299066 0.020004767226055 0.954222638625652 0.80043240217492 0.266802230849862 0.370156505843624 0.876022383803502 0.408789443550631 0.829616361996159 0.425812249770388 0.596236804965884 0.982345527270809 0.549413459375501 0.000796383246779 0.745137969730422 0.890825515845791 0.890886812238023 0.056855289964005 0.594005641294643 0.152216844726354 0.586123846936971 0.341561996610835 0.067640593275428 0.511174611747265 0.475110482191667 0.701962394407019