This spreadsheet is intended as an example to demonstrate how the Metropolis Hastings algorithm can be implemented within microsoft Excel to undertake Bayesian inference. If you are considering programming the Metropolis Hastings algorithm in another language/modelling package this example may be useful for you. This example uses a very simple state transition model (with 3 states) and uses data observations of persons in State B and persons moving to Stage C. This structure and approach can be extended to a larger more complex model and with more parameters and datasets. This spreadsheet may be a useful illustration of the process of the MH algorithm for those considering programming this algorithm in another package. Warning! This...