Mean and Standard deviation table
26 views (last 30 days)
Show older comments
Cheuk Yin Wong
on 20 Aug 2022
Edited: the cyclist
on 20 Aug 2022
I have a table "cal_table" and it looks like this:
I would like to find the mean and standard deviation of each 'cal0_05mM', 'cal0_03mM', ..., 'cal0_50mM' by teh three 'Rep'. What is the quickest way to do it?
Thank you very muuch.
0 Comments
Accepted Answer
Image Analyst
on 20 Aug 2022
Edited: Image Analyst
on 20 Aug 2022
m = reshape(cal_table.Var2, 3, []); % Get 3-by-5 matrix.
means = mean(m, 1) % Get means of each column
sds = std(m, 1) % Get standard deviations
0 Comments
More Answers (1)
the cyclist
on 20 Aug 2022
1 Comment
the cyclist
on 20 Aug 2022
Edited: the cyclist
on 20 Aug 2022
To be more specific, you can do the one-liner
groupsummary(cal_table,Var1,["mean","std"])
Here is an example, related to the one in the documentation:
% Some data
Gender = ["male";"female";"female";"male";"male"];
Age = [38;43;38;40;49];
Height = [71;69;64;67;64];
Weight = [176;163;131;133;119];
T = table(Gender,Age,Height,Weight)
% Get the mean and std
groupsummary(T,"Gender",["mean","std"])
See Also
Categories
Find more on Resizing and Reshaping Matrices in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!