Intercept and Slope Function

[bancanus]

The output of Intercept and Slope function is not what I expected.

=INTERCEPT(A2:A113,B2:B113)	497.167
=SLOPE(A2:A113,B2:B113)	-0.01124

<colgroup><col><col></colgroup><tbody>
</tbody>

I expect to see Intercept around 12.558, slope around -0.0102

Am I missing something?

X	Y
16-Jan-2018	13.705
17-Jan-2018	12.929
18-Jan-2018	12.281
19-Jan-2018	13.058
20-Jan-2018	12.152
21-Jan-2018	12.152
22-Jan-2018	13.446
23-Jan-2018	13.446
24-Jan-2018	12.087
25-Jan-2018	12.022
26-Jan-2018	12.815
27-Jan-2018	13.317
28-Jan-2018	13.187
29-Jan-2018	12.022
30-Jan-2018	12.411
31-Jan-2018	11.893
1-Feb-2018	11.634
2-Feb-2018	11.893
2-Feb-2018	11.893
2-Feb-2018	13.446
2-Feb-2018	13.187
2-Feb-2018	11.893
2-Feb-2018	11.893
2-Feb-2018	11.763
3-Feb-2018	13.187
4-Feb-2018	12.411
5-Feb-2018	12.281
6-Feb-2018	12.67
7-Feb-2018	11.893
8-Feb-2018	13.187
9-Feb-2018	11.634
10-Feb-2018	11.634
11-Feb-2018	13.317
12-Feb-2018	12.929
13-Feb-2018	12.67
14-Feb-2018	11.634
15-Feb-2018	11.634
16-Feb-2018	12.411
17-Feb-2018	12.022
18-Feb-2018	11.634
19-Feb-2018	11.634
20-Feb-2018	11.634
21-Feb-2018	12.152
22-Feb-2018	11.569
23-Feb-2018	11.375
24-Feb-2018	11.634
24-Feb-2018	11.893
25-Feb-2018	11.634
25-Feb-2018	11.893
26-Feb-2018	11.634
27-Feb-2018	11.44
28-Feb-2018	11.893
1-Mar-2018	11.505
2-Mar-2018	12.022
3-Mar-2018	11.505
4-Mar-2018	11.634
5-Mar-2018	12.281
6-Mar-2018	11.634
7-Mar-2018	11.505
8-Mar-2018	11.375
9-Mar-2018	12.152
10-Mar-2018	12.67
11-Mar-2018	11.375
12-Mar-2018	11.505
13-Mar-2018	11.375
14-Mar-2018	11.116
15-Mar-2018	11.375
16-Mar-2018	12.67
17-Mar-2018	11.116
18-Mar-2018	12.799
19-Mar-2018	11.505
20-Mar-2018	11.505
21-Mar-2018	11.505
22-Mar-2018	12.929
23-Mar-2018	12.67
24-Mar-2018	12.022
25-Mar-2018	11.634
26-Mar-2018	11.763
27-Mar-2018	11.634
28-Mar-2018	12.152
29-Mar-2018	12.67
30-Mar-2018	11.116
31-Mar-2018	12.152
1-Apr-2018	11.262
2-Apr-2018	11.31
3-Apr-2018	11.893
4-Apr-2018	11.375
5-Apr-2018	11.116
6-Apr-2018	11.375
7-Apr-2018	11.634
8-Apr-2018	12.799
9-Apr-2018	11.375
10-Apr-2018	11.246
10-Apr-2018	11.246
10-Apr-2018	12.767
11-Apr-2018	12.799
11-Apr-2018	11.375
12-Apr-2018	11.634
12-Apr-2018	12.67
13-Apr-2018	11.375
14-Apr-2018	11.246
15-Apr-2018	11.116
16-Apr-2018	11.165
17-Apr-2018	11.246
18-Apr-2018	11.634
19-Apr-2018	11.505
20-Apr-2018	12.67
21-Apr-2018	12.411
22-Apr-2018	11.116
23-Apr-2018	11.375
24-Apr-2018	11.116
25-Apr-2018	11.116

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[DRSteele]

The slope is going to be in units of X. Since your X is dates (i.e., Excel Dates), the number might look strange.

When I applied the formulas you show to your data, I got an intercept of 43423.233 and a slope of -21.5666, which are wrong. When I reverse the Xs and Ys, and applied =INTERCEPT(B2:B113,A2:A113) it reported 497.262, and =SLOPE(B2:B113,A2:A113) reported -0.01124

I graphed the data and included a linear trend line with the equation shown on the chart and that is exactly what it reports: Y=-.0112x+497.26