Dunno, I might be doing something dumb, but that isn't plotting as a circle for me - the left and right 'halves' don't appear to meet in the middle, being at 0 and 10 'x' units at the tangent to the axis for an R of 5.
Edit:
Ok I was doing something dumb - plotting the x-y graph using only the first 10 x values, and all 20 calculated y values - excel assumes that x=count(x) if there is no valid value, so it was displacing entries 11-20 to the right.
However:
I still think his formula isn't going to give what he describes - he is saying it gives a circle tangent to the x-axis and with the centre at '0,R', but I plot the curve(s) as a circle tangent to 'x' and with a centre at '0,-R'
The correct form for what he describes would be x^2+(y-R)^2 = R^2
Last edited by Lieste; 04/22/12 06:32 AM. Reason: Goof in Excel.