View original (French)

Circular regression with excel/calc

foufou -  
 PhDVirge -
Hello,

I have a set of points (x; y) that form a semblance of a circular arc. I would like to know if we can find the center and the radius of this circle?
Thank you in advance.

Configuration: Windows XP / Firefox 3.0.19

1 answer

  1. PhDVirge
     
    Hello,

    yes, it is possible to do that in Excel.
    Here is a link to a very interesting site that provides an Excel resource for calculating the average radius in the least squares sense (generally the one used by subcontractors in metrology) and also with a mini-max criterion.
    http://sti.ac-orleans-tours.fr/spip/article.php3?id_article=717

    Hoping that this is what you were looking for!
    0