trend analysis

Joe C

Well-known Member
Joined
Oct 17, 2002
Messages
841
I am doing some sales projections. And one of the basic models I was looking to use is the linear trend analysis.
When I do a chart I can find the pick the linear equation. But I need to do this for quite a few different lines. On over forty different charts. I was hoping to use the function that is used to create the linear trend line. Is that the Linest function or the trend function or another function I can use.
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
8,010
Office Version
  1. 365
With two variables (one dependent and one independent), consider using either LINEST as an array formula (you have to select two cells, set the third argument of LINEST to TRUE or 1, and enter with CTRL+SHIFT+ENTER to see both the slope and the intercept) or just the SLOPE and INTERCEPT formulas to return the equation in pieces.
 

Joe C

Well-known Member
Joined
Oct 17, 2002
Messages
841
I didn't get the exact results and odly the chart intercept was 200000, where my constant was 233838. Does the chart round for visual purposes.
 

Forum statistics

Threads
1,136,878
Messages
5,678,305
Members
419,753
Latest member
Sallylwy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top