Ib qho histogram yog kab lus uas qhia qhov zaus, lossis tus nqi ntawm qee yam uas tau tshwm sim nyob rau qee lub sijhawm. Histograms zoo ib yam li kab duab kab; txawm li cas los xij, thaj chaw uas sawv cev los ntawm histogram tau siv los teeb duab cov xwm txheej tshwm sim ntawm cov lej. Tej zaum koj yuav xav siv lub cim keeb kwm los qhia cov ntaub ntawv txuas ntxiv xws li lub sijhawm, ntsuas, thiab ntsuas kub. Txawm li cas los xij, qhov teeb meem nrog histograms yog qhov nyuaj rau sib piv ob daim ntawv teev npe thiab cov ntaub ntawv tseeb tsis tuaj yeem nyeem los ntawm kab ntawv. Paub txog kev kos duab histogram yuav pab tau rau cov tub ntxhais kawm ua piv txwv txog kev tshawb pom ntawm ib qhov haujlwm thiab rau cov kws tshaj lij kev lag luam.
Kauj ruam
Txoj Kev 1 ntawm 3: Kos Duab Los Ntawm Tes
Kauj Ruam 1. Siv tus pas ntsuas, kos lub hauv paus
Cov kab no yog kab ntsug thiab kab rov tav uas tsim lub hauv paus ntawm keeb kwm yav dhau los. Yog tias koj pom nws nyuaj los ua lub kaum sab xis uas ob txoj kab sib tshuam ua ke, tom qab ntawd siv qhov kev dag no: siv ntug ntawm ib daim ntawv!
Kauj Ruam 2. Ntsuas pab pawg
Hauv histogram, cov ntaub ntawv tau sawv cev hauv daim ntawv ntawm pawg. Cov pab pawg no tau faib sib npaug, yog li koj yuav tsum kos ib pawg cim kab raws koj li x-axis.
Piv txwv li: 0-4 txiv apples, 5-9 txiv apples, 10-14 txiv apples, thiab ntxiv rau ntawm 1, 2, thiab 3 raws txoj kab
Kauj Ruam 3. Ntsuas txoj kab ntsug
Cov kab ntsug hauv kab ntawv histogram ib txwm qhia qhov zaus. Kev ntsuas lub sijhawm xav tau, tab sis nws nyob ntawm qhov kev taw qhia ntawm koj cov ntaub ntawv (tab sis cov lej tseem xav tau kos tib qhov deb). Tsuas yog xyuas kom koj tso qee qhov chaw ntxiv rau saum kom ua rau koj daim ntawv nyeem tau yooj yim dua.
- Yog hais tias txoj kab sab saud ntawm koj li keeb kwm yav dhau yog 54, piv txwv li, koj yuav tsum teeb tus nqi siab tshaj plaws ntawm koj lub axis rau 60.
- Yog tias qhov zaus tsis pib mus rau tus lej txaus, koj tuaj yeem tso ntau tus lej hauv qab no. Piv txwv, yog thawj zaus yog 32, koj tuaj yeem pib teeb tsa los ntawm 25 lossis 30.
Kauj Ruam 4. Kos daim duab
Kos kab kab saum toj kawg nkaus kab rov tav rau txhua ntu lossis pab pawg nyias nyias, ntawm qhov siab ntawm cov ntaub ntawv ntsuas. Tom qab ntawd, kos kab ntawv nyob nruab nrab ntawm cov ntsiab lus cov ntsiab lus sawv cev. Nco ntsoov tias cov kab lus piav qhia yog qhov loj me thiab dav ib leeg. Feem ntau, cov kab ntawv histogram kov ib leeg, tab sis yog tias koj tsis muaj qhov tshwm sim rau ib pab pawg tshwj xeeb, tom qab ntawd tsis txhob xav txog nws.
Kauj Ruam 5. Ntxiv qee cov xim
Ntxiv cov xim sib txawv rau daim duab plaub fab histogram nrog cov xaum xim, cov cim, lossis cov xaum xim kom paub qhov txawv ib ntus los ntawm lwm qhov.
Txoj Kev 2 ntawm 3: Siv Excel
Kauj Ruam 1. Sau koj cov ntaub ntawv
Hauv daim ntawv Excel, sau kab thib ob nrog lub thoob, lossis pab pawg ntawm cov ntaub ntawv koj xav tau (20/30/40, 0/5/10/10/15, thiab lwm yam) nrog ib pab pawg hauv ib lub thawv. Sau rau hauv kab ntawv thawj nrog rau qhov ua tau zoo ntawm txhua pab pawg (uas yog hu ua qib), lossis qhov siab koj xav kom cov duab bar ntawm txhua pab pawg ua.
Kauj Ruam 2. Ua cov ntaub ntawv txheeb xyuas
Nyem Cov Cuab Yeej ysis Txheeb Xyuas Cov Ntaub Ntawv. Cov yam ntxwv no tsis yog ib txwm ua qauv zoo hauv Excel yog li koj yuav xav tau teeb tsa nws siv qhov Add-ins xaiv.
Kauj Ruam 3. Xaiv lub histogram
Xaiv qhov kev xaiv histogram hauv cov ntawv txheeb xyuas cov ntaub ntawv thiab tom qab ntawd nyem OK.
Kauj Ruam 4. Kho cov ntaub ntawv tawm tswv yim thiab nws qhov ntau
Koj yuav tsum tau siv cov ntawv qhia zaub mov los xaiv cov kem twg yog ntu twg.
Kauj Ruam 5. Xaiv cov duab tso tawm
Xaiv lub pob nyem tawm thiab tom qab ntawv nyem OK.
Kauj Ruam 6. Ua tiav
Txaus siab rau koj cov duab. Tsis txhob hnov qab txuag nws.
Txoj Kev 3 ntawm 3: Siv Cov Kev Kawm Online
Kauj Ruam 1. Mus rau lub vev xaib uas tuaj yeem tsim cov cim keeb kwm
Peb pom zoo siv qhov no.
Kauj Ruam 2. Xaiv hom ntawv ua ntej
Muaj cov ntawv qhia zaub mov nco nyob saum toj ntawm kab ntawv uas yuav muab rau koj qee cov qauv kab kos uas koj tuaj yeem sau nrog koj tus kheej cov ntaub ntawv. Lwm txoj hauv kev yog tias koj tuaj yeem tsim daim ntawv qhia tag nrho los ntawm kos.
Kauj Ruam 3. Sau lub npe kab ntawv
Koj yuav pom lub npov uas hais tias Title nyob nruab nrab ntawm nplooj ntawv. Koj yuav tsum sau koj daim ntawv qhia hauv lub thawv ntawd.
Kauj Ruam 4. Sau koj cov ntaub ntawv rau hauv lub npov hauv qab
Koj yuav pom lub thawv loj hauv qab kab ntawv npe, hauv qab ntawm nplooj ntawv. Nkag mus rau txhua cov ntaub ntawv taw tes koj muaj, nrog ib cov ntaub ntawv taw tes rau ib kab (yog li … 5, 5, 5, 10, 10, 15, 15, 20, 20, 25, thiab lwm yam).
Kauj Ruam 5. Nyem Hloov Cov Ntaub Ntawv
Nyem rau khawm Updata Cov ntaub ntawv saum toj no lub thawv ntawv.
Kauj Ruam 6. Teev zaus
Cov kab yuav tsum tau hloov kho nws cov zaus rau koj cov ntaub ntawv, tab sis koj tuaj yeem tseem tuaj yeem teeb tsa lub sijhawm sib nrug thiab qhov siab tshaj plaws thiab qhov tsawg kawg nkaus rau cov kab ke.
Kauj Ruam 7. Luam tawm lossis khaws koj cov duab
Siv lub tshuab luam ntawv ua haujlwm ntawm cov keyboard kom thaij duab tag nrho cov duab. Muab tshuaj txhuam thiab qoob loo cov duab hauv MS Xim lossis ib qho duab kos duab yooj yim uas koj muaj hauv koj lub computer. Txuag daim duab no thiab luam tawm yog tias koj xav tau.
Lub tswv yim
- Tsis txhob hnov qab sau lub y thiab x axis kom ntseeg tau tias cov ntaub ntawv raug.
- Thaum suav qhov sib npaug ntawm txhua pawg ua ntu, nws pab yog tias koj hla tus lej hauv cov ntaub ntawv yog li koj tsis suav lawv ob zaug.
- Thaum kos daim duab keeb kwm yav dhau, nco ntsoov siv tus pas ntsuas los kos kab kom txhua kab yog ncaj thiab zoo.
