I want to create an iteration in Excel by having the lower bound of 'x' increase by an increment until the upper bound of 'x' (E.g. Create a table from A1-A10 by starting the count from 0-10 with increments of 1).
How can I make it such that the table will self adjust its size with just the user prompting the upper-lower bounds of x and increment unit, so entering X_Lower=0, X_Upper=10 and X_increase=1 will give you a 2x10 table with column_1:iteration and Column_2:Result.
I am hoping to use this for iterative processes. Think of smoothing out CDF's & PDF's of probability distributions by increasing the the data points (i.e. decreasing the increments for more points)
Thanks.
1000474903
Bookmarks