+ Reply to Thread
Results 1 to 16 of 16

Trendline

Hybrid View

JamieTabone Trendline 03-13-2015, 08:59 AM
mcmahobt Re: Trendline 03-13-2015, 09:09 AM
JamieTabone Re: Trendline 03-13-2015, 09:48 AM
mcmahobt Re: Trendline 03-13-2015, 09:56 AM
JamieTabone Re: Trendline 03-13-2015, 10:02 AM
mcmahobt Re: Trendline 03-13-2015, 10:18 AM
JamieTabone Re: Trendline 03-13-2015, 10:22 AM
mcmahobt Re: Trendline 03-13-2015, 10:26 AM
JamieTabone Re: Trendline 03-13-2015, 10:39 AM
mcmahobt Re: Trendline 03-13-2015, 10:55 AM
MrShorty Re: Trendline 03-13-2015, 11:12 AM
mcmahobt Re: Trendline 03-13-2015, 11:23 AM
JamieTabone Re: Trendline 03-13-2015, 11:23 AM
JamieTabone Re: Trendline 03-13-2015, 11:34 AM
mcmahobt Re: Trendline 03-13-2015, 11:42 AM
JamieTabone Re: Trendline 03-13-2015, 11:56 AM
  1. #1
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Trendline

    I think there's a few things to consider before taking this route and using the results for your analysis:

    1) Excel does not natively allow chart trendlines to go through the origin because that inherently takes away the point of a trendline - to match the data given. If your trendline is behaving poorly, this is usually a result of poor data (or rather, poor instrumentation). It is important to note that by altering a trendline to go through the origin fundamentally alters the forecasting capabilities of the trendline, whereby you degrade what the capability is actually used for.

    2) It is not uncommon when testing empirical data that you void the first few samples of data while the test runs. This is to reduce noise and obtain precise results. By inspection, it appears this is what the case is with your data, so I would recommend starting with row 4 data in your sample workbook instead of row 2.

    3) Ultimately, since this is your data and not mine, I can only give recommendations; after all as far as you know, I'm just some schlub on the internet. If you are truly set on creating a trendline through the origin, I know LINEST can be used, albeit through some manipulation. This link describes a similar process I have used: http://www.oooforum.org/forum/viewto...ight=trendline

    Hope this helps!
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

  2. #2
    Registered User
    Join Date
    03-13-2015
    Location
    Malta
    MS-Off Ver
    2007
    Posts
    17

    Re: Trendline

    Hi thanks for the reply. My idea is to determine which set of points is closest to linear. Do you recommend another method rather than this method to determine which setup scales linearly with increasing load? I mean does for example the R^2 value show me how close to linear my points are?

    Thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel 2010 Trendline With Data labels or number on forward forecast trendline
    By camelight in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 10-15-2015, 08:35 AM
  2. Replies: 0
    Last Post: 10-11-2011, 03:22 PM
  3. Trendline - Which one to use
    By tyb in forum Excel General
    Replies: 4
    Last Post: 02-08-2011, 09:23 AM
  4. [SOLVED] trendline
    By PB in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-21-2006, 10:25 AM
  5. [SOLVED] Trendline
    By Carter in forum Excel General
    Replies: 0
    Last Post: 01-20-2006, 08:50 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1