ʻO ka mea hoʻopuka helu maʻamau ma Excel ma kahi ākea

I kēlā me kēia manawa, pono nā mea hoʻohana Excel e hoʻohua i nā helu maʻamau i mea e hoʻohana ai iā lākou i nā formulas a i ʻole no nā kumu ʻē aʻe. No ka hana ʻana i kēia, hāʻawi ka papahana i kahi arsenal holoʻokoʻa o nā mea hiki. Hiki ke hana i nā helu maʻamau ma nā ʻano like ʻole. E helu wale mākou i nā mea i hōʻike iā lākou iho i ka hoʻomaʻamaʻa ma ke ala maikaʻi loa.

Hana Helu Random ma Excel

Inā loaʻa iā mākou kahi ʻikepili i loaʻa i nā mea pili ʻole i kekahi i kekahi. ʻO ke kūpono, pono e hoʻokumu ʻia e like me ke kānāwai o ka puʻunaue maʻamau. No ka hana ʻana i kēia, pono ʻoe e hoʻohana i ka hana helu random. ʻElua mau hana e hiki ai iā ʻoe ke hoʻokō i kāu pahuhopu: HELU и MAWENA O KA HIHIA. E nānā pono kākou i ka hoʻohana ʻana iā lākou i ka hana.

Ke koho ʻana i nā helu maʻamau me RAND

ʻAʻole hāʻawi kēia hana i nā hoʻopaʻapaʻa. Akā naʻe me kēia, hiki iā ʻoe ke hana i ka laulā o nā waiwai i loko o ia e hana ai i kahi helu helu. No ka laʻana, no ka loaʻa ʻana iā ia i loko o ka hoʻolālā o hoʻokahi a ʻelima, pono mākou e hoʻohana i kēia ʻano: = HELU()*(5-1)+1.

Inā hāʻawi ʻia kēia hana i nā cell ʻē aʻe me ka hoʻohana ʻana i ka marker autocomplete, a laila e ʻike mākou ua like ka puʻunaue.

I loko o kēlā me kēia helu ʻana i kahi waiwai kūʻokoʻa, inā hoʻololi ʻoe i kekahi kelepona ma nā wahi āpau o ka pepa, e hana hou ʻia nā helu. No laila, ʻaʻole e mālama ʻia kēia ʻike. No ka hōʻoia ʻana i ko lākou noho ʻana, pono ʻoe e kākau lima i kēia waiwai ma ke ʻano helu, a i ʻole e hoʻohana i kēia ʻōlelo aʻo.

1. Hana mākou i kahi kaomi ma luna o kahi kelepona i loaʻa kahi helu maʻamau.
2. Hana mākou i kahi kaomi ma ka papa formula, a laila koho iā ia.
3. E kaomi i ke pihi F9 ma ka papa keyboard.
4. Hoʻopau mākou i kēia kaʻina hana ma ke kaomi ʻana i ke kī Enter.

E nānā kākou i ke ʻano like ʻole o ka puʻunaue ʻia o nā helu random. No ka hana ʻana i kēia, pono mākou e hoʻohana i ka histogram mahele. No ka hana ʻana, e hahai i kēia mau ʻanuʻu:

1. E hana kākou i kolamu me nā ʻeke, ʻo ia hoʻi, kēlā mau cell e mālama ai i kā mākou mau pae. ʻO ka mea mua he 0-0,1. Hana mākou i kēia me ka hoʻohana ʻana i kēia ʻano: =C2+$C$2. 
2. Ma hope o kēlā, pono mākou e hoʻoholo i ka nui o nā helu maʻamau e pili ana i kēlā me kēia pae kikoʻī. No kēia hiki iā mākou ke hoʻohana i ke ʻano array {=FREQUENCY(A2:A201;C2:C11)}. 
3. A laila, me ka hoʻohana ʻana i ka hōʻailona "clutch", hana mākou i kā mākou pae aʻe. He maʻalahi ke kumu =»[0,0-«&C2&»]». 
4. I kēia manawa ke hana nei mākou i kahi pakuhi e wehewehe ana i ke ʻano o kēia mau waiwai 200. 

I kā mākou laʻana, pili ka alapine i ke axis Y, a ʻo nā "pockets" pili i ke axis X.

MAHELE

E kamaʻilio ana i ka hana MAWENA O KA HIHIA, a laila e like me kāna syntax, ʻelua kāna mau manaʻo: kahi palena haʻahaʻa a me kahi palena luna. He mea nui e emi iho ka waiwai o ka palena mua ma mua o ka lua. Ua manaʻo ʻia he mau helu helu nā palena, a ʻaʻole i mālama ʻia nā ʻōkuhi hakina. E ʻike kākou i ka hana ʻana o kēia hiʻohiʻona ma kēia kiʻi paʻi kiʻi.

ʻIke mākou hiki ke hoʻoponopono ʻia ka pololei me ka hoʻohana ʻana i ka mahele. Hiki iā ʻoe ke loaʻa nā helu maʻamau me nā huahelu ma hope o ka helu decimal.

ʻIke mākou he ʻoi aku ka maikaʻi o kēia hana a hoʻomaopopo ʻia no kahi kanaka maʻamau ma mua o ka mea ma mua. No laila, i ka hapanui o nā hihia, hiki iā ʻoe ke hoʻohana wale ia.

Pehea e hana ai i ka helu helu helu ma Excel

A i kēia manawa e hana mākou i kahi mea hoʻoheheʻe helu liʻiliʻi e loaʻa nā waiwai e pili ana i kahi ʻano o ka ʻikepili. No ka hana ʻana i kēia, e hoʻopili i ke ʻano =INDEX(A1:A10, INTEGER(RAND()*10)+1).  

E hana kākou i mea hoʻoheheʻe helu maʻamau e hana ʻia mai ka ʻole a hiki i ka 10. Me ka hoʻohana ʻana i kēia ʻano hoʻohālike, hiki iā mākou ke hoʻomalu i ka ʻanuʻu e hana ʻia ai. No ka laʻana, hiki iā ʻoe ke hana i kahi mīkini hana e hoʻopuka wale i nā waiwai i hoʻopau ʻole ʻia. 

A i ʻole kēlā ʻano koho. E ʻōlelo mākou makemake mākou e koho i ʻelua mau kumu waiwai mai kahi papa inoa o nā kelepona kikokikona. 

A no ke koho ʻana i ʻelua mau helu maʻamau, pono ʻoe e hoʻopili i ka hana INDEX. 

Hōʻike ʻia ke ʻano hana a mākou i hana ai i ke kiʻi ma luna. =ИНДЕКС(A1:A7;СЛУЧМЕЖДУ(1;СЧЁТЗ(A1:A7))) – me kēia ʻano kumu, hiki iā mākou ke hana i kahi generator no kahi waiwai kikokikona hoʻokahi. ʻIke mākou ua hūnā mākou i ke kolamu kōkua. Hiki iā ʻoe. 

Hoʻohele maʻamau ka mea hoʻopuka helu random

pilikia hiʻona SLCHIS и MAWENA O KA HIHIA i loko o ka hana ʻana i kahi pūʻulu helu i mamao loa mai ka pahuhopu. ʻO ka like paha o ka ʻike ʻia ʻana o kahi helu kokoke i ka palena haʻahaʻa, waena a i ʻole ka palena luna.

ʻO ka puʻunaue maʻamau i nā ʻikepili he pūʻulu ʻikepili kahi, i ka piʻi ʻana o ka mamao mai ke kikowaena ma ka pakuhi, e emi ana ka alapine e loaʻa ai kahi waiwai ma kekahi alahele. ʻO ia hoʻi, ʻo ka hapa nui o nā waiwai e hōʻiliʻili a puni ka waena. E hoʻohana kākou i ka hana MAWENA O KA HIHIA E ho'āʻo kākou e hana i nā helu helu, ʻo ka puʻunaue o ia mea i ka ʻāpana o ka maʻamau.

No laila, loaʻa iā mākou kahi huahana, ke kumu kūʻai o 100 rubles. No laila, pono e hana ʻia nā helu ma kahi like. I kēia hihia, pono ke kumukūʻai maʻamau i 100 rubles. E hana mākou i kahi ʻano o ka ʻikepili a hana i kahi pakuhi kahi o ka deviation maʻamau he 1,5 rubles, a ʻo ka hāʻawi ʻana i nā waiwai he mea maʻamau.

No ka hana ʻana i kēia, pono ʻoe e hoʻohana i ka hana =NORMONUM(SLNUMBER();100;1,5). Eia hou, hoʻololi koke ka papahana i nā probabilities, e pili ana i ka helu ʻana i nā helu kokoke i hoʻokahi haneli ka manawa kiʻekiʻe loa.

I kēia manawa pono mākou e kūkulu i kahi pakuhi ma ke ala maʻamau, ke koho ʻana i kahi hoʻonohonoho o nā waiwai i hana ʻia ma ke ʻano he laulā. ʻO ka hopena, ʻike mākou he maʻamau maoli ka puʻunaue.

He maʻalahi kēlā. Laki maikaʻi.