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.).

24 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    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
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      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