+ Reply to Thread
Results 1 to 3 of 3

Using a transition matrix as input to a cummulative matrix

  1. #1
    Registered User
    Join Date
    08-24-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    35

    Using a transition matrix as input to a cummulative matrix

    Hi,

    I have a cummulative matrix (based on the help from a previous thread) which I use for deciding the probability of a program switching between values, but I'd like to use a simpler transition matrix as input (as people understand that a bit better).

    Currently I have a matrix that looks like:

    Please Login or Register  to view this content.
    Which I use to determine the probability of switching between r1, r2 and r3.

    I'd like a user to be able to input three values

    Probability when in Regime 1 of staying in Regime 1
    Probability when in Regime 2 of staying in Regime 2
    Probability when in Regime 3 of staying in Regime 3

    And to calculate the corresponding probabilities as input to my cumulative matrix. Trouble is, I'm stuck on the math of how to do this.
    Last edited by Walter12; 10-26-2012 at 04:05 AM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,081

    Re: Matrices

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    08-24-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    35

    Re: Using a transition matrix as input to a cummulative matrix

    So my input matrix should look like:

    Please Login or Register  to view this content.
    Which would feed into my cummulative matrix to look like:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1