Waxaa jira dhowr siyaabood oo la yaab leh oo aad ku isticmaali karto koronto-dhaliye nambarka random-ka gudaha Excel . Laakin ka hor intaadan samayn, waxaa muhiim ah in aad fahanto shaqada koronto dhaliyaha nambarada random-ka iyo sida aad ugu isticmaali karto codsiyo kala duwan.

Markaad barato sida loo isticmaalo hawlaha nambarada random-ka, waxaad samayn kartaa waxyaabo ay ka mid yihiin abuurista xogta muunada muunada ah si aad u tijaabiso xisaabinta, doorashada nidaamka ciyaartoyga ciyaarta, doorashada ku guulaysta tartanka, iyo waxyaabo kale oo badan.

Shaqooyinka Dhaliyaha Nambarka Random^{(Random Number Generator Functions)} ee Excel

Labada shaqo ee Excel ee ka shaqeeya abuurista tirooyin aan toos ahayn waxaa ka mid ah RAND , RANDBETWEEN , iyo RANDARRAY .

• RAND : Wuxuu soo celiyaa lambar random ah oo u dhexeeya 0 iyo 1. Tani badanaa waa jajab tobanle sida 0.358432. 
• RANDBETWEEN : Waxay soo celisaa lambar random ah oo u dhexeeya laba lambar oo aad bixisay. Si kale haddii loo dhigo, haddii aad rabto tiro random ah oo u dhexeeya 1 iyo 100, shaqadani waxay soo celin doontaa qiimaha isugeynta gudaha xadkaas. 
• RANDARRAY : Wuxuu soo celiyaa tiro kasta oo isugeyn random ama jajab tobanle, inta u dhaxaysa tirooyinka ugu yar ama ugu badan, iyo dhammaan safafka iyo tiirarka aad rabto.

Mar kasta oo aad furto xaashida faafinta ama dib u cusboonaysii xisaabinta, labadan hawloodba waxay dhalin doonaan qiime random cusub. Nasiib darro, isbeddel kasta oo lagu sameeyo xaashida xaashida ayaa kicisa cusboonaysiinta qiimayaashan.

Sidoo kale, maskaxda ku hay in labadan shaqo ee lambarrada random-ka ay dhalin karaan qiyamyo nuqul ah markaad u isticmaasho unugyo badan^{(multiple cells)} . Waxay u badan tahay in RANDBETWEEN ay dhaliso nuqullo sababtoo ah RAND waxay soo saartaa jajab tobanle waxaana jira tiro badan oo suurtagal ah.

Sida loo Isticmaalo Shaqada RAND

Shaqada RAND aad bay u fududdahay in la isticmaalo sababtoo ah ma jiraan wax dood ah oo dhan. Kaliya^(Just) ku qor " =RAND ()" unug oo tabo Gelida^(Enter) . 

Tani waxay isla markiiba dhalin doontaa jajab tobanle inta u dhaxaysa 0 iyo 1.

Goorta la Isticmaalayo Shaqada RAND

Sidee hawshan fudud u noqon kartaa mid waxtar leh? Halkan waxaa ah dhowr fikrado wax ku ool ah oo loogu talagalay isticmaalka shaqada RAND . 

Aynu nidhaahno waxaad haysaa liis magacyo saaxiibo ah oo ciyaaraya ciyaarta looxa oo aad rabto inaad si dhakhso ah u xalliso nidaamka ciyaarta. Shaqada RAND ayaa tan ugu fiican.

Kaliya ku tax dhammaan magacyada asxaabtaada tiirka koowaad.

Isticmaal shaqada RAND () si aad u abuurto jajab tobanle random tiirka soo socda.

Ugu dambeyntii, dooro labada tiir, ka dooro Hoy^(Home) ka menu-ka, ka dooro Kala-soocida & Shaandhaynta^{(Sort & Filter)} ribbon-ka, ka dibna dooro Qaabka Gaarka^{(Custom Sort)} ah.

Daaqadda Kala^(Sort) - soocida , dooro tiirka leh tirooyinka random si aad u kala saarto, oo ka dalbo kan ugu weyn ilaa^{(Largest to Smallest)} kan ugu yar . Dooro OK _

Tani waxay dib u habayn doontaa liiskaaga iyadoo loo eegayo tirooyinka random ee la sameeyay. Kuwaas waxaa weheliya, waxay sidoo kale u adeegsan doontaa magacyada nidaamka cusub ee gameplay.

Waxaad u isticmaali kartaa RAND si la mid ah kiis kasta oo aad rabto inaad ku kala soocdo qiimaha xisaabinta, liiska qiimaha qoraalka, ama wax kasta oo kale oo lagu kaydiyo xaashidaada.

Sida loo Isticmaalo Shaqada RANDBETWEEN

Shaqada RANDBETWEEN waxay ku dhowdahay inay fududdahay sida shaqada RAND ee la isticmaalo. Kaliya^(Just) ku qor " RANDBETWEEN ([min], [max]", adigoo ku beddelaya min iyo max tirooyinka ugu hooseeya iyo kuwa ugu sarreeya ee kala duwanaanshaha aad rabto tirooyinka.

Markaad riixdo Gelida^(Enter) , unuggaas wuxuu ka koobnaan doonaa lambar random ah oo u dhexeeya qiimahaas hoose ama sare.

Goorta la Isticmaalayo Shaqada RANDBETWEEN^{(RANDBETWEEN Function)}

Shaqada abuuraha lambarka random-ka ee RANDBETWEEN ayaa xitaa ka faa'iido badan shaqada RAND . Tani waa sababta oo ah waxay kuu ogolaanaysaa inaad kakoobsato tirooyinka random-ka ee la soo celiyay gudaha xadka. Waxa kale oo ay soo celisaa shaandhada halkii ay ka ahaan lahayd jajab tobanle.

Tani waxay ku siinaysaa habab aad hal abuur leh oo aad u isticmaali karto shaqadan si aad u codsato hawlo aan kala sooc lahayn marka aad doonayso inaad noqoto mid cadaalad ah, ama aad tiro go'an u qoondayso dadka ama shay adoon muujinin eex.

Bal aan tusaale u soo qaadano. Aynu nidhaahno waxaad haysaa liis ka kooban 12 qof oo aad doonayso inaad u kala qaybiso laba kooxood oo midkiiba ka kooban yahay 6 adoon ceebayn ka imanaysa inaad dadka u ogolaato inay “doortaan” dadka ay jecel yihiin koox kasta.

Marka hore, samee xaashi faafin leh dhammaan magacyada ciyaartoyda.

Ku dar shaqada soo socota tiirarka xiga, oo ku xiga magaca ciyaaryahan kasta. Markaas taabo Gelida^(Enter) .

=RANDBETWEEN(1,2)

Tan waxaad geli kartaa unugga koowaad ka dibna ku buuxi inta ka hooseysa^{(fill the rest below it)} . Tani waxay si toos ah u meelayn doontaa ciyaaryahan kasta kooxda 1 ama kooxda 2.

Haddii aad ogaato in qaybinta labada kooxood aysan xitaa ahayn, kaliya dib u geli shaqada unugga koowaad oo taabo Gelida^(Enter) . Tani waxay cusbooneysiin doontaa dhammaan unugyada mar kale. Ku celi^(Repeat) ilaa kala qaybsanaanta labada kooxood ay siman yihiin.

Sida Loo Isticmaalo Shaqada RANDARRAY

Shaqada RANDARRAY waxay ku jirtaa Excel 365 oo keliya^{(Excel 365 only)} . Haddii aad haysato nooca Excel , tani waa shaqo abuur random aad u awood badan oo Excel ah oo aad u isticmaali karto ujeedooyin kala duwan.

Isticmaalka waa mid aad u fudud, oo leh meelo badan oo ikhtiyaari ah. Kaliya^(Just) ku qor kuwan soo socda unug kasta:

=RANDARRAY ([rows], [columns], [min], [max], [integer])

Halbeegyadu waa sida soo socota:

• saf^(rows) : Tirada safafka si loo abuuro tirooyin aan toos ahayn
• tiirar^(columns) : Tirada tiirar si loo dhaliyo tirooyinka random
• min : Xadka ugu yar ee tirooyinka
• max : Xadka ugu badan ee tirooyinka
• tiro^(integer) : Haddi aad rabto jajab tobanle ama tirooyin ( RUN^(TRUE) ama BEEN^(FALSE) )

Haddii aad kaliya isticmaasho shaqada RANDARRAY oo keliya oo aadan isticmaalin mid ka mid ah xuduudaha ikhtiyaariga ah, waxay u shaqeyn doontaa sida shaqada RAND .

Kaliya xasuusnoow in shaqada RANDARRAY ay aad u dabacsan tahay oo ay buuxin doonto oo kaliya inta saf iyo tiirar inta aad sheegtay, sida saxda ah ee aad u sheegtay. Default had iyo jeer waa jajab tobanle, oo kaliya 1 saf iyo 1 tiir.

Goorta la Isticmaalayo Shaqada RANDARRAY

Shaqada RANDARRAY waxa sida ugu fiican loo isticmaalaa marka aad u baahato dhamaan ururinta tirooyinka random, oo ay ku jiraan tiirar badan iyo safaf badan.

Tusaale ahaan, haddii aad u ekaanayso shay sida liiska random ee doorashooyinka lambarrada bakhtiyaanasiibka, waxaad si degdeg ah u samayn kartaa liis saf ah oo ka kooban 6 tiir (oo loogu talagalay 6da kubbadood ee bakhtiyaanasiibka). U deji xadka 69 oo u ogolow Excel inuu qiyaaso 10-ka bakhtiyaa-nasiibka ah ee kuu dooranaya shaqadan soo socota:

=RANDARRAY(10,6,1,69,TRUE)

Geli tan unuga koowaad ee xaashidaada oo tabo Gelida^(Enter) .

Waxaad arki doontaa miis la soo saaray oo ay ku jiraan 10 saf iyo 6 tiir.

Shaqadani waxay noqon kartaa xal weyn xagga sayniska ama cilmi-baarista tirakoobka haddii aad u baahan tahay xog-ururin weyn oo aadan rabin inaad dhammaan gacanta ku dhisto.

Doorashada Farsameeyaha Nambarka Random^{(Random Number Generator)} saxda ah ee Excel

Mid kasta oo ka mid ah saddexda hawlood ee Excel ee^{(Excel functions)} aad isticmaasho waxay ku xiran tahay inta badan natiijooyinka aad raadineyso. Haddii aadan runtii dan ka lahayn waxa lambarku yahay, RAND waxay samayn doontaa si fiican. Haddii aad rabto inaad xaddido tirada tirada la sameeyay, ka dib raac RANDBETWEEN . Oo haddii aad raadinayso xog aad u weyn oo leh shax dhan oo nambaro ah, waa marka RANDARRAY ay kuu tahay ikhtiyaarka kuugu fiican.

Random Number Generator in Excel: How and When to Use It

There are a surprising number of wаys yоu can make υse of a random number generator in Excel. But before you do, it’s important to understand the function of a random number generator аnd how you can use it for different applications.

Once you learn how to use the random number functions, you can do things like generating dummy sample data to test calculations, choosing the order of players for a game, picking winners for a contest, and many other things.

Random Number Generator Functions in Excel

The two functions in Excel that work to create random numbers include RAND, RANDBETWEEN, and RANDARRAY.

• RAND: Returns a random number between 0 and 1. This is usually a decimal like 0.358432. 
• RANDBETWEEN: Returns a random number between two numbers you provide. In other words, if you want a random number between 1 and 100, this function will return an integer value inside that range. 
• RANDARRAY: Returns any number of random integers or decimals, between any minimum or maximum numbers, and across any range of rows and columns you want.

Whenever you open a spreadsheet or refresh calculations, both of these functions will generate a new random value. Unfortunately, any change to the spreadsheet triggers an update of these values.

Also, keep in mind that both of these random number functions can generate duplicate values when you use them in multiple cells. It’s more likely that RANDBETWEEN will generate duplicates because RAND generates decimals and there are many more possible numbers.

How to Use the RAND Function

The RAND function is very straightforward to use because there are no arguments at all. Just type “=RAND()” into a cell and press Enter. 

This will immediately generate a decimal between 0 and 1.

When to Use the RAND Function

How can such a simple function be useful? Here are a few practical ideas for using the RAND function. 

Let’s say you have a list of names of friends playing a board game and you want to quickly sort out the order of play. The RAND function is perfect for this.

Just list all of the names of your friends in the first column.

Use the RAND() function to generate random decimals in the next column.

Finally, select both columns, select Home from the menu, select Sort & Filter from the ribbon, and then select Custom Sort.

In the Sort window, choose the column with the random numbers to sort, and order them from Largest to Smallest. Select OK.

This will reorder your list according to the random numbers that were generated. Along with those, it’ll also resort the names into the new order for gameplay.

You can use RAND similarly in any case where you want to randomize a value in a calculation, a list of text values, or anything else stored in your spreadsheet.

How to Use the RANDBETWEEN Function

The RANDBETWEEN function is almost as simple as the RAND function to use. Just type “RANDBETWEEN([min],[max]”, replacing min and max with the lowest and highest numbers of the range you want numbers for.

When you press Enter, that cell will contain a random number between that low or high value.

When to Use the RANDBETWEEN Function

The RANDBETWEEN random number generator function is even more useful than the RAND function. This is because it lets you contain the returned random numbers within a range. It also returns integers instead of decimals.

This gives you some very creative ways to use this function to apply random assignments when you want to be fair, or assigning fixed numbers to people or things without showing any bias.

Let’s look at an example. Let’s say you have a list of 12 people and you want to split them into two teams of 6 each without the embarrassment that comes from letting people “pick” their favorite people for each team.

First, create a spreadsheet with all of the players’ names.

Add the following function to the next column, next to each player name. Then press Enter.

=RANDBETWEEN(1,2)

You can enter this into the first cell and then fill the rest below it. This will automatically assign each player to team 1 or team 2.

If you find that the distribution between the two teams isn’t even, just reenter the function in the first cell and press Enter. This will update all cells again. Repeat until the split between the two teams is even.

How to Use the RANDARRAY Function

The RANDARRAY function is available in Excel 365 only. If you have this version of Excel, this is a very powerful random generator function in Excel that you can use for a wide range of purposes.

Using it is very simple, with lots of optional settings. Just type the following into any cell:

=RANDARRAY ([rows], [columns], [min], [max], [integer])

The parameters are as follows:

• rows: Number of rows to generate random numbers
• columns: Number of columns to generate random numbers
• min: Minimum limit for the numbers
• max: Maximum limit for the numbers
• integer: Whether you want decimals or integers (TRUE or FALSE)

If you just use the RANDARRAY function alone and don’t use any of the optional parameters, it’ll work just like the RAND function.

Just remember that the RANDARRAY function is very flexible and will only fill in as many rows and columns as you specify, in the exact way that you specify. Default is always decimals, and only 1 row and 1 column.

When to Use the RANDARRAY Function

The RANDARRAY function is best used when you need an entire collection of random numbers, including multiple columns and multiple rows.

For example, if you’re simulating something like a random list of lottery number choices, you can quickly create a list of rows that contain 6 columns (for the 6 lottery balls). Set the limit to 69 and let Excel guess your 10 lottery picks for you with the following function:

=RANDARRAY(10,6,1,69,TRUE)

Place this into the first cell of your spreadsheet and press Enter.

You’ll see a table generated that includes 10 rows and 6 columns.

This function could be a great solution in science or statistical research if you need a large random dataset and don’t want to build it all manually.

Choosing the Right Random Number Generator in Excel

Whichever of the three Excel functions you use depends mostly on what results you’re looking for. If you don’t really care what the number is, RAND will do just fine. If you want to limit the range of numbers generated, then go with RANDBETWEEN. And if you’re looking for a much larger dataset with an entire table of numbers, that’s when RANDARRAY is the best option for you.

Related posts

• Sida loo tirtiro khadadka banaan ee Excel

• Sida loo Isticmaalo Tilmaamaha Unugyada Hadalka ee Excel

• Sida loo Geliyo Xaashida Shaqada ee Excel Word Doc

• Sida loo isticmaalo Excel's What-If Analysis

• Sida Loo Hagaajiyo Safka gudaha Excel

• Sida Loo Mideeyo Unugyada, Tiirarka & Safafka gudaha Excel

• Sida looga saaro Gridlines gudaha Excel

• Sida Looga Saaro Safka Kooban Ee Excel

• U isticmaal Magacyada Range Dynamic ee Excel si aad u Dejiso Dabcida

• Sida loo qoro IF Formula/Bayaanka gudaha Excel

• 2 siyaabood oo loo Isticmaalo Shaqada Transpose ee Excel

• Ku xidhida Excel iyo MySQL

• 4 siyaabood oo Excel loogu badalo Google Sheets

• Xarunta Xogta Xaashida Shaqada ee Excel si loo daabaco

• Sida Loo Dhaqaajiyo Columns gudaha Excel

• Google Sheets vs Microsoft Excel - Waa maxay faraqa u dhexeeya?

• 5 siyaabood oo loogu badalo qoraalka nambarada gudaha Excel

• Sida loo raad raaco Ku-tiirsanaanta gudaha Excel

• Sida Loo Abuuro VBA Macro Ama Script gudaha Excel

• 4 siyaabood oo loo isticmaalo calaamadda jeeg ee Excel