+ Reply to Thread
Results 1 to 2 of 2

Documentation on TREND function argument , constant

  1. #1
    Registered User
    Join Date
    08-28-2019
    Location
    Montreal
    MS-Off Ver
    2013
    Posts
    9

    Documentation on TREND function argument , constant

    Hello

    I have seen some examples of the TREND function with different values of the constant (last argument of trend function)

    e.g. TREND(A1:A2,,1) TREND(A1:A2,,2) TREND(A1:A2,,3) or any other integer

    The outcome is quite different depending on the value of the constant ! It seems to do some kind of forecast.

    The only documentation I can find is that this value should either be true or false and controls the b=0 value in the trend equation y = ax +b

    Can anyone guide me to an explanation what this trend function does when putting an integer as argument in the constant.

    Thanks

    Canadane

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Documentation on TREND function argument , constant

    I think you are confusing the "new_x" argument (3rd argument in the TREND() function) and the "constant" argument (4th argument). The integer (1, 2, 3) in each of your examples is the 3rd "new_x" argument, which tells the TREND() function at what x value to evaluate y=mx+b. The optional "constant" 4th argument is omitted, so Excel defaults to TRUE, so your examples are equivalent to TREND(A1:A2,,1,TRUE)

    It sounds like the results you are seeing are correct, you are just confused about which argument is the "constant" argument.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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] is there a possibility to use a constant as named argument in a function call
    By AEberli in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-04-2019, 11:28 AM
  2. [SOLVED] MATCH function workaround/documentation
    By johnnymac in forum Excel General
    Replies: 3
    Last Post: 02-01-2017, 02:33 PM
  3. Replies: 7
    Last Post: 01-07-2015, 06:29 AM
  4. [SOLVED] ByRef argument type mismatch / Passing array as a function argument
    By pzling in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-29-2012, 06:23 PM
  5. Replies: 1
    Last Post: 10-01-2012, 09:50 AM
  6. Extracting Constant from Non-linear Trend line
    By tomsan82 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-16-2006, 08:00 AM
  7. Function (array argument, range argument, string argument) vba
    By Witek in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-24-2005, 11:07 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