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.
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.