EXCEL වැඩ්දෝ වරෙල්ලා

[dilanexe]

=NORMINV(RANDBETWEEN(35,46), 20, 3.526) මේකේ වැරැද්ද මොකක්ද බං. MEAn 20 වන Std deviation 3.526 වෙන 35-46 අතරෙ data සෙට් එකක් ජෙනරේට් කරගන්න වෙන ක්‍රමයක් තියනවද

 

[casc_rokz]

ChatGPT dapan


The function RANDBETWEEN(35,46) generates a random integer between 35 and 46, which will change every time the worksheet recalculates. Therefore, the result of the formula will also change every time the worksheet recalculates.

If you want to fix the random number and use it in multiple calculations, you should generate the random number in a separate cell and refer to that cell in your formula. For example, you could put =RANDBETWEEN(35,46) in cell A1, and then use =NORMINV(A1, 20, 3.526) in your other cells. This way, the random number will only change when you manually recalculate or change it in cell A1.
~ChatGPT~

---

Yes, there is a way to generate values between 35-46 in Excel. You can use the following formula:

=RAND()*(46-35)+35

This will generate a random number between 35 and 46. You can copy this formula down the column to generate multiple values.
------ Post added on Mar 16, 2023 at 12:21 PM

 

[avjayarathne]