The above response was on the basis that you have all dx and lx values given. If it is not, in exam it is not possible. If you want to do it separately and you have sufficient time, then please enter the values and do. If you have dx and lx values present with you, entire life tables can be created at any interest rate.
Very helpful. Thanks for the video.
Glad to know you found it useful.
what about the variance calculation. You have not shown in this video anywhere while explaining
How to create a formula book to a spreadsheet for dx and lx
Hi Muthu
You can get px from lx, and then qx is 1-px. You can get npx as well. And then calculate any value at any interest rate.
@@actuarialscienceclasses we will type in excel all lx values? But we have deficit time to type all values
The above response was on the basis that you have all dx and lx values given.
If it is not, in exam it is not possible. If you want to do it separately and you have sufficient time, then please enter the values and do.
If you have dx and lx values present with you, entire life tables can be created at any interest rate.