Using CEP to determine random value

I am creating a simple simulation using MS Excel. The real-world
device provides an output value conforming to a CEP of 5 (e.g. 50% of
the values fall between 0 and 5, 50% above 5) It also is restricted
that 95% fall below 10.25 and 5% above.

For my simulation I need to generate a random value that conforms to
that distribution. I know it isn't uniform so I cannot simply use
RAND(). I suspect that I can somehow use a normal distribution but I'm
getting lost as how to transform it into the CEP above.

Any help would be appreciated.

BTW, this is not for a class assignment. This is for a real-world job,
we're trying to satisfy a customer requirement but those I've asked
around here don't have a strong statistics background.

.

Relevant Pages

  • Re: Using CEP to determine random value
    ... The real-world ... device provides an output value conforming to a CEP ... that distribution. ...
    (sci.stat.math)
  • Re: Using CEP to determine random value
    ... The real-world ... device provides an output value conforming to a CEP ... that distribution. ...
    (sci.stat.math)
  • Re: Does robotic engineering have a place in strong AI research?
    ... > Electronic engineering ... Rodney Brooks is famous for saying "simulations are ... IOW, a simulation in a box is just that, a simulation in a box - and ... you have a something that actually works in the real-world. ...
    (comp.ai.philosophy)
  • Re: Whose Fish - OO solution
    ... I was thinking of a way to make this problem more real-world instead ... The problem was fine as it was IMO, ... my understanding is that simulation tools are becoming ... will be entered by domain experts, not programmers for the most part. ...
    (comp.object)
  • Re: Using CEP to determine random value
    ... gfedor wrote: ... device provides an output value conforming to a CEP of 5 (e.g. 50% of ... I suspect that I can somehow use a normal distribution but I'm ... getting lost as how to transform it into the CEP above. ...
    (sci.stat.math)
Quantcast