Cross tabulation row percentages

2 Ansichten (letzte 30 Tage)
Sarah Yun
Sarah Yun am 31 Dez. 2019
Bearbeitet: TADA am 31 Dez. 2019
Hello,
I have a table with 4 columns and 5 rows
I want to display the row values as percentages
example
date sale 1 sale 2 total sales
1989 4 (x%) 3 (x%) 7(x%)
7 would be 100%
now express 4 and 3 in terms of 100%?
How to do this for my table in matlab?
Thank you.

Akzeptierte Antwort

TADA
TADA am 31 Dez. 2019
Bearbeitet: TADA am 31 Dez. 2019
How about something like that?
t{:,{'sale1','sale2'}} = t{:,{'sale1','sale2'}}./t.totalsales * 100
Given that t is your table, or a copy of that so you don't override your original data

Weitere Antworten (0)

Kategorien

Mehr zu Tables finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by