Generator lambar bazuwar a cikin Excel a cikin kewayon

Daga lokaci zuwa lokaci, masu amfani da Excel suna buƙatar ƙirƙirar lambobi bazuwar don amfani da su a cikin ƙira ko don wasu dalilai. Don yin wannan, shirin yana ba da cikakken arsenal na dama. Yana yiwuwa a samar da lambobi bazuwar ta hanyoyi daban-daban. Za mu buga kawai waɗanda suka nuna kansu a aikace ta hanya mafi kyau.

Ayyukan Lambobin Random a cikin Excel

A ce muna da kundin bayanai wanda dole ne ya ƙunshi abubuwan da ba su da alaƙa da juna. Da kyau, ya kamata a kafa su bisa ga ka'idar rarraba ta al'ada. Don yin wannan, kuna buƙatar amfani da aikin lambar bazuwar. Akwai ayyuka guda biyu waɗanda za ku iya cimma burin ku da su: LISSAFI и TSAKANIN AL'AMARIN. Bari mu dubi yadda za a yi amfani da su a aikace.

Zaɓin lambobi bazuwar tare da RAND

Wannan aikin baya bayar da wata hujja. Amma duk da wannan, yana ba ku damar tsara kewayon ƙimar da ya kamata ya haifar da lambar bazuwar. Misali, don samun shi a cikin tsarin ɗaya zuwa biyar, muna buƙatar amfani da dabara mai zuwa: = COUNT()*(5-1)+1.

Idan an rarraba wannan aikin zuwa wasu sel ta amfani da alamar autocomplete, to za mu ga cewa rarraba ta kasance ma.

Yayin kowane lissafin ƙimar bazuwar, idan kun canza kowane tantanin halitta a ko'ina cikin takardar, lambobin za su sake haifar da su ta atomatik. Don haka, ba za a adana wannan bayanin ba. Don tabbatar da cewa sun kasance, dole ne ka rubuta wannan ƙima da hannu a sigar lamba, ko amfani da wannan umarni.

1. Muna yin danna kan tantanin halitta mai ɗauke da lambar bazuwar.
2. Muna danna maballin dabara, sannan zaɓi shi.
3. Danna maballin F9 akan maballin.
4. Muna ƙare wannan jerin ayyuka ta latsa maɓallin Shigar.

Mu duba yadda ake rarraba lambobin bazuwar iri ɗaya. Don yin wannan, muna buƙatar amfani da histogram na rarrabawa. Don yin shi, bi waɗannan matakan:

1. Bari mu ƙirƙiri ginshiƙi tare da aljihu, wato, waɗancan sel waɗanda za mu kiyaye kewayon mu. Na farko shine 0-0,1. Muna yin waɗannan ta amfani da wannan dabarar: =C2+$C$2. 
2. Bayan haka, muna buƙatar ƙayyade sau nawa lambobin bazuwar da ke da alaƙa da kowane takamaiman kewayon ke faruwa. Don wannan za mu iya amfani da tsarin tsararru {= MAFARKI(A2:A201;C2:C11)}. 
3. Na gaba, ta amfani da alamar "clutch", muna yin jeri na gaba. Tsarin tsari yana da sauƙi ="[0,0-"&C2&"]". 
4. Yanzu muna yin ginshiƙi yana kwatanta yadda ake rarraba waɗannan ƙimar 200. 

A cikin misalinmu, mitar ta dace da axis Y, kuma "aljihu" sun dace da axis X.

TSAKANIN aiki

Magana akan aiki TSAKANIN AL'AMARIN, to, bisa ga ma'anarsa, yana da hujja guda biyu: Ƙarƙashin dauri da kuma babba. Yana da mahimmanci cewa ƙimar sigar farko ta ƙasa da na biyu. An ɗauka cewa iyakoki na iya zama lamba, kuma ba a la'akari da ƙayyadaddun ƙididdiga. Bari mu ga yadda wannan fasalin ke aiki a cikin wannan hoton.

Mun ga cewa ana iya daidaita daidaito ta amfani da rarraba. Kuna iya samun bazuwar lambobi tare da kowane lambobi bayan maki goma.

Mun ga cewa wannan aikin ya fi kwayoyin halitta da fahimta ga talaka fiye da na baya. Saboda haka, a mafi yawan lokuta, zaka iya amfani da shi kawai.

Yadda ake yin janareta na lambar bazuwar a cikin Excel

Kuma yanzu bari mu yi ƙaramin janareta wanda zai karɓi ƙima bisa takamaiman kewayon bayanai. Don yin wannan, yi amfani da dabarar =INDEX(A1:A10,INTEGER(RAND()*10)+1).  

Bari mu ƙirƙiri janareta na bazuwar lamba wanda za a samar daga sifili zuwa 10. Ta amfani da wannan dabara, za mu iya sarrafa matakin da za a samar da su. Misali, zaku iya ƙirƙirar janareta wanda zai samar da ƙimar da ba ta ƙare ba. 

Ko irin wannan zaɓi. Bari mu ce muna so mu zaɓi ƙima biyu bazuwar daga jerin sel rubutu. 

Kuma don zaɓar lambobi bazuwar, kuna buƙatar amfani da aikin INDEX. 

Ana nuna dabarar da muka yi wannan da ita a hoton hoton da ke sama. =ИНДЕКС(A1:A7;СЛУЧМЕЖДУ(1;СЧЁТЗ(A1:A7))) – tare da wannan dabara, zamu iya ƙirƙirar janareta don ƙimar rubutu ɗaya. Mun ga cewa mun ɓoye ginshiƙin taimako. Haka za ku iya. 

Rarraba Random Number Generator

Matsalar fasali SLCHIS и TSAKANIN AL'AMARIN ta yadda suke samar da jerin lambobi waɗanda ke da nisa sosai daga abin da ake nufi. Yiwuwar lamba zata bayyana kusa da ƙananan iyaka, matsakaici ko babba iri ɗaya ne.

Rarraba al'ada a cikin ƙididdiga shine saitin bayanai wanda, yayin da nisa daga tsakiya a kan jadawali ya karu, yawan adadin da ƙimar ke faruwa a cikin wani corridor yana raguwa. Wato, yawancin dabi'u sun taru a kusa da na tsakiya. Bari mu yi amfani da aikin TSAKANIN AL'AMARIN Bari muyi kokarin ƙirƙirar saitin lambobi, rarraba wanda ke cikin nau'in na al'ada.

Saboda haka, muna da samfurin, wanda farashinsa ya kai 100 rubles. Don haka, yakamata a samar da lambobin kusan iri ɗaya. A wannan yanayin, matsakaicin darajar ya kamata ya zama 100 rubles. Bari mu ƙirƙiri tsararrun bayanai kuma ƙirƙirar jadawali wanda daidaitattun daidaito shine 1,5 rubles, kuma rarraba dabi'u na al'ada ne.

Don yin wannan, kuna buƙatar amfani da aikin =NORMONUM(SLNUMBER();100;1,5). Bugu da ari, shirin ta atomatik yana canza yuwuwar, dangane da gaskiyar cewa lambobi kusa da ɗari suna da mafi girman dama.

Yanzu kawai muna buƙatar gina jadawali a daidaitaccen hanya, zaɓi saitin ƙimar ƙima a matsayin kewayon. A sakamakon haka, mun ga cewa rarraba ya kasance al'ada.

Yana da sauki haka. Sa'a.