Intercept and Slope Function

bancanus

New Member
Joined
Apr 26, 2018
Messages
2
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?


XY
16-Jan-201813.705
17-Jan-201812.929
18-Jan-201812.281
19-Jan-201813.058
20-Jan-201812.152
21-Jan-201812.152
22-Jan-201813.446
23-Jan-201813.446
24-Jan-201812.087
25-Jan-201812.022
26-Jan-201812.815
27-Jan-201813.317
28-Jan-201813.187
29-Jan-201812.022
30-Jan-201812.411
31-Jan-201811.893
1-Feb-201811.634
2-Feb-201811.893
2-Feb-201811.893
2-Feb-201813.446
2-Feb-201813.187
2-Feb-201811.893
2-Feb-201811.893
2-Feb-201811.763
3-Feb-201813.187
4-Feb-201812.411
5-Feb-201812.281
6-Feb-201812.67
7-Feb-201811.893
8-Feb-201813.187
9-Feb-201811.634
10-Feb-201811.634
11-Feb-201813.317
12-Feb-201812.929
13-Feb-201812.67
14-Feb-201811.634
15-Feb-201811.634
16-Feb-201812.411
17-Feb-201812.022
18-Feb-201811.634
19-Feb-201811.634
20-Feb-201811.634
21-Feb-201812.152
22-Feb-201811.569
23-Feb-201811.375
24-Feb-201811.634
24-Feb-201811.893
25-Feb-201811.634
25-Feb-201811.893
26-Feb-201811.634
27-Feb-201811.44
28-Feb-201811.893
1-Mar-201811.505
2-Mar-201812.022
3-Mar-201811.505
4-Mar-201811.634
5-Mar-201812.281
6-Mar-201811.634
7-Mar-201811.505
8-Mar-201811.375
9-Mar-201812.152
10-Mar-201812.67
11-Mar-201811.375
12-Mar-201811.505
13-Mar-201811.375
14-Mar-201811.116
15-Mar-201811.375
16-Mar-201812.67
17-Mar-201811.116
18-Mar-201812.799
19-Mar-201811.505
20-Mar-201811.505
21-Mar-201811.505
22-Mar-201812.929
23-Mar-201812.67
24-Mar-201812.022
25-Mar-201811.634
26-Mar-201811.763
27-Mar-201811.634
28-Mar-201812.152
29-Mar-201812.67
30-Mar-201811.116
31-Mar-201812.152
1-Apr-201811.262
2-Apr-201811.31
3-Apr-201811.893
4-Apr-201811.375
5-Apr-201811.116
6-Apr-201811.375
7-Apr-201811.634
8-Apr-201812.799
9-Apr-201811.375
10-Apr-201811.246
10-Apr-201811.246
10-Apr-201812.767
11-Apr-201812.799
11-Apr-201811.375
12-Apr-201811.634
12-Apr-201812.67
13-Apr-201811.375
14-Apr-201811.246
15-Apr-201811.116
16-Apr-201811.165
17-Apr-201811.246
18-Apr-201811.634
19-Apr-201811.505
20-Apr-201812.67
21-Apr-201812.411
22-Apr-201811.116
23-Apr-201811.375
24-Apr-201811.116
25-Apr-201811.116

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

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,420
Office Version
  1. 365
Platform
  1. Windows
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
 
Last edited:

Similar threads

Forum statistics

Threads
1,148,293
Messages
5,745,921
Members
423,984
Latest member
sayed manzar

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