An san shi don iyawar nazari da ƙididdiga, excel yana ba da damar ƙirƙirar lambobi, waɗanda ke da amfani wajen yin ragi marasa son rai. Waɗannan lambobin wata hanya ce mai kyau don tantance tasirin dama da rage tsangwama da ake samu a cikin bayanai. Lambobin bazuwar kuma na iya taimakawa wajen tantance ingancin hasashen da samar da samfuran yawan jama'a.
Ƙarin Amfani da Lambobin Random
Lambobin bazuwar, waɗanda aka zaɓa ba zato ba tsammani daga saiti ko kewayo, galibi suna gabatar da sauye-sauye a cikin matakai kamar simulators, cryptography, da ƙididdigar ƙididdiga. Kamar yadda bazuwar gaskiya na iya zama ƙalubale, yawancin tsarin suna amfani da janareta na ƙirƙira-bazuwar lamba don samar da jerin lambobi. Yawancin masana'antu, gami da wasanni kamar ƙwallon ƙafa na Amurka, suna amfani da ra'ayin bazuwar, inda galibi ana jefa sulalla don zaɓar wuraren farawa na wasannin.
Hakanan an yi amfani da manufar lambobi da bazuwar a wasu masana'antu kamar gidan caca. Tun lokacin da aka fara ramummuka na inji, sakamakon spins an ƙaddara ba da gangan ta hanyar motsi a cikin injina. Kamar yadda wasannin caca suka zama kan layi, masu haɓakawa sun ƙirƙiri software wanda ke tabbatar da bazuwar irin ta gidan caca ta zahiri. Wannan online ramummuka algorithm yana tabbatar da cewa sakamakon juzu'in bazuwar. Mai kunnawa ko gidan caca ba su san abin da ke faruwa ba, saboda duk wannan yana faruwa a cikin sabar mai nisa.
Lambobin bazuwar suna da kyau don tsaro saboda suna iya ƙirƙirar kalmomin sirri masu ƙarfi da maɓallan ɓoyewa. Waɗannan lambobin suna tabbatar da maɓallan tsaro ba su da sauƙin tsinkaya, don haka ya sa su zama mafi aminci. Yawancin sabis na dijital kamar cryptocurrency sun riga sun ci gajiyar ikon lambobin bazuwar. A cikin koyon inji, aikace-aikace na zahiri kamar na'urar tsabtace injin-robot suna amfani da lambobi bazuwar a cikin tsarin bazuwar yanki.
Fahimtar Lamba ta Random Generator na Excel
Microsoft Excel RNG aiki ne da aka gina, wanda aka fi sani da RAND ko RANDBETWEEN. A ainihinsa, Excel yana amfani da algorithms don samar da lambobi-bazuwar bisa ga ƙimar iri da mai amfani ya bayar ko aka samo daga masu canjin tsarin kamar lokacin yanzu. Wannan iri yana aiki azaman wurin farawa don algorithm, yana tabbatar da cewa jerin da aka samar ya bayyana bazuwar.
RANDBETWEEN yana samarwa lamba bazuwar tsakanin dabi'u biyu da aka bayar, yayin da RAND ke ba da ƙima tsakanin 0 da 1. Misali, ta amfani da dabara = RANDBETWEEN(1,100), za ku iya samar da lambobi bazuwar tsakanin 1 da 100. Lokacin da aka sake ƙididdige takardar aikin, dabarar ta haifar da lambobi tsakanin bazuwar. 1 da 100. Aikin RANDBETWEEN kuma yana ba da damar kwaikwayar matakai kamar mirgina mutuwa. Ƙididdigar da aka yi amfani da ita za ta kasance = RANDBETWEEN (1,6), inda 6 shine matsakaicin adadin matakan mutuwa.
Don kwaikwaiyon matakai kamar jefar da tsabar kudin, RAND ana amfani da aiki, dabarar kasancewa =RAND(0,1). Ga masu amfani da Microsoft 365, ƙarin aikin RANDARRAY yana haifar da lambobi a cikin kewayon tantanin halitta tare da manyan lambobi bazuwar. Siffar Cire Duplicates kusa da shafin Data yana taimakawa wajen magance kwafi a lokuta inda ake buƙatar ƙima na musamman.
A taƙaice, Excel yana ba da dabaru iri-iri don samar da lambobi bazuwar, suna ba da matakai daban-daban na rikitarwa da buƙatun mai amfani. Fahimta da amfani da waɗannan fasahohin za su haɓaka ƙarfin nazarin bayanai da kuma ba da gudummawa ga ƙarin hanyoyin yanke shawara.