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)