Luke wrote on Mon, 19 Dec 2005 06:19:02 -0800:

LW I'm trying to reproduce a graphic. It was made using the
LW random generator number. Since, I am not very confortable
LW with statistics I thought someone could help me with this.
LW The X axis represents days. The Y axis a Flow volume that
LW ranges from 0.4 to 32. The graphic represents a
LW "possibility" model of a flow during a year. For example,
LW Day 1 to Day 12, the flow is 23.5 litres. Day 62 to 100,
LW the flow is 0.4 litres. There are only 3 possibilities:
0.4, 23.5 or
LW 32.0. Please help, it's driving me nuts!

LW Thanks,

Since you only want 3 values, I think the easiest way might be
to insert/define a function, say, GAS,
=int(randbetween(1,3)+.1). Then equate your values:-
=if(gas=1,0.4,if(gas=2,23.5,32.0))


James Silverton.