Specify specific cell in the formula

1 次查看（过去 30 天）
susman
susman 2020-9-28
回答： madhan ravi 2020-9-28
I am working with mortality tables and my question is how can I specific a specific cell (e.g. the value of the variable discount_px when the age is 77)?
I have created this table containing four variables (Age, qx, px, discount_px)
Age qx px discount_px
75 0.038258 1 1
76 0.042116 0.96174 0.95602
77 0.046321 0.92124 0.91031
78 0.050916 0.87856 0.86298
79 0.055988 0.83383 0.81417
80 0.061493 0.78715 0.76402
If my formula is:
A = Age * (discount_px for age 77)
my outcome should be:
A = 77*0.91031
How can I specific in the formula that discount_px should take the value for age = 77?

请先登录，再回答此问题。

采纳的回答

madhan ravi
madhan ravi 2020-9-28
ix = TaBle.Age == 77;
A = TaBle.Age{ix, :} * TaBle.discount_px{ix, :}

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by