Question

How do you calculate R2 in Excel?

Answer 1

0.100443671

Step-by-step explanation:

X. Y

52.16. 157.48

55.23. 164.56

56.74. 152.40

58.12. 150.94

60.67. 170.72

note write it in a box

1. parliament. 2.formula. 3. result parliament CORREL (B3:. 0.316928495

r B7,C3:C7). 0.100443671

R square = r². G3^2 0.100443671

R square used. RSQ(C3:C7,

RSQ. B3:B7)

hope you like the answers

mark me as brinlist