Help with interpolating values

R

Raj

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
 
R

Ron Rosenfeld

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

It depends on what type of curve you feel best fits your data.

For a simple straight-line interpolation, you could use the FORECAST function.
However, if you want to force the value to zero where Distance = 0, then you
could use the LINEST function in a formula.

So if your data is A2:B13:

D2:D25 Your series in increments of 5
D2: 0
D3: 5
etc

For simple straight line:
E2: =FORECAST(D2,$B$2:$B$13,$A$2:$A$13)
and fill down to E25

To Force the zero intercept:
E2: =D2*LINEST($B$2:$B$13,$A$2:$A$13,FALSE)

--ron
 
S

Stefi

One solution may be:

In D2 (fill down to D24)
=FORECAST(C2,$B$2:$B$13,$A$2:$A$13)

where

C2:C24: 5, 10, 15, ... 115
$B$2:$B$13: height values
$A$2:$A$13: distance values


--
Regards!
Stefi


„Raj†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

//autoaverage. 2
For Loop 9
Transpose Macro 0
help 1
Sorting (Numbers with Text) 8
multiple ranking (sorting), based on diff. criteria 0
Linear Regression 1
LOOKUP function 3

Top