Maitiro Ekuvaka Trend Line mu Execel

Chimwe chezvinhu zvakakosha zve chero ongororo ndeyekuti sarudza maitiro makuru ezviitiko. Kuve neiyi data kunogona kuve kufanotaura kwekuwedzera kwekuwedzera kwemamiriro ezvinhu. Izvi zvinonyanya kuoneka zvakajeka pamuenzaniso wetsiva yemutsara pane hurongwa. Ngatitsvagei kuti muMicrosoft Excel chirongwa chaunogona kuvaka.

Trend Line mu Execel

Iyo Excel application inopa kugona kuvaka trend mutsara negirafu. Panguva imwecheteyo, iyo yekutanga data yekuumbwa kwayo inotorwa kubva patafura yekutanga.

Kuvaka Graphics

Kuti uvake chati, iwe unofanirwa kuve ne tafura yakagadzirirwa-yakagadzirirwa, pahwaro hwayo huchaumbwa. Semuenzaniso, isu tinotora data pakukosha kwedhora mune rubles kweimwe nguva yenguva.

1. Isu tinovakira tafura kuti mune imwe ikoramu ichave zvikamu zvenguva pfupi (mune yedu yemazuva), uye mune imwe - kukosha kweiyo icharatidzwa mugirafu.



2. Sarudza iyi tafura. Enda kune "Insert" tab. Ikoko pane tepi mu "Diagram" Tool block nekudzvanya pane "Chirongwa" bhatani. Kubva pane rondedzero inoratidzwa, sarudza iyo yekutanga sarudzo yekutanga.



3. Mushure meizvozvo, hurongwa huchavakwa, asi hunofanira kunatswa. Isu tinoita iyo musoro weiyo girafu. Nekuda kweizvi, tinya pazviri. Mu "basa rine machati" tabu inoonekwa, enda ku "Modyout" tab. IN it, tinya pane "Diagram Musoro" bhatani. Mune rondedzero iyo inovhura, sarudza chinhu "pamusoro pemutiwa".



4. Munda uyo akaoneka ari pamusoro pehurongwa, iwe unopinda muzita ratinofunga zvakakodzera.



5. Tobva taisaina axis. Muchidimbu chebhu "chimwe chete", tinya pane bhatani pane "Axis zita" tepi. Nguva nenguva enda kuburikidza nezvinhu "zita renzvimbo huru yakajeka axis" uye "zita pasi peAxis".



6. Mumunda unoonekwa, pinda zita renyaya yakatwasuka, maererano nemamiriro e data iri pairi.



7. Kuti tipe zita renzvimbo dzevatambi, isu zvakare tinoshandisa iyo "maumbirwo" tab. Dzvanya pane bhatani "Zita Axes". Isu tinogara tichifamba pazvinhu zvePop-Up menyu "zita reiyo huru vertical axis" uye "rakatenderedzwa zita". Iyi mhando yeaxis zita nzvimbo ichave yakanyanya kunaka kune yedu mhando yemijini.



8. Mune iyo yakaonekwa munda wezita reiyo dema axis pinda zita chairo.

Chidzidzo: Maitiro Ekuita Girafu muExcel

Kugadzira mutsara wetsiva

Iye zvino iwe unofanirwa kuwedzera zvakananga mutsara.

1. Kuve mune iyo tabu "marongero" nekudzvanya pa "Trend Line" bhatani, iro riri mu "kuongorora" Toolbar. Kubva pane yekutanga rondedzero, sarudza chinhu icho "chinowedzera approxation" kana "mutsara approxation".



2. Mushure meizvozvo, mutsetse wetsika unowedzerwa kune hurongwa. Nokusvibiswa, ine ruvara rwe nhema.

Kuisa Trend Line

Izvo zvinokwanisika kuenderera mberi kugadzirisa mutsara.

1. Nguva nenguva enda kune "maumbirwo" tab pane zvinhu zvemenyu "kuongororwa", "Trend Line" uye "imwe nzira yekuwedzera mutsara ...".



2. Iyo parameter hwindo rinovhura, unogona kuita dzakasiyana siyana marongero. Semuenzaniso, iwe unogona kuita shanduko mune rudzi rwekunyorova uye nekuwirirana nekusarudza chimwe chezvinhu zvitanhatu:
   • Polynomial;
   • Mutsara;
   • Simba;
   • Logarithmic;
   • Exponential;
   • Linear Filtration.

   Kuti tizive chokwadi chemuenzaniso wedu, isu takasimudza tick nezve chinhu "isa kukosha kwekukosha kwekukodzera kweshoko remuti mudhirowa." Kuti utarise mhedzisiro, tinya pane "padyo" bhatani.

   

   Kana ichi chiratidzo chiri 1, saka iyo modhi yakavimbika sezvinobvira. Chiyero chehure kubva pane chimwe, kushoma kuvimbika.

Kana iwe usingagutise iyo nhanho yekuvimbika, iwe unogona kudzokera zvakare kune paramita uye shandura mhando yekunyora uye yekufungidzira. Zvadaro, gadzira coefficient zvakare.

Kufanotaura

Basa guru reiyo trend mutsara ndiko kugona kuunganidza kufanotaura kwekuwedzera kukura kwezviitiko.

1. Zvekare, enda kumharadzidzo. Mu "fungidziro" marongero minda muminda yakakodzera, isu tinotaura kuti nguva yakareba sei kana kumashure inoda kuenderera mberi nekufanotaura. Dzvanya pane "padyo" bhatani.



2. Zvakare enda kuhurongwa. Zvinoratidza kuti mutsara wakareba. Iye zvino iwe unogona kuona kuti ndechipi chinongedzo chinongedzera kune imwe zuva rakati rara uchichengeta maitiro aripo.

Sezvauri kuona, Excel haina kuoma kuvaka trend line. Chirongwa ichi chinopa zvishandiso kuitira kuti zvinogona kugadziriswa kuti ugadziriswe kuti uwedzere kuratidzira zviratidzo. Zvichienderana negirafu, iwe unogona kuita kuti proong yenguva yakatarwa nguva.