interpolation

i have the values

for 470  -->1
for 440 -->3
i want to find value for 450

using Excel =FORECAST(450,B16:B17,A16:A17) it gives me 2.33 but the manual gives 1.8

what did i do wrong ?
c_hocklandAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
barry houdiniConnect With a Mentor Commented:
How do you get 1.8? Assuming a straight line then as 450 is twice as far from 470 as 440 then shouldn't the result be twice as far from 1 as 3, i.e. 2.33?

regards, barry
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.