Calculating percent of data in table

150 views (last 30 days)
BN
BN on 28 Apr 2020
Commented: Tommy on 29 Apr 2020
I have a 1x12 table, Is there any quick way or function to find percentage for each column based on total?
for example:
data = (1,2,3)
percent first = (1*100)/(1+2+3) = 16.66 %
percent two = (2*100)/(1+2+3) = 33.33 %
  2 Comments
Adam Danz
Adam Danz on 28 Apr 2020
"I have a 1x12 table,"
So you have a table with 1 column? The rest of your question sounds like you have >1 column.
BN
BN on 29 Apr 2020
I'm sorry you right; I have a table like this:

Sign in to comment.

Accepted Answer

Tommy
Tommy on 28 Apr 2020
For the following table:
T = table;
T.data = randi(10,1,12);
you can use:
T.percentages = 100 * T.data ./ sum(T.data);
which gives:
>> T.data
ans =
10 1 9 2 5 3 2 3 9 10 4 9
>> T.percentages
ans =
14.9254 1.4925 13.4328 2.9851 7.4627 4.4776 2.9851 4.4776 13.4328 14.9254 5.9701 13.4328
and to be sure:
>> sum(T.percentages)
ans =
100
  2 Comments
BN
BN on 29 Apr 2020
Thank you, It workes great. I forgot to attach a sample, Did you know-how about when I have such a data set?
I tried to change the code to works, but always I got an error
'operator '*' is not supported for operands of type 'table'
Thanks again
Tommy
Tommy on 29 Apr 2020
For that table, you could use { } indexing to obtain the cells within and then cell2mat to convert to a double array:
arr = cell2mat(data{1,:});
percentages = 100 * arr ./ sum(arr);

Sign in to comment.

More Answers (0)

Tags

Products


Release

R2020a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!