View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] dperez6811@yahoo.com is offline
external usenet poster
 
Posts: 6
Default Create a Random Variable

I am trying to model the success of sales reps and would like to create a
cell that has 3 options Fail, Average, and Superstar. I would aslo like to
assign ratios to 2 of the groups (so a user can play with the ratios) with
the third being default. So a simple example:

2 out of 3 Fail
1 out of 6 Average

Rep Number Expected Result
Rep 1 Fail
Rep 2 Fail
Rep 3 Average
Rep 4 Fail
Rep 5 Fail
Rep 6 Superstar