Results 1 to 6 of 6

Thread: What is the TREND in Excel?

  1. #1
    Join Date
    Aug 2006
    Posts
    148

    What is the TREND in Excel?

    Hi friends,
    I have just started with the advanced part of an excel. And now I am doing some of the statistical functions that are included in the Excel. In that I have a note on Trend. But the information is very less to understand that function. So I thought that there might be someone who would be interested in helping me.!! Please tell me what is the TREND in Excel? Hope that you got what I want to ask.?!
    The Gaming Machine:
    Processor: Core 2 Duo E6400
    Motherboard: Asus P5W DH Deluxe
    RAM: 2GB XMS2 Corsair PC2-6400
    Video: ATI Radeon X1900XT 512MB w/ Arctic Accellero
    Drive: 74GB "WD Raptor" 10000RPM
    Sound: Creative SoundBlaster X-Fi
    Watercooling: *Soon* Zalman Reserator

  2. #2
    Join Date
    May 2008
    Posts
    353

    Re: What is the TREND in Excel?

    TREND is evaluated by calling the function for the LINEST. Major changes to LINEST in Excel 2003 and in later versions of Excel are summarized and their implications are reflected in the trend. The statistical functions in Microsoft Excel 2004 for Macintosh were updated using the same algorithms Excel 2003 and later versions of Excel. After calculating the regression model best fit (by calling function essentially LINEST Excel), a trend returns predicted values associated new_x 's.

  3. #3
    Join Date
    May 2008
    Posts
    376

    Re: What is the TREND in Excel?

    The TREND function (known_y, known_x, new_x 's constant) is used to perform linear regression. A test result of least squares is used and trendy attempts to find the best fit under that criterion. Represent known_y 's data "dependent variable" and known_x represent data on one or more independent variables. The help file describes tendency rare cases where the second or third argument may be omitted.

  4. #4
    Join Date
    Apr 2008
    Posts
    2,139

    Re: What is the TREND in Excel?

    If the last argument "constant" is set to TRUE, you want the model to include a regression coefficient of the intercept in the regression model. If the last argument is set to FALSE, no term intersection is included and the fitted regression is forced through the origin. The last argument is optional and if omitted it is interpreted as the value is TRUE. TREND effectively calls LINEST executes LINEST, using regression coefficients output LINEST in calculating the values therein associated with each line new_x 's and presents this column predicted y values for you. Therefore, you need to know about problems in the execution of LINEST.

  5. #5
    Join Date
    Sep 2005
    Posts
    1,306

    Re: What is the TREND in Excel?

    The following is the Syntax of the TREND :
    • TREND(known_y's, known_x's, new_x's, constant)

    The arguments, known_y, known_x and new_x 's must be arrays or cell ranges with associated dimensions. If known_y occupies one column by m rows, then known_x columns are in rows c m where c is greater than or equal to one. Note that c is the number of predictor variables, m is the number of data points. Must then be new_x 's column c row r where r is greater than or equal to.

  6. #6
    Join Date
    May 2008
    Posts
    4,348

    Re: What is the TREND in Excel?

    Using current trend includes two ranges of cells that contain data such as trend (A1: A100, B1: F100, B101: F108, TRUE). Note that because several predictor variables usually causes the second argument in this example contains multiple columns. In this example, there are a hundred issues, value of a dependent variable (known_y ') for each subject and the dependent variable values of five (known_x) for each subject. There are eight additional hypothetical subjects where you want to use to calculate the trend values therein.

Similar Threads

  1. Need help to calculate Trend Growth in Microsoft Excel
    By New!life in forum MS Office Support
    Replies: 2
    Last Post: 21-02-2012, 01:22 PM
  2. Uninstall TREND without the password?
    By Chad Gross in forum Small Business Server
    Replies: 5
    Last Post: 12-08-2011, 06:48 PM
  3. How TREND interacts with LINEST in Excel?
    By Vandam in forum Windows Software
    Replies: 5
    Last Post: 13-03-2010, 03:31 AM
  4. Trend micro vs AVG
    By Taipai in forum Networking & Security
    Replies: 3
    Last Post: 01-07-2009, 11:58 AM
  5. Trend ChipAwayVirus(R) On Guard ?
    By KaSaRa in forum AntiVirus Software
    Replies: 2
    Last Post: 14-05-2008, 08:53 PM

Posting Permissions

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