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

On Tue, 6 Apr 2010 03:22:50 -0700 (PDT), Raj wrote:

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

Thanks. Exactly the insights I was looking for.

Regards,
Raj


On Apr 6, 4:23*pm, Ron Rosenfeld wrote:
On Tue, 6 Apr 2010 03:22:50 -0700 (PDT), Raj wrote:
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

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:

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

.

On Tue, 6 Apr 2010 04:36:39 -0700 (PDT), Raj wrote:

Thanks. Exactly the insights I was looking for.

Regards,
Raj

You're welcome. Thanks for the feedback.
--ron