Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 369
  • Last Modified:

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 ?
0
c_hockland
Asked:
c_hockland
1 Solution
 
barry houdiniCommented:
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now