Kuongorora kuongororwa muExcel: Yakarongedzwa mirayiridzo

Kuongorora kwekudzokorora ndeimwe yeanonyanya kutsvaga nzira dzekutsvaga statistical. Nayo, zvinokwanisika kumisikidza iyo degree rekushanduka kwetsika dzakazvimiririra pane dzinoshanduka zvakasiyana. Iyo Microsoft Excel inoshanda ine zvishandiso zvakagadzirirwa kune yakafanana mhando yekuongorora. Ngationgororei kuti vanomiririra ivo pachavo uye kuti vangashandise sei.

Kubatanidza pasuru yekuongorora

Asi, kuitira kuti ushandise basa rinobvumira iwe kuti uite ongororo yekudzokorora, kutanga pane zvese, iwe unofanirwa kumisikidza iyo yekuongorora package. Chete ipapo zvishandiso zvinodiwa kuti zviitwe izvi zvichaonekwa patepi yehutapwa.

1. Famba mu "faira" tab.



2. Enda kune "parameter" chikamu.



3. Iyo Excel parameter windows inovhura. Enda kunzvimbo inotevera "yekuwedzera".



4. Pazasi pehwindo rekuvhura, isu tinogadzirazve switch mu "Kudzora" block kune iyo "Excel inowedzera-mu" chinzvimbo, kana chiri mune imwe chinzvimbo. Dzvanya pane iyo "Go bhatani".



5. Hwindo rakavhurwa rinowanikwa kune Excer's Superstructure. Isu tinoisa tick nezve "ongororo yekuongorora" chinhu. Dzvanya pane "OK" bhatani.

Zvino, patinoenda ku "data" tab, tichaona bhatani idzva mu "kuongororwa" Toolbar, "Kuongorora kweData".

Mhando dzekudzokorora kuongorora

Kune akati wandei marudzi ehutongi:

• parabolic;
• simba;
• logarithmic;
• exponential;
• undicative;
• hyperbolic;
• Mutsara wekudzora.

Isu tichazotaura zvakawanda nezvekushandiswa kwemhando yekupedzisira yekudzokorora kuongororwa mukubuditsa zvimwe.

Mutsara wekudzora mune iyo Excel chirongwa

Pazasi, semuenzaniso, tafura inoratidzwa umo iyo avhareji yemhepo tembiricha mumugwagwa, uye nhamba yevatengi vezvitoro kwezuva rakakodzera rekushanda rinoratidzwa. Ngatitsvagei nerubatsiro rwe yekudzokorora kuongorora, chaizvo maitiro emamiriro ekunze muchimiro chekupisa kwemhepo anogona kukanganisa kupinda kweiyo yekutengesa institution.

Iyo general equation yekudzorerwa kwemhando yemutsara ndeyekutevera: Y = A0 + A1X1 + ... + Akk. Mune ino formula, y inoreva kushanduka, pesvedzero yezvinhu zvatiri kuedza kuongorora. Mamiriro edu, iyi ndiyo nhamba yevatengi. Iko kukosha kwe x ndiyo zvinhu zvakasiyana-siyana zvinokanganisa zvinoshanduka. Parameter a ari coefficients kudzoreredzwa. Ndokunge, ndivo vanoziva kukosha kwechimwe chinhu. Iyo index k inoratidza huwandu hwehuwandu hwezvinhu izvi.

1. Dzvanya pane iyo "data yekuongorora" bhatani. Iyo inotumirwa munzvimbo yeimba yekumba mu "kuongorora" Toolbar.



2. Hwindo diki rinovhura. Mariri, isu tinosarudza chinhu "kudzoreredza". Dzvanya pane "OK" bhatani.



3. Regntion Zvirongwa hwindo rinovhura. Izvo zvinosungirwa kuzadza minda "Input Internal y" uye "Input Internal X". Zvimwe zvese zvigadziriso zvinogona kusiiwa nekumwe.

   Mu "Input Internal Internet Y" Shamba, taura kero yehuwandu hwemasero umo misiyano iripo, iyo pesvedzero yezvinhu zvatiri kuedza kumisikidza. Kwatiri, izvi zvichave masero e "nhamba yevatengi" ikholamu. Kero inogona kuiswa mumanzwiro kubva kukhibhodi, uye iwe unogona kungo sarudza iyo ikhoramu yaunoda. Iyo yekupedzisira sarudzo ndeye nyore nyore uye zvakanyanya nyore.

   Mu "Input Internet X" munda, tinopinda kero yemasero emasero, pane chinhu ichi chiri kuwanikwa, chine simba pane kushanduka kwatinoda kuisa. Sezvataurwa pamusoro apa, isu tinofanirwa kumisikidza mhedzisiro yekushisa pane huwandu hwevatengi vekutengesa, uye saka pinda kero yemasero mu "tembiricha" ikholamu. Izvi zvinogona kuitwa nenzira dzakafanana senge mu "nhamba yevatengi" munda.

   

   Kushandisa mamwe marongero, iwe unogona kuseta zvinyorwa, iyo mwero wekuvimbika, kugara uchienda ku zero, ratidza chati yeakajairika, uye ita zvimwe zviito. Asi, kazhinji, aya marongero haafanire kuchinjwa. Chinhu chega chekuteerera kune kune iyo inobuda paramita. Nekusarudzika, kubuda kwemhedzisiro yekuongorora kunoitwa pane imwe shizha, asi kuongorora switch, iwe unogona kuseta iyo yekubuda mune yakatarwa renji pane iyo tafura ine data, kana mubhuku rakaparadzana, ndiko kuti, mune faira idzva.

   

   Mushure mekunge marongero ese akaiswa, tinya pane "OK" bhatani.

Kuongororwa kwemhedzisiro yekuongorora

Mhedzisiro yekudzokorora kuongororwa inoratidzwa muchimiro chetafura munzvimbo yakaratidza mumamiriro ezvinhu.

Imwe yeiyo main chiratidzo ndeye r-mraba. Inoratidza kunaka kwemuenzaniso. Pane yedu nyaya, iyi coefficient ndeye 0.705 kana anenge 70.5%. Ichi chiitiko chinogamuchirika chehunhu. Kutsamira pasi pe 0.5 yakaipa.

Chimwe chinhu chakakosha chiratidzo chiri muchitokisi pakupindirana kwe "y-kupindirana" mutsara uye "coefficients" column. Zvinoratidza kuti kukosha kwacho kuchave kuri mu y, uye kwatiri, iyi ndiyo nhamba yevatengi, nezvimwe zvinhu zvese zvakaenzana ne zero. Iyi tafura ndeye 58.04 mune ino tafura iyi.

Iko kukosha kune kupindirana kwehuwandu Iyo coefficient ye1.31 inoonekwa seyakanyanya chiratidzo chekumanikidza.

Sezvauri kuona, uchishandisa iyo Microsoft Excel chirongwa chiri nyore kuita furafura yekudzokorora kuongorora. Asi, kushanda neiyo data yakawanikwa pakubuda, uye unzwisise kukosha kwavo, munhu aingogadzirira achakwanisa.