• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 370
  • 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

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

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