Home Forums CAS Exams MAS 1 – Excel Matrix Functions

Viewing 4 posts - 1 through 4 (of 4 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.

          #5924
          Richar Petersen
          Participant

            Ahaha. Also had a similar situation, but a neighbor helped.

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