Solved Slope Function is Negetive but Forecast is Positive

August 21, 2013 at 00:47:06
Specs: Windows 7
Hello

Can anyone explain why I am getting a negetive slope yet the forecast date to reach '80' (as below) is 8th Feb 13? for me the forecast should never reach 80 as the slope is negetive!

A B
1 Aug-2012
2 Sep-2012
3 Oct-2012
4 Nov-2012
5 Dec-2012
6 Jan-2013 55
7 Feb-2013 66
8 Mar-2013 58
9 Apr-2013 57
10
11
12 80 08-Feb-13 =FORECAST(A12,A1:A9,B1:B9)
13
14 Slope -0.314285714 =SLOPE(A1:A9,B1:B9)

I have added the data and the equations i used - hope it helps.


See More: Slope Function is Negetive but Forecast is Positive

Report •

#1
August 21, 2013 at 10:29:10
✔ Best Answer
Have never used the SLOPE() function, but try making cells B1 thru B5 zeros and see what happens.


EDIT ADDED;

See the Remarks section on this page:

http://office.microsoft.com/en-us/e...


MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •
Related Solutions


Ask Question