Usebenzisa Ukuhlaziywa Kweqembu ngokweMicrosoft Excel

Pin
Send
Share
Send

Elinye lamathuluzi wokuxazulula izinkinga zomnotho ukucubungulwa kwezinhlangano. Ngosizo lwayo, amaqoqo nezinye izinto zamalungu edatha ahlukaniswe ngamaqembu. Le ndlela ingafakwa ku-Excel. Ake sibheke ukuthi kwenziwa kanjani kulokhu.

Isebenzisa Ukuhlaziywa Kweqembu

Ngosizo lokuhlaziywa kweqoqo, kungenzeka ukwenza isampula ngokuya ngemfanelo efundwayo. Umsebenzi wawo oyinhloko ukwahlukanisa uhlu lwezinto ezinhlobonhlobo eziningi zibe ngamaqembu angenangqondo. Njengombandela wokuhlanganisa, kusetshenziswa indawo yokuhlanganisa yokulinganisa noma ibanga le-Euclidean phakathi kwezinto ngepharamitha enikeziwe. Amanani asondele komunye nomunye ahlelwe ndawonye.

Yize lolu hlobo lokuhlaziya luvame ukusetshenziswa kakhulu kwezomnotho, lungasetshenziswa naku-biology (ukuhlukanisa izilwane), isayensi yezengqondo, yezokwelapha nakwezinye izindawo eziningi zomsebenzi wabantu. Ukuhlaziywa kweqembu kungasetjenziswa kusetshenziswa ithebhu ejwayelekile ye-Excel ngalezi zinhloso.

Isibonelo sokusetshenziswa

Sinezinto ezinhlanu ezibonakala ngamapharamitha amabili afundwayo - x futhi y.

  1. Sifaka ifomula yebanga le-Euclidean kulezi zindinganiso, ezibalwa ngokuya ngethempulethi:

    = I-ROOT ((x2-x1) ^ 2 + (y2-y1) ^ 2)

  2. Leli nani libalwa phakathi kwalezi zinto ezinhlanu. Imiphumela yokubala ibekwe ku-matrix yebanga.
  3. Sibheka phakathi kwamanani aqhele kakhulu ebangeni. Esibonelweni sethu, lezi yizinto 1 futhi 2. Ibanga eliphakathi kwabo ngu-4.123106, okungaphansi kokunye phakathi kwezinye izinto zalesi sizwe.
  4. Hlanganisa le datha eqenjini bese wenza i-matrix entsha lapho amanani atholakala khona 1,2 yenza njengento ehlukile. Lapho sihlanganisa matrix, sishiya amanani aphansi kusuka etafuleni langaphambilini lezinto ezihlanganisiwe. Siyaphinda futhi sibheke, phakathi kokuthi izakhi ibanga lincane kangakanani. Lesi sikhathi 4 futhi 5kanye nento 5 neqembu lezinto 1,2. Ibanga ngu-6,708204.
  5. Sifaka izinto ezibekiwe kwiqoqo elijwayelekile. Sakha i-matrix entsha ngokuya ngomgomo ofanayo nesikhathi esedlule. Okusho ukuthi, sifuna amanani amancane kakhulu. Ngakho-ke, siyabona ukuthi isethi yedatha yethu ingahlukaniswa ngamaqoqo amabili. Iqoqo lokuqala liqukethe izinto eziseduze kakhulu - 1,2,4,5. Kuhluzo lwesibili kithi, munye kuphela owethulwayo - 3. Kude kude nezinye izinto. Ibanga phakathi kwamaqoqo yi-9.84.

Lokhu kuqeda inqubo yokuhlukanisa inani labantu ngamaqembu.

Njengoba ukwazi ukubona, yize ngokuhlaziywa kweqoqo elijwayelekile kungabonakala njengenqubo eyinkimbinkimbi, empeleni, ukuqonda ama-nuances ale ndlela akunzima kangako. Into esemqoka ukuqonda iphethini eyisisekelo yokuhlela amaqembu.

Pin
Send
Share
Send