How to do Sensitivity Analysis with data in a table?
Show older comments
Hello together,
I importet data into Matlab from an excel file and created new columns as follows:
...
t.X1 = ((t.currentassets - t.currentliabilities) ./ t.totalassets);
t.X2 = (t.retainedearnings ./ t.totalassets);
t.X3 = (t.ebit ./ t.totalassets);
t.X4 = (t.marketvalueofequity ./ t.totalliabilities);
t.X41 = (t.bookvalueofequity ./ t.totalliabilities);
t.X5 = (t.revenue ./ t.totalassets);
t.Z1 = ((1.2*t.X1)+(1.4*t.X2)+(3.3*t.X3)+(0.6*t.X)+(0.999*t.X5));
t.Z2 = ((0.717*t.X1)+(0.847*t.X2)+(3.107*t.X3)+(0.42*t.X41)+(0.998*t.X5));
t.Z3 = ((6.56*t.X1)+(3.26*t.X2)+(6.72*t.X3)+(1.05*t.X4));
Now I want to do a sensitivity analysis and /or identify elements in my input set that heavily influence the Z scores.
Has anyone an idea how to approach this problem?
Thank you for your help!
Answers (0)
Categories
Find more on Tables in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!