Interpolating values

[Navvy]

Hello!

I am wondering if we can interpolate values given that we have certain values. For example:

TODAY: 10
1 WEEK: 13
3 WEEKS: 18
7 WEEKS: 32

Say I wanted to find the value for 6 weeks (or any others), how could I do it?

Thank You!

 

[ETID]

try this

=FORECAST(E1,C1:C3,A1:A3)

will give you the linear regression estimate of the value in cell e1

because the values in the ranges are not linear, the value that is returned may not be exact....unless you you choose only 2 sets of values to forecast.

i.e.

=FORECAST(E1,C2:C3,A2:A3)

 

[ETID]

Note: I used row 1 as my first data set,...it looks like your data starts at row 2

so adjust as follows


=FORECAST(E2,C2:C4,A2:A4)