You are Here: Home >< Maths

# Maths/computing question watch

1. Iv got a maths/computing question where iv got to simulate the times 30 customers are served using a poisson distribution, mean 5 mins. Service times can be generated from a uniform distribution between 3 and 7 mins. Iv got to produce info on excel of the average time each customer has to wait to be served.
My knowledge of excel is very limited, are there any excel geniuses here who can help me? Thanks x
2. (Original post by wibble...)
Iv got a maths/computing question where iv got to simulate the times 30 customers are served using a poisson distribution, mean 5 mins. Service times can be generated from a uniform distribution between 3 and 7 mins. Iv got to produce info on excel of the average time each customer has to wait to be served.
My knowledge of excel is very limited, are there any excel geniuses here who can help me? Thanks x
This is crazy! You are defining the average time a customer has to wait to be served as 5. Now you want to use Excel to find that number!

Use: RAND()*(b-a)+a

With a = 3, b = 7.
3. (Original post by samd)
This is crazy! You are defining the average time a customer has to wait to be served as 5. Now you want to use Excel to find that number!

Use: RAND()*(b-a)+a

With a = 3, b = 7.
but that would be producing random numbers surely for this question the answers would be specific?! Also how would that be using a poisson distribution and the mean? (not that good at excel so may be wrong... )
4. Please clarify the question. What is the distribution of the time between successive customer arrivals?
5. (Original post by wibble...)
Service times can be generated from a uniform distribution between 3 and 7 mins. Iv got to produce info on excel of the average time each customer has to wait to be served.
i.e. Random numbers from the interval.
6. (Original post by samd)
i.e. Random numbers from the interval.
But the mean has to be 5 (at least from my understanding)

TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

This forum is supported by:
Updated: November 12, 2005
Today on TSR

### Cambridge interviews

Find out who is getting invitations

### University open days

• Heriot-Watt University
School of Textiles and Design Undergraduate
Fri, 16 Nov '18
• University of Roehampton
Sat, 17 Nov '18
• Edge Hill University
Faculty of Health and Social Care Undergraduate
Sat, 17 Nov '18
Poll
Useful resources

### Maths Forum posting guidelines

Not sure where to post? Read the updated guidelines here

### How to use LaTex

Writing equations the easy way

### Study habits of A* students

Top tips from students who have already aced their exams