Mukati
Microsoft Excel yakagara ichitsvakwa-software chigadzirwa nekuda kweseti yakakura yeakasiyana maturusi ekushanda ayo anorerutsa kushanda nechirongwa uye nekumhanyisa maitiro akasiyana. Kuve nechiyero chakakwana cheExcel zvikamu, unogona kukwirisa zvakanyanya maitiro mazhinji uye mabasa. Imwe yakadaro inobatsira chinhu ndeyeData Analysis.
Zvinokosha! Iyi pasuru haina kuiswa pamakomputa nekukasira, saka kuisirwa kunofanirwa kuitwa nemaoko kana zvichidikanwa.
Ichi chinyorwa chichakurukura nzira iri nyore uye inoshanda yekumisikidza software package ine nhanho-ne-nhanho mirairo. Iwe zvakare uchawana mirairo yakapusa yekuidhawunirodha kana isina kuiswa pakombuta yako.
Chii basa iri muExcel, uye nei richidikanwa
Iri basa rakanakira uye rinobatsira kana paine kudikanwa kwekuita kuverenga kwakaoma kana kusimbiswa kweiyo data yakapinda, kazhinji zvinotora nguva yakawanda kana kuti hazvigoneke kuzviita nemawoko zvachose. Mumamiriro ezvinhu akadaro, mukana unokosha kubva kuExcel "Data Analysis" unouya kuzonunura. Inokutendera kuti utarise nekukurumidza uye nyore uye unyore yakawanda data, kurerutsa mabasa ako ebasa uye kukuchengetedza nguva yakawanda. Mushure mekushandisa basa iri, chati icharatidzwa pane pepa nemhedzisiro yecheki uye kupatsanurwa muzvikamu.
Zvakakosha kufunga! Kana zvichidikanwa kuongorora mapepa akati wandei, zvinokurudzirwa kuburitsa murairo kune rimwe nerimwe bepa zvakasiyana kuitira kuti rive nerepoti rayo kune rimwe nerimwe rawo.
Kana iyo purogiramu inodiwa yakatoiswa pakombiyuta kushandisa basa iri, saka unofanira kuenda kune "Data" tab, uye ku "Analysis" tab uye sarudza "Data analysis" sarudzo. Paunenge uchidzvanya pairi, chirongwa chinotanga uye nekukurumidza chinopa mhedzisiro yaunoda mushure mekugadzirisa otomatiki zvese zvinopinda. Kana basa iri risipo, unofanira kudhawunirodha "Analysis Package". Iyi ndeyepamusoro Excel data package inopa mamwe maficha uye mashandiro ekushanda nawo.
Maitiro ekugonesa kuwedzera-mukati muExcel
Mirayiridzo yekugonesa iyo Data Analysis yekuwedzera:
- Enda kune "Faira" tab.
- Sarudza Options sarudzo.
- Sarudza "Add-ons" sarudzo.
- Enda kune "Excel Add-ins" tab.
- Tarisa bhokisi riri pedyo ne "Analysis Toolkit" sarudzo.
- Simbisa sarudzo yako nekudzvanya OK.
Kana iyo yaunoda sarudzo isina kuwanikwa, tevera mirairo iri pasi apa:
- Enda kune "Inowanikwa ma-add-ons" menyu.
- Sarudza "Bhurawuza" sarudzo.
- Kana meseji "Data Analysis ToolPak isina kuiswa" ikabuda, tinya Hongu.
- Maitiro ekuisa software data package atanga.
- Mirira kuti kuiswa kwacho kupedze uye pasuru ichave yagadzirira kushandiswa.
Ndeupi mutsauko pakati pepakeji activation muExcel 2010, 2013 uye 2007
Iyo activation process yeiyi yekuwedzera yakada kufanana kune ese matatu mavhezheni, aine mutsauko mudiki pakutanga kwechirongwa chekumisikidza. Mune shanduro itsva, unofanirwa kuenda kune "Faira" tab kuti uite, uye muvhezheni 2007 hapana tabhu yakadaro. Kuti uite iyo pasuru mune iyi vhezheni, unofanirwa kuenda kuMicrosoft Office menyu mukona yepamusoro kuruboshwe, iyo inoratidzwa nedenderedzwa rine mavara mana. Iyo yekuwedzera activation uye yekuisa maitiro anenge akafanana kune ese mavhezheni matsva eWindows uye ekare.
Excel kuongorora zvishandiso
Mushure mekuisa uye kumhanya iyo "Data Analysis" package, anotevera mabasa anozove aripo kuti iwe ushandise:
- samples;
- kugadzira histograms;
- random number generation;
- kugona kuita chinzvimbo (muzana uye ordinal);
- marudzi ose ekuongorora - kuderera, kupararira, kuwirirana, covariance nevamwe;
- shandisa Fourier shanduko;
- uye mamwe mabasa anoshanda ekuverenga, kuronga magirafu uye kugadzirisa data munzira dzakawanda.
Neiyi nhanho-ne-nhanho kuraira, unogona kukurumidza kubatanidza iyo yekuongorora pasuru muExcel, zvichabatsira kurerutsa basa rekuita rakaomarara rekuongorora basa uye nyore kugadzirisa kunyange yakawanda yakawanda yedata uye huwandu. Kuisa uye kumisa pasuru kuri nyore uye hakutore nguva yakawanda, kunyangwe mushandisi weanovice anogona kubata iri basa.