Specify specific cell in the formula
조회 수: 1 (최근 30일)
이전 댓글 표시
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?
댓글 수: 0
채택된 답변
madhan ravi
2020년 9월 28일
ix = TaBle.Age == 77;
A = TaBle.Age{ix, :} * TaBle.discount_px{ix, :}
댓글 수: 0
추가 답변 (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!