The output of Intercept and Slope function is not what I expected.
<colgroup><col><col></colgroup><tbody>
</tbody>
I expect to see Intercept around 12.558, slope around -0.0102
Am I missing something?
<colgroup><col><col></colgroup><tbody>
</tbody>
=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>