Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

Random value generation

Idea:
Excel might have a built-in function for generating random values.
Two 1-dimensional and identical long ranges can include inputs for both the values to be returned and the corresponding weights.
E.g. ["apple","orange","apricot"] [10,20,30] -> 30/(10+20+30)=50%, 50% is the probability that the returned value is "apricot".

Rationale:
-This solution can help to generate datasets with predefined parameters. This can help in teaching, training and modeling activities.
-The same approach can be applied for generating timestamps with predefined parameters. This could be utilized for data analysis (monthly, weekly, daily seasons, distributions etc.).

25 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Peter Szmodics shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Peter Szmodics commented  ·   ·  Flag as inappropriate

    Hi John,
    Thank you for the comment.

    The purpose of this function is to substantially shorten the time needed to formulate the criteria.
    Instead of combining the functions 'IF' and 'RAND' casewise, you can use this recommended predefined function.
    The 'RAND' function is still part of the solution, but the user could immediately apply the criteria without further effort.

    Regards,
    Peter

  • John commented  ·   ·  Flag as inappropriate

    Not sure why this is better than applying the existing =RAND() function.

Feedback and Knowledge Base