Measures of Central Tendency - Mean, Median, and Mode of values with specific text in the next column
Our take
Hello, I have been trying to find a formula or function where values will be picked and converted through measures of central tendency (Mean, Median, Mode) if the next column of the same row matches a specific keyword, i.e. "Yes", "No". In my case, I am using the types "Witch" and "Normal". I have provided a small example of what I'm supposed to find. The data provided represent a few skins from a small game I like that I am trying to analyze.
I am still new to Excel 2019, and I am using a laptop to do my work. My tries for Mean, (I did random stuff and hoping it would work)=ROUND(AVERAGEIF(J3:J73,COUNTIF(K3:K73, "Witch"),0)) return an equation error and =DAVERAGE(J3:J73,"Cost","Witch") (this feels like it is not appropriate to the situation) return to an error of value.
I will probably use this formula/function (if provided), on more tasks that include "types".
Edit: I found an answer for the Mean by myself. I'm still finding a solution for Median and Mode, unfortunately.
=ROUND(AVERAGEIF(range of type,"=type",range of data),0)
I'm now only wondering for the Median and the Mode, which do not have a MEDIANIF or a MODEIF in the function list.
Edit 2: I accidentally mislabeled Excel 2019 as Excel 2013, sorry about that.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience