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

excel exponential
user2563812 picture user2563812 · Aug 27, 2015 · Viewed 11.8k times · Source

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

Balinti picture Balinti · Aug 27, 2015

enter image description hereSuggested 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.

Related questions

Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More
IF statement: how to leave cell blank if condition is false ("" does not work)

I would like to write an IF statement, where the cell is left blank if the condition is FALSE. Note that, if the following formula is entered in C1 (for which the condition is false) for example: =IF(A1=1,B1,"") …

Read More
'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

I'm trying to get data from an Excel file on a button click event. My connection string is: string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\source\\SiteCore65\\Individual-Data.xls;Extended Properties=Excel 8.0;"; When I click on the button, …

Read More