I have a list of 25 spots and I know Value #1 and Value #25. What is the best way to estimate the values in between:
Example:
1: 250,000
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25: 38,400
I want to estimate what the range of numbers would be for spots #2-#24. Any formula would help.
Thanks!
There are all kinds of ways to interpolate values.
The simplest is a linear interpolation: constant difference between steps. You have $25 - 1 = 24$ intervals. The total difference is $250000 - 38400 = 211600$, so you'd want your step size to be
$$\frac{211600}{24} \approx 8816.67.$$
But you might want another way to fill them in, depending on your application.