MAS 1 – Excel Matrix Functions

Home Forums CAS Exams MAS 1 – Excel Matrix Functions

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #4976
    Chris Bellwood
    Participant

    Can anyone tell me whether you can use the mmult(), minverse(), and mdeterm() functions on the Excel spreadsheet you get at Pearson?

    I’ve been spending all this time learning how to calculate inverse matrices or stationary probabilities for Markov chains by hand.  But I just found out that Excel has a handful of matrix functions.  The Pearson website has a link to a ‘Spreadsheet Function List’ workbook (https://home.pearsonvue.com/Clients/Casualty-Actuarial-Society-(CAS).aspx), and those functions appear there.  I’m crossing my fingers they’re genuinely available – I’d love it if someone could confirm.

    If you can invert the transition probability matrix for a transient class, you could easily pull out all the time in transient state values.  And if you can multiply matrices repeatedly, you could quickly bypass calculating stationary probabilities by hand by just repeatedly squaring the transition probability matrix until it converges.  HECK, you could do that with gambler’s ruin problems as well without remembering that silly formula or first principles.  Squaring the matrix repeatedly would converge toward ruin or winning based on any state you begin in.  I’m sure there are numerous other applications.

    It would be exciting!

    -TDD

    #4993
    Dante
    Participant

    Go to this website:

    https://home.pearsonvue.com/Clients/Casualty-Actuarial-Society-(CAS).aspx

    At the bottom of the page, you’ll find: “SAMPLE SPREADSHEET”. Test your formulas in there to see if you can use it in the exam.

    Hope this helps.

     

     

    #5002
    Chris Bellwood
    Participant

    They work!  Thanks.  It didn’t occur to me that the workbook with that function list was what you’d actually be provided.

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.