I recently ran some simulation analyses for a multi-level randomized control trial design in a separate programming software and generated the results. Briefly, the design has a level of clustering at the individual-level and cluster-level. I calculated the power given different combinations of number of clusters and individuals.
Number of clusters Cluster size Intervention coefficient Estimated power
3 5 5 0.4474474
3 10 5 0.7377377
3 15 5 0.8538539
3 20 5 0.9489489
3 25 5 0.982983
6 5 5 0.7127127
6 10 5 0.956957
6 15 5 0.995996
6 20 5 0.997998
6 25 5 1
What I am wondering is whether it would be possible to plot a power curve given those results, with power on the y-axis, number of clusters on the x-axis, and separate curves for the number of individuals per cluster.

I took a look at some of the commands that are available and the power command seems like a potential candidate: https://blog.stata.com/2019/01/10/ca...-1-the-basics/. However, I am not sure that it accommodates my current situation where I am bringing in results from external to Stata.

Is this something that is workable?

Version: Stata 15.1