Excel Linear Trendline Query

Excel Help for Excel Linear Trendline Query in Analyzing Corporate Financial Data

Excel Linear Trendline Query

Rate this: (3/5 from 1 vote)

	Hi All, I have the below values on an excel scatter plot graph. I can draw a linear trendline through the values by right clicking on a value, hitting “Add Trendline” and hitting “Linear”. What I would prefer is to have the values of the linear trendline written on my spreadsheet as at the times of each entry. (ie fill in below “Linear Trendline Value” row). Does anyone know if this can be done? If not, can anyone suggest an alternative method that would give approximately what I am looking for? Does anyone have any alternative suggestions? All help will be greatly appreciated, no matter how small. Thanks in Advance for all responses. (Unable to attach Scatter Plot Graph) Time 1 2.5 4 4.75 7.2 7.9 8.5 Value 2 5 4 3 7 4 9 Linear Trendline Value
	frcrilly
	Posted by frcrilly on 20 Feb 2011

Replies - Displaying 1 to 1 of 1

Order Replies By: Most Recent | Chronological | Highest Rated

	Use SLOPE and INTERCEPT functions Rate this: (4/5 from 2 votes) You can calculate the values under the liner trand line by using the SLOPE and INTERCEPT functions in Excel. This will enable you to calculate the linear trend line value of Value for each Time observation.
	Excel Business Forums Administrator
	Posted by Excel Helper on 20 Feb 2011

Displaying page 1 of 1