Modelling

Hi Guys,

Im at uni doing a course in data modelling for managers. Having to look at how to simulate particular data. We have been given a task to construct a model which simulates daily demands of a particular service.

I have produced a model, but im unsure whether its right and thought i could see what you guys thought.

We have been given data about the probabilities of having to go to certain sites. I have produced a random number that i will call Demand, using the Rand() function. To work out the number of locations that the individual will have to visit i have seen what locations have a probability greater than this randomly produced figure.

This model is producing scattered figures with lots of 0 demands and high demands in other places.

Hope you can help,
if you need more details please let me know,

Thanks.

hi guys,

please find attached a document with a sample of data, the question i'm trying to answer and my simple model.

I'm basically trying to answer the question and am rather stuck!

Thanks,
Ross

sorry i forgot to attach the document,

Cheers again.