title: How to generate random vallues in excel for arrival and service, with fixed mean?
body: <p>i am simulating an M/M/1 queue in excel where i want to generate random values for arrival rate lambda and service rate (meu) in two columns such that :</p>
  
  <pre><code>    arrival rate (lambda) = 2
      service rate (meu) = 5 (but the average of meu always remains 1 in the column despite      
      generating the values for meu randomly using rand().
  </code></pre>
  
  <p>How can i generate random values using rand() for lambda and meu such that their averages can be restricted to a fixed value in the respective columns. I need to run the simulation for different values of utilization where utilization =  lambda/meu ratio (i need to use 0.2, 0.4, 0.6 and 0.8 for lambda/meu). But the values in the column for both would be random and average of meu should be fixed at 1. I will change lambda for different utilization ratios then.</p>