Hi, I am trying to work out the coefficient of determination of r. I am able to compute it using the spreadsheet but I don’t know how to work it out manually. My data is as follows:

X – 0.01; 0.00; 0.01; 0.02; 0.03; 0.04; 0.05

Y - ; 200; 2000; 4100; 6200; 8300; 10,300

The coefficient of determination generated by excel was 1.