This video helps you understand how to calculate the residuals and Yates continuity correction for chi square test in Excel and R.