How to generate exponential series of values with known initial and end values in Excel

Question

In Excel, I want to generate 1000 rows of values, I know the initial and final values.

For example, cell a1=1400 and cell a1000=1190, the total reduction is 15%, how to generate 1000 rows of values excel so that the values decrease exponentially?

Any idea how could I create a formula to achieve this? Thank you

Answer 1

Suggested answer: Get the x variable on column A from 1 to 1000 and then create the y variable on column b so in x=1 y=1400, And when x=1000 then y=1190 Then add chart with xy scatter and add power trend line. Set add equation on chart you will get y=1400X^-0.024. This will be your equation.