01 na 01
Ƙirƙirar Ƙimar Dama tsakanin 0 da 1 tare da RAND Function
Wata hanya don samar da lambobi bazu a cikin Shafukan Rubutun Google yana tare da aikin RAND.
Ta hanyar kanta, aikin yana haifar da iyakar iyakance idan ya samo lambobin da bazuwar ba, amma ta amfani da RAND a cikin tsari da kuma ta haɗa shi tare da wasu ayyuka, iyakar dabi'un, kamar yadda aka nuna a cikin hoton da ke sama za a iya fadada sauƙin.
- Ta hanyar ƙaddamar da ƙananan dabi'u da ƙananan lambobi, za'a iya sanya RAND don dawo da lambobin bazuwar a cikin iyakan da aka kayyade - kamar 1 da 10 ko 1 da 100
- Za'a iya rage fitar da kayan aikin ta hanyar haɗuwa ta hanyar haɗin aikin tare da aikin TRUNC, wanda yake ƙaddara ko cire dukkan wuraren adadi daga lamba.
Lura : A cewar fayilolin taimako na Google, aikin RAND ya dawo da lambar bazuwar tsakanin 0 tare da 1 kawai .
Abin da ake nufi shi ne cewa yayin da yake saba da bayanin yawan lambobin da aka samo daga aikin kamar daga 0 zuwa 1, a gaskiya, ya fi dacewa a ce iyakar tsakanin 0 da 0.99999999 ....
A daidai wannan alama, hanyar da ta dawo da lambar bazuwar tsakanin 1 da 10 na ainihi ya dawo darajar tsakanin 0 da 9.999999 ....
Hanyoyin Ginin RAND
Haɗin aikin aiki yana nufin layout na aikin kuma ya haɗa da sunan aiki, shafuka, rabuɗɗun takaddama, da muhawara .
Haɗin aikin aikin RAND shine:
= RAND ()
Ba kamar aikin da yake ba, wanda yake buƙatar ƙididdigar ƙaura da ƙananan ƙaƙƙarfan da za a ƙayyade, aikin RAND ba zai karɓa ba.
RAND Function da Volatility
Ayyukan RAND aiki ne mai banƙyama wanda, ta tsoho, canje-canje ko sake dawowa duk lokacin da aikin aiki ya canza, kuma waɗannan canje-canje sun haɗa da ayyuka kamar ƙarin sababbin bayanai.
Bugu da ari, duk wata maƙala wadda ta dogara - ko dai kai tsaye ko a kaikaice - a kan tantanin halitta wanda ke dauke da wani aiki marar kyau kuma zai sake rikicewa a duk lokacin da canji a cikin takardar aiki yake faruwa.
Sabili da haka, a cikin takardun aiki wanda ya ƙunshi bayanai da yawa, dole ne a yi amfani da ayyuka masu banƙyama tare da taka tsantsan kamar yadda zasu iya jinkirta lokacin amsawa na shirin saboda yawan saukewa.
Samar da Sabbin Lambobi Masu Lissafi tare da Sabuntawa
Tun da Shafukan Lissafi na Google shine shirin layi, aikin RAND zai iya tilas ne don samar da sababbin lambobi ta hanyar sabunta allon ta yin amfani da maɓallin sake shafukan yanar gizo. Dangane da mai amfani da browser, maɓallin sake saukewa yana da mahimmanci arrow dake kusa da mashin adireshin mai bincike.
Hanya na biyu shine don danna maballin F5 a kan maɓallin keyboard wadda take maimaita madogarar mai amfani ta yanzu:
Canza Rabin Kwanan baya na RAND
A cikin Shafukan Lissafi na Google, ƙimar da RAND da sauran ayyukan da ba su da mahimmanci zasu iya sauya daga tsoho a kan canji zuwa:
- a kan sauyawa da kowane minti daya;
- a kan sauyawa da kowane awa.
Matakan da za a canza saɓo shine:
- Danna kan Fayil din menu don buɗe jerin menu na zaɓuɓɓuka
- Danna Shirye-shiryen Saitunan Lissafi a cikin jerin don buɗe akwatin maganganun Saitunan Fayil ɗin
- A karkashin Ƙungiyar Recalculation na akwatin maganganu, danna kan saiti na yanzu - irin su a canje-canje don nuna cikakken jerin jerin zaɓuɓɓuka
- Danna kan zaɓin da aka so a cikin jerin
- Danna maɓallin Ajiye Saituna don ajiye canjin kuma komawa zuwa aikin aiki
RAND Matakan Ayyuka
Da ke ƙasa an jera matakan da ake buƙatar haɓaka misalai da aka nuna a cikin hoto a sama.
- Na farko ya shiga aikin RAND da kanta;
- Misali na biyu ya haifar da wata hanyar da ta haifar da lambar bazuwar tsakanin 1 da 10 ko 1 da 100;
- Misali na uku ya haifar da lambar baƙi tsakanin 1 da 10 ta amfani da aikin TRUNC.
Misali 1: Shigar da aikin RAND
Tun da aikin RAND ba shi da wani muhawara, ana iya shigar da shi cikin kowane ɗigin hanyoyin aiki ta hanyar bugawa:
= RAND ()
Hakanan, ana iya shigar da aikin ta hanyar amfani da rubutattun kalmomi na Google wanda ya tashi kamar yadda sunan aikin ya shiga cikin tantanin halitta. Matakai sune:
- Danna kan tantanin halitta a cikin takardun aiki inda za a nuna sakamakon sakamakon
- Rubuta alamar daidai (=) biye da sunan aikin rand
- Yayin da kake bugawa, akwatin zane - zane yana nuna tare da sunayen ayyukan da suka fara tare da harafin R
- Lokacin da sunan RAND ya bayyana a cikin akwati, danna sunan tare da maɓallin linzamin kwamfuta don shigar da sunan aikin da kuma takalmin bude a cikin cell da aka zaɓa
- Yawan da ba a ƙira ba tsakanin 0 da 1 ya kamata ya bayyana a cikin cell din yanzu
- Don samar da wani, danna maɓallin F5 a kan maɓallin keɓaɓɓen kalmomi ko maimaita browser
- Lokacin da ka danna kan tantanin halitta na yanzu, cikakken aikin = RAND () yana bayyana a cikin maɓallin tsari a sama da takardun aiki
Misali 2: Samar da Lissafin Lissafi tsakanin 1 da 10 ko 1 da 100
Babban nau'i na lissafin da aka yi amfani dashi don samar da lambar bazuwar a cikin wani kewayon ƙayyade shi ne:
= RAND () * (High - Low) + Low
inda High da Low nuna ƙananan ƙananan ƙananan iyaka na layin da ake buƙata na lambobi.
Don samar da lambar bazuwar tsakanin 1 da 10 shigar da hanyar da aka biyowa a cikin sashin layi:
= RAND () * (10 - 1) + 1
Don samar da lambar bazuwar tsakanin 1 da 100 shigar da wannan ƙira a cikin sashin layi:
= RAND () * (100 - 1) + 1
Misali 3: Samar da Ƙirgiyoyi masu mahimmanci tsakanin 1 da 10
Don dawo da lamba - lamba ɗaya ba tare da wani sashi na ƙayyadadden ƙima ba - babban nau'i na daidaituwa ita ce:
= TRUNC (RAND () * (High - Low) + Low)
Don samar da lambar bazuwar tsakanin 1 da 10 shigar da tsarin da aka biyowa cikin tantanin halitta:
= TRUNC (RAND () * (10 - 1) + 1)