Re: points on a trendline

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Bryan Kelly (noone_at_nowhere.com)
Date: 06/05/04 

Date: Sat, 05 Jun 2004 21:01:48 GMT

The tend lines I am using are never straight and are continuously changing
in slope. The LINEST is far more complicated than what I need.

Thanks for your help.
Bryan

"Jon Peltier" <DOjonNOT@SPAMpeltiertechME.com> wrote in message
news:uQ9B7XxSEHA.2236@TK2MSFTNGP09.phx.gbl...
> Bryan -
>
> The trendline does not have points, as such, since it represents a best
> fit through your data. You can characterize the trendline readily
> enough, though. If it's a straight line, you can use INTERCEPT and SLOPE
> in the worksheet, and knowing these, you can determine Y for any X (and
> vice versa). If it's a poly fit, you can use LINEST according to Bernard
> Liengme's technique:
>
> http://www.stfx.ca/people/bliengme/ExcelTips/Polynomial.htm
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
> Bryan Kelly wrote:
>
> > I have an XY chart with time on the X asis and two or more plots on the
Y
> > axis.
> >
> > Some of the plots are not very smooth so I added a trend line.
> > When I move my cursor to some point on the plot line, I get a
> > little popup window that provides the X and Y coordinates for that
point.
> > When I do this for the trendline, I only get the name of the line. I
want
> > to know the X and Y coordinates of any given point along the trend line.
> > I want to draw a simple vertical line through a given point on the trend
> > line
> > and see where that line intersects the other plots. How do I do this?
> >
> >
> > --
> > Bryan Kelly
> > Time is the medium we use to express out priorities.
> >
> >
>
>

Relevant Pages

  • Re: Buying land: What should you look for?
    ... > For the plots I'm considering, the local power lines either border the ... > slope would hide the house from the road. ... > my previous gardens have been on southern slopes. ... not me - still very slowly terracing the parts that aren't ...
    (misc.rural)
  • Re: Facing a problem with a least-squares line fit...
    ... Imagine a line of pixels that drops from top to ... using a least-squares method to fit a straight line. ... both and plots. ...
    (sci.math)
  • Re: Buying land: What should you look for?
    ... For the plots I'm considering, the local power lines either border the ... The property tends to slope north (with a few gullies ... my previous gardens have been on southern slopes. ... anyone had any experience in terracing wooded country? ...
    (misc.rural)
  • Re: Help with a problem
    ... in that where there are peaks and valleys, ... No...they are not a straight line in any way. ... The plots are not coincident or they are not a straight line. ...
    (sci.math)
  • Re: Compression and PSNR
    ... > Plot PSRN against BPP and compare the plots. ... > my first post even in the curves. ... as differentially (looking at the slope). ... test and rate the streams according to a scale from ... ...
    (sci.image.processing)