Question: how to calculate r squared in excel?
Answer: In cell G3, enter the formula =CORREL(B3:B7,C3:C7)
In cell G4, enter the formula =G3^2.
In cell G5, enter the formula =RSQ(C3:C7,B3:B7)