Subtracting mean from table column and creating new Column with solution

Hey guys,

I'm new to matlab and stuck:

I have 30x10 table and I'm trying to do the following:

I'm attempting to take the values from column 5 and subract them from the mean of column 10.

I've already calculated the mean but I'm struggling to figure out how i can calculate the value of each individual row and subract it from the mean and add it a new column row in one function.

Would that be possible?

Thanks guys

Answer 1

[Walter Roberson]

t.NewColumn = mean(t{:,10}) - t{:,5};

[Tarun bhalla]

hey, perfect it worked thanks so much

Answer 2

[M.Many]

%M = rand(30,10); 
%T = array2table(M)
T{:,11}= mean(T{:,10})-T{:,5} % Replace T by your Table

[Walter Roberson]

Note: the column that is introduced will be named 'Var11' unless there is an existing 'Var11', in which case it will be named 'Var11_' followed by a digit.

[M.Many]

True, thanks for the additional note.

[Tarun bhalla]

thanks for the help, it worked! thnakyou