Maitiro Ekuita Kuti Udzidze Data Mukuratidzira: Kushanda Mirayiridzo

Iyo Excel chirongwa hachisi chinyorwa cheTabular chete, asi zvakare chishandiso chine simba kune dzakasiyana siyana masvomhu uye huwandu hwekuverenga. Iyo Appendix ine huwandu hwakakura hwemabasa akagadzirirwa aya mabasa. Chokwadi, hazvisi zvese izvi zvinhu zvinogadziriswa nekusarudzika. Ndozvazvakaita kuti mabasa akavanzika akavanzika anosanganisira seti yekuongorora kwe data. Ngatitsvagei kuti zvinogoneka sei.

Kutendeuka pane chishandiso chivharo

Kuti utore mukana wezvinhu izvo "kuongorora kwedata" Iyo algorithm yezviito izvi zvakada kufanana neshanduro dzeBhaibheri

Activation

1. Enda kune "faira" tab. Kana iwe uri kushandisa iyo vhezheni yeMicrosoft Excel



2. Dzvanya pane chimwe chezvinhu zvakapihwa kuruboshwe rwehwindo rakavhurika ndeye "parameter".



3. Muwindo rakavhurika rewindows excel, enda ku "Wedzera-mu" Subsection (iyo pentalimate mune rondedzero kuruboshwe rwechidzitiro).



4. Mune ichi chiitiko, isu tichave tichifarira chikamu chepazasi chewindo. Kune "manejimendi" paramende. Kana mune yekudonha-pasi fomu ine chekuita nazvo, zvakakodzera kukosha kunze kweiyo "Excel Wedzera-Injini", saka iwe unofanirwa kuzvichinja kune yakatarwa. Kana chinhu ichi chakaiswa, ini ndinongo tinya pane "enda ..." bhatani kurudyi racho.



5. Hwindo diki reiyo iripo supersture inovhura. Pakati pavo, iwe unofanirwa kusarudza chinhu icho "package yekuongorora" uye isa tick nezvazvo. Mushure meizvozvo, tinya pane "OK" bhatani iri kumusoro kweiyo kurudyi kwehwindo.

Mushure mekuita izvi zviito, basa rakatsanangurwa richavigirwa, uye chishandiso charo chinowanikwa paEnteccel ribbon.

Kumhanya kuongorora kwedata kweboka

Iye zvino tinogona kumhanya chero ipi neipi yekuongorora data timu.

1. Enda ku "data" tab.



2. Mu tab iyo iyo ribhoni yakavhurwa pamucheto wokurudyi we tepi inowanikwa. Dzvanya pane "kuongororwa kwedata", iyo iri mazviri.



3. Mushure meizvozvo, hwindo rakatangwa nerondedzero yakakura yezvishandiso zvakasiyana-siyana zvinopa iyo data yekuongorora data. Pakati pavo unogona kuratidza zvinotevera zvinhu:
   • Correlation;
   • Bar girafu;
   • Kudzoreredza;
   • Muenzaniso;
   • Exponential smoothing;
   • Nhamba yenhengo jenareta;
   • Manhamba anotsanangudza;
   • Indier Ongororo;
   • Mhando dzakasiyana siyana dzekupararira kuongorora, nezvimwe.

   Sarudza iyo chimiro chatinoda kushandisa uye kudzvanya iyo "OK" bhatani.

Shanda mune yega yega basa ine yake algorithm. Iko kushandiswa kwezvimwe zviridzwa kweboka rekuongorora data rinotsanangurwa muzvidzidzo zvakasiyana.

Chidzidzo: Kuongorora kuongororwa muExcel

Chidzidzo: Kuongorora kuongorora muExcel

Chidzidzo: Maitiro ekuita Histogram muExcel

Sezvatinoona, kunyangwe "kuongorora kwe" Ongororo "chishandiso block haina kugadziriswa nekukanganisa, maitiro ekusanganisira kwayo iri nyore. Panguva imwecheteyo, pasina kuziva yakajeka algorithm yekuita, mushandisi haafanire kukurumidza kuendesa izvi zvinobatsira zvakanyanya basa.