Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Toronto, CANADA.
    Posts
    292
    Thanks
    21
    Thanked 3 Times in 3 Posts
    hello everyone;

    i have a simple table in excel (office 2003), and am interested to extrapolate to (let's say, year 2020) using the equation of the linear trendline.
    if i select to plot line with dotted points (top graph), i get one trendline equation, but if i select to plot from XY scatter, i get another trendline equation !!!!!
    both plots of data are similar (seem rather identical), in pattern, however the difference?

    any help?

    TIA.

    daniel rozenberg

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    This is discusses in more detail in the thread
    http://lounge.windowssecrets.com/ind...owtopic=778704

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •