How to center data into a new column but only for specific conditions based on other columns?

schou1994 — Fri, 09 Jun 2023 22:06:11 GMT

Hi all,

I want to center my data. But the problem is I only want to adjust the data with an average of it's respective category. For example, see table below. What if in the "age adjusted" col, I want the age column data but subtracted by the average of only the age data that has the same "city" and "gender" category?

So each age for "san francisco" and "male" would be subtracted by average of 1,2,3 = 2. The formula for new col "center" will use the average including every age in the entire column, right? So that won't work for me..

Thanks!!

Re: How to center data into a new column but only for specific conditions based on other columns?

txnelson — Mon, 15 Feb 2021 01:18:40 GMT

The formula to use is

:Age - Col Mean( :Age, :City, :Gender )

The data table with the formula is attached

The Col Mean() formula is documented in the Scripting Index available under the Help pull down menu

topic Re: How to center data into a new column but only for specific conditions based on other columns? in Discussions

How to center data into a new column but only for specific conditions based on other columns?

Re: How to center data into a new column but only for specific conditions based on other columns?