View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Raj[_2_] Raj[_2_] is offline
external usenet poster
 
Posts: 150
Default Help with interpolating values

Hi,

I have two series of data as follows:

Distance Height
0 0
6 12.5
11 23
12 16.25
14 26.75
24 27.25
42 22.75
45 30
55 52
70 67
90 79
115 83.5

I need to find the heights corresponding to :
5.
10
15
20
25
30
and so on till 115 (ie at distances in multiples of 5)

What is the best way to do this? I am new to statistical functions in
excel.

Thanks in advance for the help.

Regards,
Raj