Create a Markov Chain Monte Carlo simulation Gibbs sampler in Excel

In my two previous posts I discussed how to create a Gibbs sampler in both Python and R.

1. The post for the Python Gibbs sampler can be read here:- https://medium.com/@tracyrenee61/create-a-monte-carlo-simulation-gibbs-sampler-in-python-e1f0b05663b6
2. The post for the R Gibbs sampler can be read here:- https://tracyrenee61.medium.com/create-a-monte-carlo-simulation-gibbs-sampler-in-r-20a42c0563b4

In this blog post I intend to discuss how to create a Markov Chain Monte Carlo (MCMC) simulation Gibbs sampler in Excel.

The first thing that I did was to open a blank page on the Excel workbook that I have been working on and labelling the different columns and cells:-

1. Column A is labeled Iteration
2. Column B is labelled X
3. Column C is labelled Y
4. Column D is labelled Random Normal X
5. Column E is labelled Random Normal Y

After labelling the columns, I will enter the data in the cells:-

In cells A2, B2, and C2 I will enter the value 0.

In cell D2 and E2 I will enter the formula that will create a random number between 0 and 1, with a mean of 0 and a standard deviation…