extrapolation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Trying to extrapolate numbers missing between data (rather than FORECAST)

For example

2, 3, 5, x, x, 8.5, 1

Any suggestions

Cheer

Roman
 
Enter 2,3,5,blank, blank, 8.5,10 in A1:7
Select the data and make an XY chart.
In chart, right click data series and use Insert Trendline; specify Linear
and in Options specify Display Equation
You get y=1.332+0.638 (this assumes the x values are 1,2,3,4,5,6,7)
So for x=4 we have y = 1.332x4+0.638=5.966 and for x=5 y=7.298
I think I would report these as 6 and 7 1/4.
Bernard
 
2, 3, 5, x, x, 8.5, 10
Click to expand...

Why do you not want to use FORECAST?

You could use TREND but you would get the same results.

For a straight line fit, the formula:

=TREND({2,3,5,8.5,10},{1,2,3,6,7},{4,5}) returns 5.96641791, 7.298507463 with
an R2 of .995


--ron
 
Back
Top