Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



What is the TREND in Excel?

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 13-03-2010
Member
 
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
Reply With Quote
  #2  
Old 13-03-2010
Member
 
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.
Reply With Quote
  #3  
Old 13-03-2010
Member
 
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.
Reply With Quote
  #4  
Old 13-03-2010
Member
 
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.
Reply With Quote
  #5  
Old 13-03-2010
Member
 
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.
Reply With Quote
  #6  
Old 13-03-2010
Member
 
Join Date: May 2008
Posts: 4,343
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.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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


All times are GMT +5.5. The time now is 06:30 PM.