Difference between revisions of "Manuals/calci/TRIMMEAN"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''TRIMMEAN'''</font></font></font><font color="#...") |
|||
| (10 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''TRIMMEAN (Array,Percent)'''</div><br/> |
| + | *<math>Array </math> is the array of values to find trim and average . | ||
| + | *<math> Percent </math> is the fractional number of data points. | ||
| + | **TRIMMEAN(), returns the mean of the interior of a data set. | ||
| − | + | ==Description== | |
| + | *This function gives the truncated mean of a given set of points. | ||
| + | *Trimmean is a measure of mean that indicates the central tendancy of a set of values. | ||
| + | *Trimmean is also called truncated mean. | ||
| + | *It is the method of finding average that removes a small percentage of the largest and smallest values before calculating the mean. | ||
| + | *In <math> TRIMMEAN (Array,Percent), Array</math> is the array of values to calculate the trimmed mean.p is the fractional number that we want to remove from the given set of numbers. | ||
| + | *For e.g., if Percent=0.2 for the 20 points data set, then to calculate the <math> TRIMMEAN </math> it will exclude 4 points(20*0.2) from the data set, 2 numbers from lowest value and 2 numbers from highest value. | ||
| + | *Also this function rounds the number of excluded data points down to the nearset multiple of 2. | ||
| + | *If Percent=0.1 for the 30 points data set, then it should exclude (30*0.1) 3 points from the data set. But it will remove one number from top and one number from bottom, so it will exclude only 2 numbers instead of 3 numbers. | ||
| + | This function will give the result as error when p<0 or p>1 | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | ==Examples== | |
| − | + | {| class="wikitable" | |
| − | + | |+Spreadsheet | |
| − | + | |- | |
| − | + | ! !! A !! B !! C !! D!! E !! F !! G !! H !! I !! J !! K !! L | |
| − | + | |- | |
| − | + | ! 1 | |
| − | + | | 14 || 18 || 21 ||19 || 20 || 23 || 8 || 10 || 7 || 18 || 12 || 11 | |
| − | + | |} | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | #=TRIMMEAN(A1:L1,0.2) = 15.1 | |
| + | #=TRIMMEAN(A1:L1,0.4) = 15.25 | ||
| + | #=TRIMMEAN(A1:L1,0.1) = 15.083333333333334 | ||
| + | #=TRIMMEAN(A1:L1,0) = 15.083333333333334 | ||
| − | + | ==Related Videos== | |
| − | + | {{#ev:youtube|K6mil72rNo8|280|center|TRIM MEAN}} | |
| − | + | ==See Also== | |
| + | *[[Manuals/calci/AVERAGE |AVERAGE ]] | ||
| + | *[[Manuals/calci/GEOMEAN | GEOMEAN ]] | ||
| + | *[[Manuals/calci/HARMEAN | HARMEAN ]] | ||
| + | *[[Manuals/calci/MEDIAN | MEDIAN ]] | ||
| − | + | ==References== | |
| + | *[http://www.virtualnerd.com/middle-math/probability-statistics/mean-median-mode-range/mean-data-set-definition Mean] | ||
| − | |||
| − | |||
| − | |||
| − | + | *[[Z_API_Functions | List of Main Z Functions]] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | *[[ Z3 | Z3 home ]] | |
| − | |||
Latest revision as of 16:27, 8 August 2018
TRIMMEAN (Array,Percent)
- is the array of values to find trim and average .
- is the fractional number of data points.
- TRIMMEAN(), returns the mean of the interior of a data set.
is the array of values to find trim and average .
is the fractional number of data points.
Description
- This function gives the truncated mean of a given set of points.
- Trimmean is a measure of mean that indicates the central tendancy of a set of values.
- Trimmean is also called truncated mean.
- It is the method of finding average that removes a small percentage of the largest and smallest values before calculating the mean.
- In is the array of values to calculate the trimmed mean.p is the fractional number that we want to remove from the given set of numbers.
- For e.g., if Percent=0.2 for the 20 points data set, then to calculate the it will exclude 4 points(20*0.2) from the data set, 2 numbers from lowest value and 2 numbers from highest value.
- Also this function rounds the number of excluded data points down to the nearset multiple of 2.
- If Percent=0.1 for the 30 points data set, then it should exclude (30*0.1) 3 points from the data set. But it will remove one number from top and one number from bottom, so it will exclude only 2 numbers instead of 3 numbers.
is the array of values to calculate the trimmed mean.p is the fractional number that we want to remove from the given set of numbers.
it will exclude 4 points(20*0.2) from the data set, 2 numbers from lowest value and 2 numbers from highest value.This function will give the result as error when p<0 or p>1
Examples
| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 14 | 18 | 21 | 19 | 20 | 23 | 8 | 10 | 7 | 18 | 12 | 11 |
- =TRIMMEAN(A1:L1,0.2) = 15.1
- =TRIMMEAN(A1:L1,0.4) = 15.25
- =TRIMMEAN(A1:L1,0.1) = 15.083333333333334
- =TRIMMEAN(A1:L1,0) = 15.083333333333334
Related Videos
See Also
References