Ukuhlaziywa kwe-regression ku-Excel: Imiyalo enemininingwane

Ukuhlaziywa kwe-Recression kungenye yezindlela ezifunwa kakhulu zocwaningo lwezibalo. Ngayo, kungenzeka ukusungula izinga lethonya lamanani azimele ekuguqukeni okuthembekile. Ukusebenza kwe-Microsoft Excel kunamathuluzi ahloselwe uhlobo olufanayo lokuhlaziywa. Ake sihlaziye ukuthi bazimele bona nokuthi bazisebenzisa kanjani.

Ukuxhuma iphakethe lokuhlaziya

Kepha, ukuze usebenzise umsebenzi okuvumela ukuthi ufeze ukuhlaziya kabusha, okokuqala, udinga ukusebenzisa iphakethe lokuhlaziya. Yilapho-ke kuphela amathuluzi adingekayo kule nqubo ezovela ethepheni edingisiwe.

1. Hambisa kuthebhu "yefayela".



2. Iya engxenyeni ethi "Parameters".



3. Kuvulwa iwindi le-Excel Parameter. Iya esigatshaneni esithi "Addystructure".



4. Ngezansi kwewindi lokuvula, sihlele kabusha ukushintshwa kwebhulokhi "yokulawula" ku-"Excel Add-in" isikhundla, uma kungenye isikhundla. Chofoza inkinobho ethi "Go Go".



5. Iwindi elivuliwe litholakala ku-superskructure ye-Excelskructure. Sibeka umkhaza ngento "yokuhlaziya iphakethe". Chofoza inkinobho ethi "KULUNGILE".

Manje, lapho sithuthela kuthebhu ethi "Data", sizobona inkinobho entsha yamathuluzi "yokuhlaziya", "Ukuhlaziywa kwedatha".

Izinhlobo zokuhlaziywa kabusha kokubuyiselwa

Kunezinhlobo eziningi zokuphindisela:

• parabolic;
• amandla;
• i-logarithmic;
• I-Exponential;
• okubonakalayo;
• hyperbolic;
• Ukuhlehlisa umugqa.

Sizokhuluma kabanzi mayelana nokuqaliswa kohlobo lokugcina lokuhlaziywa kokubuyiselwa emuva ku-Exple More.

Ukuhlelwa kabusha komugqa ohlelweni lwe-Excel

Ngezansi, njengesibonelo, itafula lethulwa lapho izinga lokushisa lomoya lansuku zonke elijwayelekile emgwaqweni, futhi inani labathengi bezitolo ngosuku olufanele lokusebenza libonisiwe. Ake sithole ngosizo lokuhlaziywa kokubuyiselwa emuva, ngqo ukuthi isimo sezulu esinjani ngendlela yokushisa komoya singakuthinta kanjani ukubakhona kwesikhungo sezentengiselwano.

I-equation ejwayelekile yokuvuselelwa kwezinhlobo zezinhlobo eziqondile yile: y = A0 + A1X1 + ... + AKK. Kule formula, y kusho ukuguquguquka, ithonya lezinto lapho sizama ukuzihlola ngazo. Kuthu, lesi isibalo sabathengi. Inani le-X yizici ezahlukahlukene ezithinta ukuguquguquka. Amapharamitha arecifficients regression. Okungukuthi, yibona abanquma ukubaluleka kwento ethile. Inkomba k isho inani eliphelele lalezi zinto.

1. Chofoza inkinobho ethi "Ukuhlaziywa Kwedatha". Kuthunyelwa kuthebhu yasekhaya ku- "Ukuhlaziya" amathuluzi.



2. Kuvulwa iwindi elincane. Kuyo, sikhetha into ethi "regression". Chofoza inkinobho ethi "KULUNGILE".



3. Kuvulwa iwindi lezilungiselelo. Kuphoqelekile ukugcwalisa amasimu "isikhawu sokufaka y" kanye "nesikhathi sokufaka x". Zonke ezinye izilungiselelo zingashiywa ngokuzenzakalelayo.

   Inkundla ye- "Internal Chalvity Y", chaza ikheli lobubanzi be-cell lapho kutholakala khona okuhlukahlukene, ithonya lezinto esizama ngazo ukusungula ngazo. Kuthu, lezi kuzoba amaseli "wenombolo yabathengi". Ikheli lingafakwa ngesandla kwikhibhodi, futhi ungamane ukhethe ikholomu oyifunayo. Inketho yokugcina ilula kakhulu futhi ilula kakhulu.

   In the "Isikhashana Sokufaka X" field, sifaka ikheli lamaseli amaseli, lapho lezi zinto zitholakala khona, ezinethonya ekuguquguqukeni esikudingayo ukulifaka. Njengoba kushiwo ngenhla, kudingeka sithole imiphumela yokushisa kwenani labathengi bezitolo, ngakho-ke faka ikheli lamaseli ekholomu "lokushisa". Lokhu kungenziwa ngezindlela ezifanayo nakulo "Inani labathengi".

   

   Usebenzisa ezinye izilungiselelo, ungasetha amalebula, izinga lokuthembela, lihlala lize, libonise ishadi lokunokwenzeka okujwayelekile, futhi senze ezinye izenzo. Kepha, ezimweni eziningi, lezi zilungiselelo azidingi ukushintshwa. Ukuphela kwento okufanele unake ngayo kumapharamitha okukhipha. Ngokuzenzakalelayo, umphumela wemiphumela yokuhlaziywa kwenziwa kwelinye ishidi, kepha wakha inkinobho, ungabeka okuphumayo ebangeni elicacisiwe ekhasini elifanayo lapho itafula lomthombo litholakala khona, noma encwadini ehlukile, okungukuthi, kufayela elisha.

   

   Ngemuva kwazo zonke izilungiselelo zisethwe, chofoza inkinobho ethi "Kulungile".

Ukuhlaziywa kwemiphumela yokuhlaziywa

Imiphumela yokuhlaziywa kokubuyiselwa emuva iboniswa ngesimo setafula endaweni ekhonjiswe kuzilungiselelo.

Enye yezinkomba eziphambili yi-R-Square. Kubonisa ikhwalithi yemodeli. Kuthu, lokhu kuhlanganiswa kungu-0.705 noma cishe ama-70.5%. Lesi yileveli eyamukelekayo yekhwalithi. Ukuthembela ngaphansi kuka-0.5 kubi.

Enye inkomba ebalulekile itholakala esitokisini lapho kuhlangana umugqa we- "Y-Portsection" kanye nekholomu "ye-Coefficients". Kubonisa ukuthi yiliphi inani elizobe lise y, futhi kithi, lesi yisibalo sabathengi, nazo zonke ezinye izinto ezilingana no-zero. Leli thebula lingama-58.04 kuleli thebula.

Inani lokuhlangana kwesibalo esithi "I-X1 eguquguqukayo" ne- "Coefficients" libonisa izinga lokuncika kwe-y kusuka ku-X I-coeffeed ethembekile engu-1.31 ibhekwa njengenkomba ephezulu yethonya.

Njengoba ubona, usebenzisa uhlelo lwe-Microsoft Excel kulula kakhulu ukwenza itafula lokuhlaziywa kabusha kabusha. Kepha, ukusebenza nedatha etholwe lapho ephumayo, futhi uqonde ubuntu babo, umuntu olungiselelwe kuphela ozokwazi.