Chimodzi mwa zida zothetsera mavuto a zachuma ndi kusanthula masango. Ndili, masango ndi zinthu zina zadetazi zimagawidwa m'magulu. Njira iyi ingagwiritsidwe ntchito mu Excel. Tiyeni tiwone momwe izi zikuchitidwira.
Kugwiritsa ntchito kusanthula masango
Mothandizidwa ndi kusanthula masango ndi kotheka kupanga sampuli pogwiritsa ntchito zomwe zikufufuzidwa. Ntchito yake yaikulu ndi kugawaniza magulu osiyanasiyana omwe ali osiyana. Monga momwe zimakhalira, magulu awiriwa amodzimodzi kapena gawo la Euclidean pakati pa zinthu ndi parameter yoperekedwa. Makhalidwe oyandikana ali pamodzi.
Ngakhale kuti kawirikawiri kafukufukuyu amagwiritsidwa ntchito muchuma, angagwiritsenso ntchito mu biology (chifukwa cha kagulu ka nyama), psychology, mankhwala ndi m'malo ena ambiri a ntchito. Kusanthula kwa magulu kungagwiritsidwe ntchito pogwiritsira ntchito Excel toolkit cholinga ichi.
Chitsanzo chogwiritsa ntchito
Tili ndi zinthu zisanu, zomwe zimadziwika ndi magawo awiri - x ndi y.
- Yesetsani kuzinthu izi za Euclidean distance formula, zomwe zikuwerengedwa kuchokera pazithunzi:
= ROOT ((x2-x1) ^ 2 + (y2-y1) ^ 2) - Mtengo umenewu ukuwerengedwa pakati pa zinthu zisanu. Zotsatira za chiwerengero zimayikidwa pamtunda wautali.
- Ife tikuyang'ana, pakati pa zomwe zimayendera mtunda ndi wosachepera. Mu chitsanzo chathu, izi ndi zinthu. 1 ndi 2. Mtunda pakati pawo ndi 4,123106, womwe uli pakati pa zinthu zina zilizonsezi.
- Timagwirizanitsa deta iyi mu gulu ndipo timapanga chiwerengero chatsopano chomwe chimayendera 1,2 imani monga chinthu chosiyana. Mukamaliza masewerowa, musiye miyambo yaying'ono kwambiri kuchokera pa tebulo lapitalo kuti mukhale pamodzi. Apanso tikuyang'ana, pakati pa zinthu zomwe mtunda uli wochepa. Nthawi ino ndi 4 ndi 5komanso chinthu 5 ndi gulu la zinthu 1,2. Mtunda ndi 6,708204.
- Timaonjezera zinthu zomwe zafotokozedwa kumagulu wamba. Timapanga matrix atsopano mofanana ndi nthawi yoyamba. Ndikokuti, tikuyang'ana miyezo yaying'ono kwambiri. Choncho, tikuwona kuti chiwerengero chathu cha deta chingagawidwe m'magulu awiri. Mphindi yoyamba ndi zinthu zowonjezereka - 1,2,4,5. M'chigawo chachiwiri pambali yathu pali chinthu chimodzi chokha - 3. Ndili kutali ndi zinthu zina. Mtunda pakati pa masango ndi 9.84.
Izi zikukwaniritsa ndondomeko yogawira anthu kukhala magulu.
Monga momwe mukuonera, ngakhale kusanthula kwa masango ambiri kumaoneka ngati kovuta, koma kwenikweni si kovuta kumvetsa maunthu a njira iyi. Chinthu chofunikira kwambiri kumvetsetsa chiyanjano choyambirira cha magulu m'magulu.
