How do I calculate the coefficient of determination (R²) in Excel?

You can use the RSQ() function to calculate in Excel. If your dependent variable is in column A and your independent variable is in column B, then click any blank cell and type “RSQ(A:A,B:B)”.