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

Question

In Excel, I want to generate 1000 rows of values, I know the start and end values.

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

Any idea how I can create a formula to achieve this? thank you

Answer 1

Recommended answer: Get the variable x in column A from 1 to 1000, and then create the variable y in column b, so that at x = 1 y = 1400, and when x = 1000, then y = 1190 Then add a diagram with a spread of xy and add a power trend line. Set the addition of the equation to the chart, you get y = 1400X ^ -0.024. This will be your equation.

Answer 2

Put 1 in A1, 2 in A2, 3 in A3 and so on ... to A1000, then write this in B1 =1400.2278*EXP(-0.00016268*A1) and continue to B1000, set the decimal format number in column 2.

The exponential regression equation is the form y=a*e^(bx) .

Strength is the form y=a*x^(b) .

In the function excel EXP (x) return e^x , e is the number of Eulers ~ 2.718281828 (approximate)

Answer 3

The first type is 1400 in A1 and 1190 in A1000.

Then tap F5 and when the GoTo dialog box opens, enter A1: A1000 in the Link: text box and click OK .

Select "Home" ► "Editing" ► "Fill" ► "Series" ( Alt + H , FI , S ).

When the Series dialog box appears , click OK . The increment (-0.21021021021021) will already be set.

Answer 4

Anyone who knows how to make this exact solution dynamically in R