-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Interpolation on a graph where X is logarithmic (semi-log graph)
- Thread starter justmole
- Start date
Oaktree
MrExcel MVP
- Joined
- Jun 20, 2002
- Messages
- 8,119
- Office Version
- 365
Welcome to the board!
If the equation you're looking for is y = m * ln(x) + b and your x and y inputs are in A2:A100 and B2:B100 respectively, you can find m and b by using INDEX and LINEST together:
m =INDEX(LINEST(B2:B100,LN(A2:A100)),1)
b =INDEX(LINEST(B2:B100,LN(A2:A100)),1,2)
If the equation you're looking for is y = m * ln(x) + b and your x and y inputs are in A2:A100 and B2:B100 respectively, you can find m and b by using INDEX and LINEST together:
m =INDEX(LINEST(B2:B100,LN(A2:A100)),1)
b =INDEX(LINEST(B2:B100,LN(A2:A100)),1,2)
Upvote
0
Similar threads
- Question
