Скачать или смотреть Beta Distribution functions | Using Excel for Epidemiology Quantitative Risk Analysis | Follow Along

This is a follow along video for how to use Excel in quantitative risk assessment if you're doing an epidemiology course, etc. Thanks to my lecturer for providing the questions (unbeknowst to him. I have changed some numbers so that it's not exactly a copy and paste).
You can use the functions that are within Excel, no add-ins required.
Hopefully it helps someone in their epi/stats course.

Beta (alpha, beta) or (alpha1, alpha2)
alpha1 = r+1
beta=alpha2= n-r+1
where r= number of observed events, and n= number of trials
Can be used to calculate the true prevalence of something. It's more sophisticated than just r/n (eg 18/100 = 18%).
Excel Beta.dist(x,alpha,beta,cumulative)
where x is the prevalence. For example, 0.05 =5%. This is where you use the table.

Any questions, please comment.

For an overview of some discrete probability distribution functions, go here:    • Overview of Some Discrete Probability Dist...   (no relationship, it's just a good video). Maybe at some point I'll make my own little explainer video.