Create an rng object with np.random.default_rng(), you can seed it for reproducible results. You can draw samples from probability distributions, including from the binomial and normal distributions.

While Excel is ubiquitous, I prefer Python for my data analysis. Spreadsheets are great for formatting data, but it's Python that's allowed me to build my own super calculator out of regular Python ...