ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   random number (https://www.excelbanter.com/excel-discussion-misc-queries/56825-random-number.html)

[email protected]

random number
 
how can i create a normally distributed random number
and a random number that has a beta distribution
i need these both to be integer outputs
thanks for the help

Gary''s Student

random number
 
Use NORMDIST and BETADIST
--
Gary's Student


" wrote:

how can i create a normally distributed random number
and a random number that has a beta distribution
i need these both to be integer outputs
thanks for the help


Jerry W. Lewis

random number
 
I think you meand NORMINV and BETAINV. See my reply under the OP's repeat of
this question.

It is generally better to reply to your original thread with followup
issues, since it keeps the discussion together and ensures you don't lose
people who are already trying to help you.

Jerry

"Gary''s Student" wrote:

Use NORMDIST and BETADIST
--
Gary's Student


" wrote:

how can i create a normally distributed random number
and a random number that has a beta distribution
i need these both to be integer outputs
thanks for the help



All times are GMT +1. The time now is 08:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com