Re: Problem related to a linear regression

On 2 Nov., 18:20, Ray Koopman <koop...@xxxxxx> wrote:
In the first regression, you minimized error along the Y axis, but
in the second you switched to minimizing along the (rescaled) X axis.
Perhaps you should look into "orthogonal distance" regression,
which accomodates error on both axes simultaneously.

I think to see your point. The situation with the same physical
parameter on the x and y axis, only differing between observed (Y) and
estimated (Xf), makes me really confused. To me the y-values seem to
be 'fix'. Wouldn't it therefore be sufficient to find the x-values
(Xf) which best fit y=x? But then I'm again there what I have already
done by minimising (Y-Xf)^2 .... It really looks like I have to follow
your recommendation.

Thank you for your hint. Hopefully I manage to get this done with
Excel.

.

Relevant Pages

  • Re: Placing shapes exactly on charts.
    ... the X & Y axes. ... Dim cht As Chart ... Dim aX As Axis, aY As Axis ...
    (microsoft.public.excel.charting)
  • Re: XY Chart Improvements For Scientific Data
    ... > chart against the same x-axis. ... Why does Excel limit the number of y axes ... There is enough room for 4 axes by using both sides of each axis line ...
    (microsoft.public.excel.charting)
  • Re: Really understanding the Rattleback
    ... When resting on a flat surface, if it is given a push to make it rotate around its point of surface contact, it has the characteristic of moving smoothly in that direction of rotation but if given a push to rotate in the other direction, it will start to turn but then, with a rocking motion, come to a stop and begin rotating in the direction it somehow prefers. ... Take something rectangular like a pack of cards or cigarette packet, ideally something with uniform mass distribution and the 3 axes different lengths. ... even one tumble on the intermediate axis is enough to have it coming down rotated partly on another axis. ... Unfortunately since this is a rectangle it would need to be pivoted and attached to pivot with a couple of springs, or a curved surface added and rocked on the ground. ...
    (rec.puzzles)
  • Re: Switch Primary and Secondary Y Axes
    ... secondary axis, and put the secondary Y axis on the left. ... new one with the series in the order and on the axes you need. ... the old chart. ... Jon Peltier, Microsoft Excel MVP ...
    (microsoft.public.excel.charting)
  • Re: combination x-y scatter and column graph
    ... the columns (double click on the series, then use the Axis tab). ... I would have expected OE to interact better with Excel and Word than ... > You can share axes. ... > Add this data to the chart as a new series, ...
    (microsoft.public.excel.charting)