Maitiro ekugadzira histogram muExcel

Iyo histogram chishandiso chakakosha mukuongorora data. Inokubvumira kuti uone kugoverwa kwehuwandu hweseti ye data uye kunzwisisa maitiro ayo. Muchinyorwa chino, tichaongorora maitiro ekugadzira histogram muExcel, imwe yeanonyanya kushandiswa maapplication mumunda wehunyanzvi. With nhanho nhanho rakadzama uye rinoshanda zano, iwe uchadzidza mashandisiro ezvimiro zveExcel kugadzira histograms yakarurama uye inoshanda. Ziva maitiro ekuwana zvakanyanya kubva muchishandiso chine simba ichi uye vandudza hunyanzvi hwako hwekuongorora data. Ngatitangei!

1. Nhanganyaya yekugadzira histograms muExcel

Iyo histogram chishandiso chegraphical chinoshandiswa zvakanyanya mukuongorora data. Inonyanya kukosha kumiririra kugoverwa kwefrequency ye data set. MuExcel, zvinokwanisika kugadzira histograms zviri nyore uye nekukurumidza uchishandisa zvinoshanda zvakavakwa muchirongwa. Muchikamu chino, tichaongorora matanho ekugadzira histograms muExcel uye tidzidze kududzira zvawanikwa.

Usati watanga kugadzira histogram muExcel, zvakakosha kuve nechokwadi kuti une data rakarongeka muspredishiti. Iyo data inofanirwa kunge iri mumakoramu uye kuve manhamba. Kana tave nedata ragadzirira, tinogona kuenderera mberi nekugadzira histogram.

Kugadzira histogram muExcel, tinongotevera matanho anotevera: kutanga, tinosarudza data yatinoda kuisa muhistogram. Zvadaro, tinosarudza "Insert" tab mukati toolbar yeExcel uye tinya pa "Histogram" muboka re "Graphics". Tevere, tinosarudza mhando yehistogram yatinoda kugadzira, senge column histogram kana mutsara histogram. Pakupedzisira, tinodzvanya "OK" uye Excel inozogadzira iyo histogram zvichienderana nedata rakasarudzwa.

Izvo zvakakosha kuti uyeuke kuti histogram chiratidzo chekuratidzwa kweiyo frequency kugoverwa kwe data set. Bhari yega yega muhistogram inomiririra huwandu hwehuwandu, uye kureba kwebhari kunoratidza kuwanda kwekuitika kweiyo tsika mu data set. Pakududzira histogram, zvakakosha kutarisisa kune chimiro chekugovera, iyo yepakati maitiro, uye kunze. Excel inopa mamwe maturusi ekugadzirisa iyo histogram uye kuwedzera rumwe ruzivo, senge axis mavara uye mazita.

2. Kugadzirira kwedheta kuvaka histogram muExcel

Usati wagadzira histogram muExcel, zvinodikanwa kugadzirira iyo data nemazvo. Heano mamwe matanho aunofanira kutevera:

1. Ronga data rako: Ita shuwa kuti une data rako muExcel column. Kana iwe wakaunganidza data, pwanya ruzivo uye uise mumaseru akasiyana. Ramba uchifunga kuti iyo data inofanirwa kuve nhamba uye yakarongedzerwa kubva padiki kusvika pakukura.

2. Sarudza nhamba yezvikamu: Nhamba yezvikamu mu histogram zvinoenderana nehukuru hwe data yako uye huwandu hwemashoko aunoda kuratidza. Mutemo mukuru wegunwe ndeyekushandisa pakati pe5 ne20 intervals. Kuti uone nhamba yakakodzera, unogona kushandisa Sturge's formula, inova nhamba yezvikamu = 1 + log₂(s), kupi n ndiyo nhamba yedata.

3. Kusarudza nguva dzakakodzera dzehistogram

Kuti usarudze nhanho dzakakodzera dzehistogram yako, zvakakosha kuti utarise mashoma akakosha zvinhu. Chekutanga pane zvese, isu tinofanirwa kutsanangura huwandu hwe data yatichashandisa. Izvi zvinogona kuitwa nekuverenga hushoma uye huwandu hwehuwandu hwe data data. Semuenzaniso, kana tiri kushanda nedata inomiririra kureba kwevanhu, tinogona kuona huwandu hwehurefu kubva pa150 cm kusvika 200 cm.

Kana tave nemhando yedata, isu tinofanirwa kusarudza huwandu hwenguva dzatinoda kushandisa muhistogram yedu. Mutemo mukuru wegunwe ndeyekushandisa pakati pe5 ne20 intervals, zvichienderana nehukuru hwemuenzaniso uye kugoverwa kwedata. Kana tiine sampuli diki, zvinokurudzirwa kushandisa nguva shoma kudzivirira ruzivo rwakawanda.

Imwe nzira yakajairika ndeye kushandisa slide mutemo wekuona hupamhi hwepakati. Mutemo unozivikanwa ndeyeSturges formula, iyo inoratidza kuverenga nhamba yezvipindiro uchishandisa inotevera fomula: Nhamba yezvikamu = 1 + log₂N, apo N ndiyo saizi yemuenzaniso. Iyi fomula inobatsira kumisikidza yakaenzana uye yakakodzera nguva yekugovera data.

4. Kugadzira tafura yefrequency muExcel

Tafura yefrequency muExcel chishandiso chinobatsira kuronga uye ongorora data. Kuburikidza netafura iyi, tinogona kuona kugoverwa kwe data uye kuwana ruzivo rwakakosha pamusoro pehuwandu hwehuwandu hwehuwandu. Tevere, tinokuratidza maitiro ekugadzira tafura yefrequency muExcel mumatanho mashoma.

1. Vhura Excel uye iva nechokwadi chokuti une data yaunoda kuongorora mumutsara. Iwe unogona kuva nemakoramu akawanda sezvaunoda, asi nokuda kwemuenzaniso uyu, tichatarisa pane imwe chete.

2. Sarudza iyo yose data column. Unogona kuita izvi nekudzvanya tsamba yekoramu inotungamirwa nekoramu kana kungosarudza sero mukoramu nekudzvanya Ctrl + Shift + Down Arrow kusarudza otomatiki kusvika kumagumo kwekoramu.

5. Kushandisa basa rekuverenga kuti uwane mafrequency muExcel

Kuti tiwane mafrequency muExcel, tinogona kushandisa basa rekuverenga, chishandiso chinobatsira kuverenga nhamba yenguva iyo imwe kukosha inowanikwa mu sero renji. Matanho ekutevera kushandisa basa iri achatsanangurwa pazasi. zvinobudirira.

1. Sarudza huwandu hwemasero atinoda kuverenga mafrequency. Ita shuwa kuti renji rinovhara maseru ese ane ma values ​​anofanirwa kuverengerwa.

• Danho rinokurudzirwa: Kana data yekuverenga iri mukoramu, unogona kusarudza koramu yese nekudzvanya mavara ari pamusoro pespredishiti.

2. Mubhari yefomula, nyora basa rekuverenga, rine chirevo chinotevera: =COUNT(renji). "Range" ndiwo huwandu hwemasero akasarudzwa munhanho yapfuura.

3. Dzvanya kiyi ye "Enter" kuti uwane mhedzisiro yebasa rekuverenga. Nhamba yakadzoswa ndeye frequency yemutengo wakasarudzwa muchikamu chakatarwa chemasero.

• Zano: Kana iwe uchida kuverenga kuwanda kwemaitiro akati wandei akasiyana, unogona kudzokorora nhanho 2 kune yega yega kukosha kana kushandisa kuverenga basa necomma-yakapatsanurwa runyorwa rwezvikoshero.

Kushandisa kuverenga basa muExcel inzira iri nyore uye inoshanda yekuwana mafambiro ezvikoshi mumutsara wemaseru. Nematanho aya, iwe uchakwanisa kuverenga nemazvo kuwanda kwechero kukosha muspredishiti yako, zvichikubvumidza kuti uite ongororo yenhamba uye kubvisa ruzivo rwakakosha kubva yako data.

6. Kuvakwa kweHistogram Chati muExcel

Kuvaka histogram chati muExcel, tevera matanho aya:

1. Vhura bhuku rebasa reExcel uye gadzira koramu ine data raunoda kumiririra muhistogram.
2. Sarudza data uye tinya "Isa" tebhu paribhoni.
3. Muboka re "Machati", tinya bhatani re "Column" uye sarudza rudzi rwekoramu ye "Histogram" kubva pane yekudonha-pasi menyu.
4. Ikozvino, Excel inongogadzira iyo yakakosha histogram chati uchishandisa iyo yakasarudzwa data.
5. Kuti ugadzirise kutaridzika kwehistogram, tinya-kurudyi pane chati uye sarudza "Chati Sarudzo."
6. Mune inodonhedza-pasi menyu, unogona kugadzirisa axis mavara, chati mafomati, uye dzimwe sarudzo.
7. Iwe unogona zvakare kuwedzera mazita kune chati uye kushandura mavara kuti aratidze zvikamu zvakasiyana zve data.

Iyo histogram girafu chishandiso chikuru chekuona kugoverwa kwedata. Nekutevera nhanho idzi, iwe unozogona kugadzira yakasarudzika histogram chati muExcel inoenderana nezvako chaizvo zvaunoda.

Rangarira kuti kurongeka kwehistogram yako kuchaenderana nemhando uye huwandu hwe data rakapihwa. Kana iwe uchida kudzidza zvakawanda nezve nzira yekuvandudza yako histogram machati muExcel, kune akawanda tutorials aripo online anogona kukupa iwe mamwe matipi uye epamberi matipi.

7. Kugadzirisa Histogram muExcel: Kugadzirisa Matemo uye Mazita

MuExcel, zvinogoneka kugadzirisa histogram nekugadzirisa mbezo uye mavara kuti uvandudze kujeka uye kuratidzwa kwedata. Iyi ficha inonyanya kubatsira kana uchishanda nehombe kana yakaoma data seti. Pazasi pane matanho ekugadzirisa iyo histogram muExcel:

1. Iva nechokwadi chokuti une histogram data yako yakanyatsorongeka kuva makoramu kana mitsetse muExcel spreadsheet.
2. Sarudza data yehistogram uye baya "Insert" tab pane Excel toolbar.
3. Muboka re "Chati", tinya bhatani re "Histogram" uye sarudza rudzi rwehistogram yaunoda kugadzira.
4. Mushure mekugadzira histogram, tinya-kurudyi chero kupi pane chati uye sarudza "Axis Options" kubva pane yekudonha-pasi menyu. Izvi zvinovhura hwindo rine akati wandei maitiro ekugadzirisa.
5. Mu "Axes" tab, unogona kugadzirisa nguva yeaxes uye kuchinja zvikamu zvekuyera. Iwe unogona zvakare kutsanangura kana iwe uchida kuti demo rive mutsara kana logarithmic chiyero.
6. Mu "Labels" tab, unogona kuchinja maitiro ezvinyorwa zve X-axis uye Y-axis, pamwe nekuwedzera kana kubvisa zvinyorwa zvechipiri.
7. Edza nemaitiro akasiyana-siyana kusvikira wafara nechitarisiko uye kuverenga kwehistogram.

Nematanho akareruka aya, unogona kugadzirisa zviri nyore histogram muExcel nekugadzirisa mbezo uye mavara zvinoenderana nezvaunoda. Rangarira kuti kuratidzwa kwakajeka kwedata kwakakosha kuti ukwanise kududzira nemazvo, saka zvakakosha kushandisa nguva uchigadzirisa histogram. Pamusoro pezvo, iwe unogona kuongorora dzimwe sarudzo dzekugadzirisa dziripo muExcel kune mamwe anoyevedza uye ehunyanzvi machati.

8. Kuwedzera mazita uye ngano kune histogram muExcel

Kuti uwedzere mazita uye ngano kuhistogram yako muExcel, unofanira kutanga waona kuti une data rakakodzera uye histogram yakatogadzirwa muspredishiti rako. Zvadaro, tevera matanho aya:

1. Dzvanya pane histogram kuti usarudze. Iyo "Chati Zvishandiso" tebhu ichaonekwa paExcel ribhoni.

2. PaDesign tab, muboka reMazita, baya Wedzera Chati Element uye sarudza Chinyorwa Cheti. Bhokisi remavara richaonekwa pane histogram.

3. Mubhokisi remashoko, nyora zita raunoda rehistogram yako uye shandisa "Enter." Musoro uchawedzerwa pamusoro pehistogram.

Kana iwewo uchida kuwedzera ngano kune yako histogram, tevera aya ekuwedzera matanho:

1. Kurudyi tinya pane histogram uye sarudza "Sarudza Dhata" kubva pane zviri mukati menyu.

2. Muwindo re "Sarudza Data Source" rinoonekwa, chengetedza "Wedzera" bhatani muchikamu che "Chart Series".

3. Mubhokisi rebhokisi re "Edit Data Series", unogona kuisa zita renheyo munharaunda ye "Series Name" uye sarudza ruzivo rwemashoko ezvinyorwa mundima ye "Series Values". Dzvanya "OK" kana wapedza.

Ready! Ikozvino histogram yako muExcel ichave neyakajairwa zita uye ngano zvinokubatsira iwe kuona zvirinani uye kunzwisisa data rako. Rangarira kuti iwe unogona kuyedza neakasiyana sarudzo uye marongero zvinhu kuti uwedzere kugadzirisa yako histogram kune zvaunoda.

9. Kushandiswa kwemaitiro ekuona uye masitayera kune histogram muExcel

Iyo imwe nzira inoshanda kuvandudza kuratidzwa uye kududzira data. Kuburikidza neakasiyana mafomati sarudzo, zvinokwanisika kuratidza akakosha mapoinzi uye kufambisa kunzwisisa kweiyo graphical ruzivo. Muchikamu chino, tichaongorora dzimwe nzira dzekushandisa mafomati ekuona uye masitaera kune histogram muExcel.

Kutanga kugadzirisa histogram, zvinogona kuitwa Tinya-kurudyi pane chati uye sarudza "Chati Data Format" kubva pane yekudonha-pasi menyu. Kubva pane iyi sarudzo, pani inovhura nematabu akasiyana anotendera iwe kugadzirisa mavara, mafonti, mitsetse uye zvimwe zvinhu zvechati. Zvakakosha kuyeuka kuti shanduko dzinoshanda munguva chaiyo, zvichiita kuti zvive nyore kuona kuchinja.

Pakati peanonyanya kubatsira mafomati sarudzo kusarudza tsika mavara emabhawa ehistogram, kushandura font rudzi uye saizi yemazita nemazita, uye kuwedzera mumvuri kana embossing mhedzisiro kuratidza chaiwo zvinhu. Pamusoro pezvo, Excel inopa akasiyana-siyana akafanotsanangurwa matemplate uye masitayipi anogona kufambisa maitiro ekugadzirisa uye kuve nechokwadi chehunyanzvi uye chinonakidza dhizaini.

10. Ongororo uye dudziro yehistogram inobuda muExcel

Kana tangoita histogram muExcel, zvakakosha kuongorora nekududzira zvawanikwa. Izvi zvinotibvumira kuti tinzwisise zviri nani kugoverwa kwe data uye kutora mhedziso dzakakodzera pakuongorora kwedu. Pazasi, tinokupa mamwe nhungamiro yekuita basa iri nemazvo.

Kutanga, tinofanira kuongorora chimiro chekugoverwa kunomiririrwa muhistogram. Yakaenzana here, yakatsveyamiswa kurudyi kana kuruboshwe? Ongororo iyi inogona kutiudza kana iyo data ichipa kusungirirwa mune yakatarwa siyana kana, pane zvinopesana, ivo vakapararira. Pamusoro pezvo, zvakakosha kutarisisa kune zvinogoneka kunze kana zvinokanganisa zvinogona kukanganisa kududzirwa kwemhedzisiro.

Chimwe chinhu chakakosha kuongororwa kwehurefu hwemabhawa histogram. Izvi zvinomiririra kuwanda kana kuti muzana yekuitika kweimwe kirasi kana nguva. Unogona kushandisa maturusi eExcel kuwana manhamba anotsanangura akadai seanoreva, epakati, uye modhi, izvo zvichakubatsira iwe kunzwisisa zviri nani kugovera uye yepakati tsika yedata rako. Yeuka kuti, zvichienderana nemamiriro ezvinhu uye zvinangwa zvekuongorora kwako, iwe uchakwanisa kuita sarudzo zvichienderana nemigumisiro iyi.

11. Kushandisa maturusi ekuongorora anopindirana ehistogram muExcel

Kuzadzisa histogram chimiro muExcel, kune mamwe maturusi ekuongorora anogona kupa hudzamu hukuru mukududzirwa kwedata. Chimwe chezvishandiso izvi ndechekuongorora maitiro, izvo zvinokutendera kuti uone mapatani uye shanduko yedata nekufamba kwenguva. Iri basa rinonyanya kubatsira pakuziva mamiriro enguva nemwaka, zvichibatsira kuita sarudzo dzine ruzivo.

Chimwe chishandiso chinobatsira kuzadzisa histogram ndeye regression analysis. Iyi tekinoroji inotibvumira kuona hukama pakati pemhando mbiri uye kufanotaura hunhu hwemangwana zvichibva pahukama ihwohwo. Nekushandisa regression ongororo kune histogram data, zvinokwanisika kuwana fungidziro yehunhu hunogona kuitika mune ramangwana, iyo inobatsira mukuronga mamiriro uye kufanotaura.

Pamusoro pezvo, ongororo yekubatanidza ndechimwe chishandiso chinopindirana chinogona kushandiswa pamwe chete nehistogram muExcel. Kuwirirana kunotibvumira kuona kana paine hukama pakati pezviviri zviviri uye kuti hukama uhu hwakasimba zvakadii. Nekushandisa chishandiso ichi pamwe chete nehistogram, zvinokwanisika kuwana mapatani akavanzika mu data uye kunzwisisa zviri nani hukama pakati pezvakasiyana zvakaongororwa.

12. Govera uye kutumira histogram muExcel

Nokuda kwe, tevera matanho ari pasi apa:

1. Vhura faira reExcel rine histogram yaunoda kugovera uye kutumira kunze.

2. Sarudza huwandu hwemasero ane histogram.

3. Dzvanya-kurudyi mutsara wakasarudzwa uye sarudza "Copy" kubva pane inodonha-pasi menyu.

4. Vhura bepa idzva reExcel kana faira idzva reExcel.

5. Tinya-kurudyi sero isina chinhu uye sarudza "Namira" kubva pakudonha-pasi menyu. Iyo histogram ichanamirwa muExcel sheet.

6. Unogona kuita zvimwe zvigadziriso uye kugadzirisa kune histogram muExcel, sekuchinja mavara, axis labels, kana font size. Izvi zvinokutendera kuti ugadzirise iyo histogram kune zvaunoda chaizvo.

7. Kana uchinge waita zvese zvinodiwa kugadzirisa, unogona kuchengetedza iyo Excel faira uye kuigovana nevamwe. Iwe unogona zvakare kutumira iyo faira kune mafomu akasiyana, senge PDF kana chimiro chemufananidzo, kuti uone nyore uye ushandise mukati zvimwe zvirongwa.

Nekutevera nhanho idzi, iwe unozogona kugovera zviri nyore uye kutumira histogram muExcel, ichikubvumidza iwe kuunza uye kuongorora iyo data nenzira inoshanda uye inoyevedza. Usakanganwa kuchengetedza basa rako uye ramba wakatarira kune zvigadziriso uye zvigadziriso zvinopihwa neExcel kuti uvandudze kuratidzwa kwehistograms yako!

13. Kugadzirisa matambudziko akajairika paunenge uchigadzira histogram muExcel

Kana uri kusangana nematambudziko ekugadzira histogram muExcel, usazvinetse, heano mamwe akajairika mhinduro kugadzirisa matambudziko aya:

1. Tarisa data: Ita shuwa kuti data rauchazoshandisa kugadzira histogram yakarongeka nemakoramu kana mitsara. Izvo zvakakoshawo kuve nechokwadi chekuti hapana maseru asina chinhu kana data risiri iro rinogona kukanganisa kusikwa kwehistogram.

2. Shandisa iyo Data Analysis tool: Kana iwe usingakwanise kuwana sarudzo yekugadzira histogram muExcel, ungangoda kugonesa iyo Data Analysis chishandiso. Kuti uite izvi, enda kune "Faira" tab, sarudza "Sarudzo" uyezve "Wedzero." Ita shuwa kuti Data Analysis checkbox yatariswa uye tinya "OK." Zvino, iwe unofanirwa kukwanisa kuwana iyo Data Analysis chishandiso uye kuishandisa kugadzira yako histogram.

3. Tevera nhanho nhanho tutori: Kana iwe uchiri kunetseka, unogona kutsvaga online tutorials inokutungamira iwe kuburikidza nemaitiro ekugadzira histogram muExcel. Aya matutorials anowanzo kupa yakadzama mirairo uye skrini kuti ikubatsire iwe kunzwisisa zvirinani nhanho yega yega maitiro. Mukuwedzera, iwe unogona zvakare kuwana mienzaniso uye ma templates ayo achakubvumidza iwe kuchengetedza nguva uye kushanda nesimba paunenge uchigadzira yako histogram.

14. Mazano uye maitiro akanaka ekugadzira histogram muExcel

Kugadzira histogram muExcel kunogona kuve basa riri nyore kana iwe ukatevera mamwe matipi uye maitiro akanaka. Tevere, tinokuratidza matanho anodiwa kuti uzviite zvakanaka:

1. Ronga data rako

Usati watanga kugadzira histogram muExcel, zvakakosha kuronga data rako nemazvo. Ita shuwa kuti une koramu ine makoshero aunoda kumiririra pane yakachinjika axis yehistogram, uye imwe ine frequency kana kuverenga kwehukoshi hwega hwega. Rangarira kuti data racho rinofanirwa kurongwa mukukwira kana kudzika kuti uwane histogram chaiyo.

2. Shandisa histogram basa

Excel ine basa chairo kugadzira histograms nekukurumidza uye nemazvo. Kuti ushandise chimiro ichi, enda kune "Data" tab uye sarudza "Data Analysis" muboka rekuongorora maturusi. Tevere, sarudza iyo "Histogram" sarudzo uye tinya "Zvakanaka." Mufafitera rinozovhurika, sarudza iyo data renji uye histogram inobuda renji. Excel inozogadzira iyo histogram mune nyowani spreadsheet.

3. Gadzirisa histogram yako

Paunenge uine histogram yakagadzirwa muExcel, unogona kuigadzirisa zvinoenderana nezvaunoda. Iwe unogona kushandura zita rehistogram, wedzera mavara kumatemo, shandura nguva dzekirasi, uye gadzirisa hushoma uye huwandu hunokosha. Kuti uite izvi, sarudza histogram uye enda kune "Chati Zvishandiso" tab. Shandisa sarudzo dziripo mu "Design" uye "Format" boka kuti ugadzirise zvaunoda. Uyewo yeuka kushandisa mavara akakodzera uye zvitayera kuratidza ruzivo zvakajeka uye zvinobudirira.

Mukupedzisa, zviri pachena kuti Excel inopa chishandiso chiri nyore uye chinoshanda chekugadzira histograms. Nekutevera matanho akatsanangurwa muchinyorwa chino, chero mushandisi anogona kugadzira histogram muExcel uye kutora mukana weiyi graphic inomiririra kuongorora uye kuona data nenzira pfupi.

Nekushandisa Excel-chaiyo mashandiro uye maficha, senge CountIf basa, iyo Data Analysis chishandiso, uye kugona kugadzirisa nhoroondo yehistogram, unogona kuwana chaiyo uye yakasarudzika mhedzisiro.

Pamusoro pezvo, kukosha kwekusarudza nemazvo huwandu hwe data uye huwandu hwenguva dzakasimbiswa, sezvo dzichipesvedzera kududzirwa kwemhedzisiro uye kufambisa kunzwisisa kwekugovera data.

Muchidimbu, kugadzira histogram muExcel inzira iri nyore, asi inobatsira zvakanyanya pakuongorora data. Nekuita kushoma uye kugona kweakakosha Excel mabasa, chero mushandisi anogona kushandisa chishandiso ichi kuratidza data nenzira inoyevedza uye nekunzwisisa zvirinani mafambiro uye mapatani kuseri kwenhamba.