My Software & Spreadsheets, Psychometrics, R, Statistics, Video

An easy way to simulate data according to a specific structural model.

I have made an easy-to-use Excel spreadsheet that can simulate data according to a latent structure that you specify. You do not need to know anything about R but you’ll need to install it. RStudio is not necessary but it makes life easier. In this video tutorial, I explain how to use the spreadsheet.

This project is still “in beta” so there may still be errors in it. If you find any, let me know.

If you need something with more features and is further along in its development cycle, consider simulating data with the R package simsem.

My Software & Spreadsheets, R

Excel Macro for Making Matrices in R

I am not an open-source purist. I love Excel!

For me it is tedious to make matrices in R from scratch. To save time, I made a simple spreadsheet with a set of VBA macros for making R matrices quickly in Excel. I use it all the time. I hope you find it to be useful.


It is also linked to at my software page.