Specify specific cell in the formula

3 visualizaciones (últimos 30 días)
susman
susman el 28 de Sept. de 2020
Respondida: madhan ravi el 28 de Sept. de 2020
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?

Respuesta aceptada

madhan ravi
madhan ravi el 28 de Sept. de 2020
ix = TaBle.Age == 77;
A = TaBle.Age{ix, :} * TaBle.discount_px{ix, :}

Más respuestas (0)

Categorías

Más información sobre Tables en Help Center y File Exchange.

Community Treasure Hunt

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

Start Hunting!

Translated by