Indlela yesikwele esincane kunazo zonke inqubo inqubo yezibalo yokwakha i-equation emugqa engaqondana kakhulu neqoqo lamanani amabili. Inhloso yokusebenzisa le ndlela ukunciphisa iphutha eliphelele lama-quadratic. I-Excel inamathuluzi ongasebenzisa ngayo le ndlela ekubaleni kwakho. Ake sibheke ukuthi kwenziwa kanjani lokhu.
Kusetshenziswa indlela ese-Excel
Indlela yesikwele esincane (ubuncane bezikwele) yincazelo yezibalo yokuxhomekeka kokuhluka okukodwa kwesibili. Ingasetshenziswa ukubikezela.
Inika amandla Isengezo Sokusesha Solution
Ukuze usebenzise i-OLS e-Excel, udinga ukunika amandla isengezo “Ukuthola Isixazululo”ekhutshazwe ngokuzenzakalela.
- Iya kuthebhu Ifayela.
- Chofoza igama lesigaba "Izinketho".
- Ewindini elivulayo, misa ukukhethwa kusigatshana esingezansi "Okengezwayo".
- Ebhlokini "Abaphathi"etholakala ezansi kwewindi, setha ukushintshela ku Kengeza i-Excel (uma elinye inani lisethelwe kulo) bese uchofoza inkinobho "Hambani ...".
- Kuvuleka iwindi elincane. Beka umkhaza kuyo eduze kwepharamitha "Ukuthola isisombululo". Chofoza inkinobho "Kulungile".
Umsebenzi manje Sesha isisombululo icushiwe e-Excel, futhi amathuluzi ayo avela kubambo.
Isifundo: Ukuthola isisombululo ku-Excel
Izimo zomsebenzi
Sichaza ukusetshenziswa kwe-OLS esibonelweni esithile. Sinemigqa emibili yezinombolo x futhi yukulandelana kwabo kuboniswa esithombeni esingezansi.
Umsebenzi ungachaza lokhu kuncika ngokunembe kakhulu:
y = a + nx
Ngaphezu kwalokho, kuyaziwa ukuthi nge x = 0 y futhi ziyalingana 0. Ngakho-ke, leli zibalo lingachazwa ngokuncika y = nx.
Kufanele sithole isamba esincane sezikwere zomehluko.
Isixazululo
Siphendukela ekuchazweni kwesicelo ngqo sendlela.
- Kwesobunxele yenani lokuqala x faka inombolo 1. Leli kuzoba inani elilinganiselanayo lenani lokuqala lenethiwekhi n.
- Ngakwesokudla kwekholamu y engeza enye ikholomu - nx. Esitokisini sokuqala sale kholamu, sibhala ifomula yokuphindaphindeka okwanele n iseli ngalinye lokwehluka kokuqala x. Ngasikhathi sinye, senza isixhumanisi senkambu ngenhlawulo ephelele, ngoba leli nani ngeke lishintshe. Chofoza inkinobho Ngena.
- Usebenzisa umaki wokugcwalisa, kopisha leli formula kulo lonke uhla lwethebula kwikholamu elingezansi.
- Esitokisini esihlukile, sibala inani lokungafani kwezikwele zamanani y futhi nx. Ukuze wenze lokhu, chofoza inkinobho "Faka umsebenzi".
- Kuvuliwe "Umsebenzi Wizard" ngifuna irekhodi SUMMKVRAZN. Khetha bese uchofoza inkinobho. "Kulungile".
- Iwindi lokuphikisana liyavula. Ensimini "I-Array_x" faka uhla lwamaseli ekholamu y. Ensimini Array_y faka uhla lwamaseli ekholamu nx. Ukuze ufake amanani Ngemuva kokungena, chofoza inkinobho "Kulungile".
- Iya kuthebhu "Idatha". Kubambo olubekwe ebhokisini lamathuluzi "Ukuhlaziywa" chofoza inkinobho "Ukuthola isisombululo".
- Iwindi lokukhethwa kwaleli thuluzi liyavula. Ensimini "Lungiselela umsebenzi wenhloso" chaza ikheli leseli ngefomula SUMMKVRAZN. Ipharamitha "Ku" qiniseka ukubeka switch "Ubuncane". Ensimini "Ukushintsha Amaseli" chaza ikheli ngenani elifanelekile n. Chofoza inkinobho "Thola ikhambi".
- Isixazululo sizoboniswa kuseli elisebenzayo n. Yileli inani elizoba yisikwele esincane somsebenzi. Uma umphumela wanelisa umsebenzisi, bese uchofoza inkinobho "Kulungile" ewindini elengeziwe.
Njengoba ubona, ukusetshenziswa kwendlela yezigcawu okungenani kuyinqubo eyinkimbinkimbi yezibalo. Sikhombise ukusebenza ngesibonelo esilula, futhi kukhona amacala amaningi axaka kakhulu. Noma kunjalo, i-Microsoft Excel toolkit yakhelwe ukwenza izibalo zibe lula ngangokunokwenzeka.
