Indlela yokwenza izikwele ezimbalwa yindlela yokwenza izibalo zokwakha ukulingana okulingana okuzohambisana kakhulu neqoqo lezinombolo ezimbili zezinombolo. Inhloso yalo mkhuba ukunciphisa iphutha lesikwele. I-Excel ineamathuluzi okusebenzisa le ndlela yokubala. Ake sibone ukuthi lokhu kwenziwa kanjani.
Ukusebenzisa indlela ku-Excel
Indlela yezingqimba ezincane (OLS) incazelo yemathemikhali yokuxhomeka kokuguquguquka okukodwa okwesibili. Ingasetshenziselwa ukubikezela.
Ukunika amandla i- "Solution Finder" engeza
Ukuze usebenzise i-OLS ku-Excel, udinga ukunika amandla ukungena "Funa isisombululo"okukhutshaziwe ngokuzenzakalelayo.
- Iya kuthebhu "Ifayela".
- Chofoza egameni lesigaba "Izinketho".
- Ewindwangu evulekile, yeka ukukhethwa kwesigatshana Engeza-ons.
- Ku-block "Ukuphathwa"okuyinto engxenyeni engezansi yewindi, setha inkinobho endaweni Faka i-Excel (uma enye ihlelwa kuyo) bese ucindezela inkinobho "Hamba ...".
- Iwindi elincane livuleka. Sibeka uphawu kulo mayelana nepharamitha "Ukuthola isisombululo". Sicindezela inkinobho "Kulungile".
Umsebenzi manje Ukuthola isixazululo I-Excel isebenze, futhi amathuluzi ayo avela kuthebhu.
Isifundo: Sesha isisombululo ku-Excel
Izimo zenkinga
Sichaza ukusetshenziswa kweMNC ngesibonelo esithile. Sinemigqa emibili yezinombolo x futhi y, ukulandelana kwalo okuvezwa esithombeni esingezansi.
Iningi ngokunembile lokhu kuxhomekeka kungachaza umsebenzi:
y = a + nx
Ngesikhathi esifanayo, kwaziwa ukuthi nge x = 0 y futhi lilingana 0. Ngakho-ke, lesi sibalo singachazwa ngokuthembela y = nx.
Kufanele sithole isibalo esincane semikhakha yokwahlukana.
Isixazululo
Masiqhubekele ekuchazeni ukusetshenziswa okuqondile kwalendlela.
- Ngakwesokunxele kwexabiso lokuqala x ufake inombolo 1. Lokhu kuzoba yinani elilinganiselwe lokubaluleka kokuqala kwe-coefficient. n.
- Ngakwesokudla sekholomu y engeza ikholomu eyodwa - nx. Esitokisini sokuqala salesi kholomu, bhala ifomula yokwandisa i-coefficient n esakhiweni sokuqala variable x. Ngesikhathi esifanayo, senza ireferensi yensimu nge-coefficient ngokuphelele, ngoba le nzuzo ngeke ishintshe. Chofoza inkinobho Ngena.
- Ukusebenzisa uphawu lokugcwalisa, kopisha leli fomula kuwo wonke uhla lwethebula kukholomu elingezansi.
- Esitokisini esithile, sibala inani lemikhakha yamanani. y futhi nx. Ukwenza lokhu, chofoza inkinobho "Faka umsebenzi".
- Kuvuliwe "Umphathi wemisebenzi" ngifuna irekhodi "SUMMKVRAZN". Khetha bese uchofoza inkinobho. "Kulungile".
- Iwindi lempikiswano ivuleka. Ensimini "I-Array_x" faka ububanzi beseli yekholomu y. Ensimini "I-Array_y" faka ububanzi beseli yekholomu nx. Ukuze ufake amanani, vele ubeke isikhombisi endle bese ukhetha ibanga elifanele kushidi. Ngemva kokungena uqhafaza inkinobho "Kulungile".
- Iya kuthebhu "Idatha". On the tape ebhodini amathuluzi "Ukuhlaziywa" cindezela inkinobho "Ukuthola isisombululo".
- Iwindi yezimangalo zalesi thuluzi ivula. Ensimini "Ukwandisa Umsebenzi Wezinkomba" ucacise ikheli leseli ngefomula "SUMMKVRAZN". Kupharamitha "Kuze kube" Qinisekisa ukusetha inkinobho ukuma "Okuncane". Ensimini "Ukushintsha amangqamuzana" sichaza ikheli elinenani le-coefficient n. Sicindezela inkinobho "Thola isixazululo".
- Isixazululo sizoboniswa esakhiweni se-coefficient. n. Leli xabiso lizoba yisiteji esincane kakhulu somsebenzi. Uma umphumela ukwanelisa umsebenzisi, bese uchofoza inkinobho "Kulungile" ewindini elengeziwe.
Njengoba singabona, ukusetshenziswa kwesindlela esingaphansi kwesigcawu kuyinkambinkimbi eyinkimbinkimbi yemathematika. Sikubonise ngesenzo ngesibonelo esilula, futhi kukhona amacala amaningi kunzima kakhulu. Noma kunjalo, i-toolkit ye-Microsoft Excel iklanyelwe ukwenza lula izibalo ezenziwe ngangokunokwenzeka.
