This video provides guidance on calculating the Odds Ratio and Relative Risk using Excel and R, as well as explaining the distinction between Odds Ratio and Relative Risk.

Reference:
https://academic.oup.com/aje/article/...
https://www.r-bloggers.com/2014/01/ho...