Generating random values with a trend

[Juls687]

I am looking at forecasting something with a growth rate every year and I am running a Monte Carlo simulation with every years growth rate being normally distributed b/w 2 values and running thousands of simulations. I was wondering how I could get the random number generations to follow a trend. (I.e. it doesn’t make sense for the growth to be sporadic: negative, positing, negstive, positive. So I wasn’t sure how I could make it ‘trend’ based off previous values but still be possible for it to turn positive/negative

 

[BSALV]

for 1,000 values

Map1
	A	B
1	1	0,714921
2	2	1,87154
3	3	3,373583
4	4	4,839801
5	5	4,458128
6	6	2,521557
7	7	0,737265
8	8	2,208559
9	9	3,785134
10	10	0,913538
Blad1

Cell Formulas
Range	Formula
A1:A1000	A1	=SEQUENCE(1000)
B1:B10	B1	=A1*0.005+RAND()*5
Dynamic array formulas.

 

[Sulprobil]

I suggest to google for
Excel brownian bridge