Indlela Yezikwele Encane Kakhulu E-Excel

Indlela encane kakhulu yesikwele iyinqubo yezibalo yokwakha i-equation eqondile, ebingakunela kakhulu isethi yemigqa emibili yezinombolo. Inhloso yokusebenzisa le ndlela ukunciphisa iphutha eliphelele le-quadratic. Uhlelo lwe-Excel lunamathuluzi le ndlela engasetshenziswa ngalo lapho kubalwa. Masibhekane nokuthi kwenziwa kanjani.

Ukusetshenziswa kwendlela e-Excel

Indlela ye-Squares Encane (i-MNC) iyincazelo yezibalo yokuncika kokuhluka okukodwa kusuka kwesibili. Ingasetshenziswa lapho ubikezela.

Inika amandla ukwengeza okungeziwe "ukusesha kwesixazululo"

Ukuze usebenzise i-MNA ku-Excel, udinga ukunika amandla okungeza "kwesixazululo", okukhutshazwe ngokuzenzakalelayo.

1. Iya kuthebhu ethi "File".



2. Chofoza isigaba segama elithi "Parameters".



3. Efasiteleni elivula, yeka ukukhetha esigatshaneni se- "Add-in".



4. Evikini le- "Management" elisekupheleni kwewindows, setha inkinobho ethi "Excel Add-in" (uma elinye inani lisethiwe) bese uchofoza inkinobho ethi "Go ...".



5. Kuvulwa iwindi elincane. Sibeka kukhokha eduze kwepharamitha "yesisombululo". Chofoza inkinobho ethi "KULUNGILE".

Manje umsebenzi wokusebenza kwesixazululo ku-Excel ucushiwe, futhi amathuluzi ayo avele ethepheni.

Isifundo: Sesha izixazululo ku-Efpelle

Izimo zenkinga

Sichaza ukusetshenziswa kwe-MNK esibonelweni esithile. Sinemigqa emibili yezinombolo X. na- y. Ukulandelana kwawo kwethulwa esithombeni esingezansi.

Ukuncika okunikezwe ngokunembe kakhulu kungachaza umsebenzi:

y = A + NX

Ngasikhathi sinye, kuyaziwa ukuthi lapho x = 0. y. Futhi 0 . Ngakho-ke, le equation ingachazwa umlutha y = nx..

Kufanele sithole isamba esincane sezikwele zomehluko.

Isixazululo

Ake siphendukele encazelweni yohlelo lokusebenza oluqondile lwendlela.

1. Ngakwesobunxele kwencazelo yokuqala X. beka idijithi 1 . Kuzoba inani eliseduze lenani lokuqala le-coefficient N..



2. Ngakwesokunene sekholomu y. Faka enye ikholomu - nx. Esitokisini sokuqala sale kholamu, bhala ukuphindaphindwa kwefomula ye-coefficient N. esitokisini sokuhluka kokuqala X. . Ngasikhathi sinye, isixhumanisi esiya enkombeni enobunzima benziwe ngokuphelele, ngoba leli nani ngeke lishintshe. Chofoza inkinobho ethi Enter.



3. Usebenzisa umaki wokugcwaliswa, kopisha leli formula kulo lonke uhla lwetafula elingezansi.



4. Kwiseli elihlukile, bala isamba somehluko ezigcawini zamanani y. na- Nx. . Ukuze wenze lokhu, chofoza inkinobho ethi "Faka umsebenzi".



5. Emsebenzini wemisebenzi "evula, ngifuna irekhodi" I-Sumkvson ". Khetha bese uqhafaza inkinobho ethi "KULUNGILE".



6. Iwindi lokuphikisana livuleka. Ensimini ethi "Massive_x", sifaka uhla lwamangqamuzana ekholomu y. . Ensimini ethi "Massive_y", sifaka uhla lwamangqamuzana ekholomu Nx. . Ukuze ufake amanani, mane nje ufake isikhombisi enkundleni bese ukhetha ububanzi obufanele ephepheni. Ngemuva kokungena, cindezela inkinobho ethi "Kulungile".



7. Iya kuthebhu "yedatha". Ethepheni ku-Ithuluzi "lokuhlaziya" lichofoza inkinobho ethi "Solution Search".



8. Iwindi lepharamitha liyavula. Inkundla ye- "OPPPIZE TARGIGE WESEPT", chaza ikheli leseli ngefomula "I-Sumkvson". Epharadeni le- "BC", qiniseka ukusetha ukushintshwa kwesikhundla esithi "Ubuncane". Ensimini ethi "Ukuguqula Iseli", chaza ikheli ngenani le-coefficient N. . Chofoza inkinobho ethi "Thola Isixazululo".



9. Isixazululo sizokhonjiswa esitokisini se-coefficiery N. . Leli nani lizoba yisikwele esincane kakhulu somsebenzi. Uma umphumela wanelisa umsebenzisi, bese uqhafaza inkinobho ethi "Kulungile" kukhetho.

Njengoba ukwazi ukubona, ukusetshenziswa kwendlela encane yendlela yesikwele kuyinqubo eyinkimbinkimbi yemathematics. Sikubonise ngesenzo esibonelweni esilula, futhi kunezimo ezinzima kakhulu. Kodwa-ke, iMicrosoft Excel Toolkit yakhelwe ukwenza lula ukubala.