How can I make an accurate trendline with only three sample points?
The three given points are as such: (1,65000000) (15,4650000) (70,930000)
When will the Y points intersect the X axis i.e get close (X, 1) based on these three points?
I tried an Exp. regression line which resulted in....Y = 28202062 x 0.95^X
....but that just seems too inaccurate because using that equation when X = 70, Y = 777916, that is over a 100k off from our given value which is 930000.
Is there any way to make this more accurate?
TIA
The three given points are as such: (1,65000000) (15,4650000) (70,930000)
When will the Y points intersect the X axis i.e get close (X, 1) based on these three points?
I tried an Exp. regression line which resulted in....Y = 28202062 x 0.95^X
....but that just seems too inaccurate because using that equation when X = 70, Y = 777916, that is over a 100k off from our given value which is 930000.
Is there any way to make this more accurate?
TIA