trimmean

Hi. Stumped on this for a while. I would like to find all the values of an item in a range like a sort of index-match, then find the trimmed mean of those values, and repeat this process for each of the other items in the range. Attached is a sample sheet showing what i would like. Would be...

I would like to apply TRIMMEAN on 6 cells, discounting 2 of them and using the middle 4. I am getting 'too many arguments' returned. Could someone please advise how I can fix this.

Hey there, Context: I want to remove the top and bottom 3% of outliers from the AVERAGE V7 of a YouTube channel that has "BR" in its name Excel keeps wanting to multiply the trimmean and my averageif function together..... how can I edit it to *NOT* do that?

Hi everyone, I am trying to calculate a "conditional" trimmed mean where I only get the trimmed mean for that data within a dataset that meets certain criteria; in this example, data that falls within certain intervals. I have attached a mini-sheet to illustrate what I mean. I want to be able...

I have the following Data: Amount |Date | Spread for a large set of data. I know how to use TRIMMEAN but i am not sure how to incorporate multiple conditions. i.e I would like to use trimmean to looked at Amounts >=100 &<=500, and Dates >= 01/01/2021 &<=12/31/21, and return the mean Spread...

Good afternoon, I have built with power query a list of payments made for the last 4 years to employee's. I am trying to calculate the bi-weekly average salary of those 10 000 employee's based on 2 criteria's. For each employee / fiscal year, I want to find the average bi-weekly payment. I want...

Hi, I'm having issues with the below. I'm trying to trimmean the weeks where the weekly number is greater than 5. I want to trim the mean to then exclude the top /bottom 10%. Below is the formula I currently have which I cannot get to work. Any help is greatly appreciated. Thanks...

Dear All, I would like to compute average removing top & bottom 10% of the data points. Following is the sample data set across A1:A10. <tbody> 10 18 37 9 58 6 65 100 46 58 </tbody> Average of the data set is 40.7 and the trimmean is also yielding the same result. Could some...

=IFERROR(TRIMMEAN(F29:F41,AF46)/4,"Not 3Q yet this formula works once I have more data. would like to have in each back a month but when I use the "<="& (specified cell) it looks like the /4 in the formula causes bad data

I have used TRIMMEAN in the past and thought I had the correct results from it. Only yesterday I was working on some data and wanted to use TRIMMEAN to always remove a fixed number of data points from arrays that are variable in size, i.e. one might have 257, the next 150. So, to create the...

I have a trimmean formula that looks at data daily and the result is set up to measure quarterly. at the beginning of each quarter the info is not reliable as there is insufficient data. I was thinking if a took the results of the past quarter and added it to the current quarter the first few...

I have a range for b2:b53 I only want to count the values/number if greater than 0 and then trimmean the same range with .2 =countif(b2:b53,>0(trimmean(b2:b53,0.2))) does not work

In the table below the first column is my data, the second and third are what I want. Any ideas how to do this would be really appreciated.:biggrin: Basically I want to find consecutive blocks of 4 or more numbers within the #N/As and copy these. I then want to use TRIMMEAN on each block to trim...

Hi everyone. Does anyone have any idea how I can bypass the problem of using an array formula when I use the trimmean with criteria? The excel is already extremely slow and the array just blocks it completely Thanks, Rui

Hi everyone; I would like to apply trimmean in Pivot table where there are tens of thousands records in the raw data.. I will appreciate any kind of help.

Hi, I'm trying to get the trimmean of filtered rows. For an unfiltered worksheet this is my equation: =TRIMMEAN(Q2:Q3478;0.05)

Hey Everyone . . . I have the following AVERAGEIFS formula in my workbook: =IFERROR(AVERAGEIFS(Data!$A:$A,Data!$J:$J,"="&CONCATENATE(TRIM($B$3)," - ",TRIM(Orders!$C3)),Data!$K:$K,">="&Orders!$H$1,Data!$K:$K,"<="&Orders!$I$1),0) The purpose is to average a number set if a string matches and the...