Ukuhlaziywa kokuhlehliswa kungenye yezindlela ezidumile zocwaningo lwezibalo. Ngosizo lwayo kungenzeka ukusungula isilinganiso sethonya lamanani azimele ekwehlukaneni okuthembekile. Ukusebenza kwe-Microsoft Excel kunamathuluzi aklanyelwe ukwenza lolu hlobo lokuhlaziywa. Ake sibheke ukuthi bayini nokuthi bangazisebenzisa kanjani.
Iphakethe lokuhlaziywa kokuxhumeka
Kepha, ukuze usebenzise umsebenzi okuvumela ukuthi wenze ukuhlaziya kokubuyiswa, okokuqala, udinga ukwenza kusebenze Iphakheji Lokuhlaziya. Yilapho-ke kuphela amathuluzi adingekayo ale nqubo azovela kuthebhu ye-Excel.
- Hambisa kuthebhu Ifayela.
- Iya esigabeni "Izinketho".
- Kuvulwa iwindows ongakhetha kukho. Iya esigatshaneni "Okengezwayo".
- Engxenyeni engezansi yewindows evulayo, hlela kabusha inkinobho ebhlokini "Abaphathi" esikhundleni I-Excel-Ins-Insuma esesimweni esehlukile. Chofoza inkinobho Iya ku.
- Kuvulwa iwindi lokungezelelwa kwe-Excel. Bheka ibhokisi eliseduze Iphakheji Yokuhlaziya. Chofoza inkinobho ethi "Kulungile".
Manje uma siya kuthebhu "Idatha"kubambo kubhokisi lamathuluzi "Ukuhlaziywa" sizobona inkinobho entsha - "Ukuhlaziywa kwedatha".
Izinhlobo Zokuhlaziywa Kokuqothuka
Kunezinhlobo eziningi zokucindezelwa:
- ubuSathane;
- exponential;
- i-logarithmic;
- exponential
- inkomba;
- hyperbolic
- ukuhlehlisa okuqondile.
Sizokhuluma kabanzi ngokuqaliswa kohlobo lokugcina lokuhlaziywa kwe-regcel e-Excel.
Ukuqanjwa kwamalayini ku-Excel
Ngezansi, njengesibonelo, kwethulwa kwetafula elibonisa isilinganiso sokushisa somoya nsuku zonke emgwaqweni, kanye nenani labathengi losuku olusebenzayo. Ake sibheke kusetshenziselwa ukucubungula i-regression analysis ukuthi isimo sezulu ngokuqondile ngendlela yokushisa komoya singabathinta kanjani abakhona kwesikhungo sokuhweba.
I-equation ye-regression regression ejwayelekile imi kanjena:Y = a0 + a1x1 + ... + akhk. Kule formula Y kusho okuguqukayo, umthelela wezinto esizama ukufunda ngazo. Esimweni sethu, lokhu kuyinombolo yabathengi. Inani x yizici ezahlukahlukene ezinethonya ukuguquguquka. Amapharamitha a ama-coefficients wokucabanga. Lokho wukuthi, yibona abona ukubaluleka kwento eyodwa noma enye. Inkomba k kusho inani eliphelele lalezi zinto ezifanayo.
- Chofoza inkinobho "Ukuhlaziywa kwedatha". Ibekwe kuthebhu. "Ikhaya" ebhokisini lamathuluzi "Ukuhlaziywa".
- Kuvuleka iwindi elincane. Kuyo, khetha into "Regression". Chofoza inkinobho "Kulungile".
- Iwindi lezilungiselelo zokubamba liyavula. Izinkambu ezidingekayo kuyo "Ukufakwa kwesikhashana kwe-Y" futhi "Isikhashana sokufaka X". Zonke ezinye izilungiselelo zingashiywa ngokuzenzakalelayo.
Ensimini "Ukufakwa kwesikhashana kwe-Y" chaza ikheli lobubanzi beseli lapho idatha eguquguqukayo itholakala khona, umthelela wezinto esizama ukuthola kuwo. Kithi, lokhu kuzoba amaseli wekholamu "Inombolo yamakhasimende". Ikheli lingafakwa ngesandla kusuka kukhibhodi, noma ungamane ukhethe ikholomu oyifunayo. Inketho yokugcina ilula kakhulu futhi ilula kakhudlwana.
Ensimini "Isikhashana sokufaka X" sifaka ikheli lobubanzi beseli lapho idatha yento enethonya layo ekuguqukeni esifuna ukubeka. Njengoba kushiwo ngenhla, sidinga ukuthola umphumela wokushisa kwenani lamakhasimende wesitolo, ngakhoke faka ikheli lamaseli kukholomu "Okushisa". Lokhu kungenziwa ngezindlela ezifanayo nasenkabeni ethi "Inani lamakhasimende".
Usebenzisa ezinye izilungiselelo, ungabeka amalebula, ileveli yokuthembeka, zero engaguquki, bonisa igrafu yokuthola okuvamile, futhi wenze ezinye isenzo. Kepha, ezimeni eziningi, lezi zilungiselelo azidingi ukushintshwa. Ukuphela kwento okufanele unake ngayo yimingcele yokuphuma. Ngokuzenzakalelayo, imiphumela yokuhlaziywa iboniswa kwelinye iphepha, kepha ngokuhambisa inkinobho, ungabeka okukhishwayo ohlwini olubekiwe kushidi elifanayo netafula elinemininingwane yomthombo, noma encwadini ehlukile, okungukuthi kufayela elisha.
Ngemuva kokuthi wonke amasethingi esethiwe, chofoza inkinobho "Kulungile".
Ukuhlaziywa kokuhlaziywa
Imiphumela yokuhlaziywa kokuphinda ikhonjiswe ngendlela yetafula endaweni echazwe kuzilungiselelo.
Enye yezinkomba eziphambili Kukalwe-kabili. Kubonisa ikhwalithi yemodeli. Esimweni sethu, lokhu kuhlangana kungama-0.705 noma cishe ama-70.5%. Leli yizinga elamukelekayo lekhwalithi. Ukuncika kwengaphansi kuka-0.5 kubi.
Enye inkomba ebalulekile itholakala esitokisini ekuxhumaneni komugqa. Y ukuhlangana nekholamu Izimo. Kubonisa ukuthi yiliphi inani uY ozoba nalo, futhi kithi, leli inani lamakhasimende, nazo zonke ezinye izinto ezilingana no-zero. Kuleli thebula, leli nani lingama-58.04.
Ivelu ekuhlanganweni kwegrafu I-X1 eguqukayo futhi Izimo ikhombisa izinga lokuncika kwe-Y ku-X. Esimweni sethu, leli izinga lokuncika kwenombolo yamakhasimende ezitolo kumazinga okushisa. I-1.31 esebenzayo ibhekwa njengesibonakaliso esiphakeme sethonya.
Njengoba ukwazi ukubona, usebenzisa uhlelo lweMicrosoft Excel, kulula kakhulu ukuhlanganisa itafula lokuhlaziywa kokulawula. Kepha, ngumuntu oqeqeshiwe kuphela ongasebenza nedatha etholwe kokukhishwayo, futhi aqonde umongo wabo.
