Uhlalutyo lokubuyisela kwi-Excel: Imiyalelo eneenkcukacha

Uhlalutyo lokubuyisela kwimeko yenye yezona ndlela zifunwayo zendlela yophando. Ngayo, kunokwenzeka ukuba kuseke inqanaba lempembelelo yamaxabiso azimeleyo kulwahlulo oluxhomekekileyo. Ukusebenza kweMicrosoft Excel kunezixhobo zenzelwe uhlobo olufanayo lohlalutyo. Masihlalutye ukuba zizimele kunye nendlela yokuzisebenzisa.

Ukuqhagamshela iphakheji yokuhlalutya

Kodwa, ukuze asebenzise umsebenzi ovumela ukuba wenze uhlalutyo lokubuyisela, kwako konke, kufuneka usebenze iphakheji yohlalutyo. Kuphela kuxa izixhobo ezifunekayo zale nkqubo ziya kuvela kwi-tepi yokugxotha.

1. Yiya kwi "Ifayile" yethebhu.



2. Yiya kwicandelo "leParameter".



3. Ifestile ye-Excel Ifestile ivuliwe. Yiya kwicandelwana "yongezelelo".



4. Ezantsi kwefestile yokuvula, sihlengahlengisa i-switch ibhloko "yolawulo" ukuya kwi "Excel Yongeza" kwiNdawo ", ukuba iye kwenye indawo. Cofa kwi "Pay Potter".



5. I-Window evulekileyo ifikeleleke kwi-Excel ye-Excel ye-Excel. Sibeka uphawu malunga "nephakheji yohlalutyo". Cofa kwiqhosha "Kulungile".

Ngoku, xa sifudukela kwi "DEAT" ithebhu, siza kubona iqhosha elitsha kwi "Uhlalutyo" isixhobo "se-Toolbar," uhlalutyo lwedatha ".

Iindidi zohlalutyo lokubuyisela

Zininzi iintlobo zokubhalwa:

• Parabolic;
• amandla;
• logarithmic;
• i-exponenial;
• ibonisa;
• hyperbolic;
• I-REGRAMY YOKUGQIBELA.

Siza kuthetha ngakumbi malunga nokuphunyezwa kohlobo lokugqibela lohlalutyo lokubuyisela kwimeko ye-Bestle ngaphezulu.

I-REGRAMY YOKUGQIBELA KWENKQUBO YOKUGQIBELA

Apha ngezantsi, njengomzekelo, itheyibhile iboniswa apho iqondo lobushushu lemihla ngemihla esitratweni, kwaye inani labathengi bevenkile ngosuku olufanelekileyo lokusebenza lubonisiwe. Masifumanise ngoncedo lohlalutyo lokubuyisela kwakhona, kanye indlela iimeko zemozulu ezinokubangela ukuba ubekho kwiziko lezorhwebo.

I-equation ngokubanzi yeRetrolnology yeNdlu yoLuntu yile ilandelayo: y = A0 + i-A1X1 + ... + ... + i-AKK. Kule formula, y kuthetha ukwahluka, impembelelo yezinto esizama ngazo ukuphonononga. Kwimeko yethu, eli linani labathengi. Ixabiso le-x lizinto ezahlukeneyo ezichaphazela ukwahluka. Iiparamitha a ziluvo lwemisebenzi. Oko kukuthi, ngabo babonisa ukubaluleka kwento ethile. Isalathiso se-k sibonisa inani lilonke lezi zinto.

1. Cofa kwiqhosha le "Data". Iposwe kwithebhu yasekhaya kwi "Uhlalutyo" i-Toolbar.



2. Ifestile encinci ivula. Kuyo, sikhetha into "yokuReta". Cofa kwiqhosha "Kulungile".



3. Useto lwe-Rersonence Pindows luvuliwe. Kuyanyanzeleka ukuba kuzalisa amasimi "yindawo yokufaka intente Y" kunye "nokufaka intente x". Zonke ezinye izicwangciso zingashiywa ngokuzenzekelayo.

   Kwintsimi yethutyana ye "Igalelo, chaza idilesi yoluhlu lweeseli apho izinto eziguqukayo zikhona, impembelelo yezinto esizama ukuyimisela. Kwimeko yethu, ezi ziya kuba ziiseli ze "Inani labathengi". Idilesi inokungeniswa ngesandla kwikhibhodi, kwaye unokukhetha ikholamu oyifunayo. Inketho yokugqibela kulula kakhulu kwaye ilunge ngakumbi.

   Kwindawo yokuqala "yentengo yentengo yegalelo, sifaka idilesi yeeseli zeeseli, apho le meko ifumaneka khona, ifuthe lakhe eguquguqukayo esifuna ukuyifaka. Njengoko kuchaziwe apha ngasentla, kufuneka senze ifuthe lobushushu kwinani labathengi abagcina, kwaye ke bangene kwidilesi yeeseli kwikholamu "yobushushu" ikholam. Oku kungenziwa ngeendlela ezifanayo "kwinani labathengi".

   

   Sebenzisa ezinye iilethi, unokuzibekela iilebheli, inqanaba lokuthembeka, lisoloko lisebenza zero, libonisa itshathi yethuba eliqhelekileyo, kwaye wenze ezinye iintshukumo. Kodwa, kwiimeko ezininzi, ezi seto azidingi kutshintshwa. Eyona nto kuphela yokunikela ingqalelo kwi-parameter yemveliso. Ngokungagqibekanga, ukukhutshwa kweziphumo zohlalutyo kwenziwa kwelinye iphepha, kodwa kuguqulwe iswitshi, unokuseta iziphumo kuluhlu oluthile kwitafile enedatha enedatha yedatha, okanye kwincwadi eyahlukileyo, Oko kukuthi, kwifayile entsha.

   

   Emva kokuba zonke iisetingi zisetiwe, cofa iqhosha u "Kulungile".

Uhlalutyo lweziphumo zohlalutyo

Iziphumo zohlalutyo lokubhala ziboniswa ngohlobo lwetafile eboniswe kwiseto.

Enye yezalathiso eziphambili yi-R-Square. Ibonisa umgangatho wemodeli. Kwimeko yethu, oku kulungelelwaniso yi-0.705 okanye malunga ne-70.5%. Eli linqanaba elamkelekileyo lomgangatho. Ukuxhomekeka ngaphantsi kwe-0.5 kubi.

Olunye isalathiso esibalulekileyo sikwiseli kwindawo yokuhlangana ye "Y-Interneday" umgca "we-Coefficients". Ibonisa ukuba leliphi ixabiso eliya kuba ku-Y, kwaye kwimeko yethu, eli linani labathengi, ngayo yonke eminye imibandela ilingana no-zero. Le thebhile ingama-58.04 kule theyibhile.

Ixabiso kwindawo yokubala "I-X1 eguqukayo" kunye ne "Coefficients" ibonisa inqanaba lokuxhomekeka kwe-X kwi-X. Ukusebenza kwe-1.31 kuthathwa njengeyona nto iphambili kwimpembelelo ephezulu yempembelelo.

Njengoko ubona, usebenzisa iNkqubo ye-Microsoft ekulula ukwenza itafile yohlalutyo lokubuyisela kwimeko yesiqhelo. Kodwa, ukusebenza nedatha efunyenwe kukuphuma, kwaye uqonde ubunyani babo, kuphela umntu olungisiweyo oya kuba nakho.