Slope and intercept function

Status
Not open for further replies.

bancanus

New Member
Joined
Apr 26, 2018
Messages
2
I could not get the slope and intercept that I expected:

What I get:
=INTERCEPT(A2:A113,B2:B113)497.262
=SLOPE(A2:A113,B2:B113)-0.01124

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

What I expect:
intercept ~ 12.55
slope ~ -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

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Duplicate https://www.mrexcel.com/forum/excel-questions/1053275-intercept-slope-function.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it.
Please be patient and do not attempt to post the question again.
 
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,214,979
Messages
6,122,551
Members
449,088
Latest member
davidcom

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
Back
Top