Ib qho S (sigmoid) nkhaus yog qhov sawv cev pom ntawm cov ntaub ntawv dhau sijhawm. Thaum tsim S nkhaus, koj yuav ib txwm muaj ib kab lossis kab mob siab rau lub sijhawm, xws li lub hlis, ib hlis, lossis xyoo. Koj lwm cov ntaub ntawv (xws li cov nyiaj tau los, sijhawm, lossis siv nyiaj) yuav tso tawm raws li "nkhaus" nyob rau lub sijhawm ntawd, uas tuaj yeem pab koj txheeb xyuas cov kev hloov pauv thiab phiaj xwm tshiab. Qhov wikiHow qhia koj siv Microsoft Excel los tsim S nkhaus.
Cov kauj ruam
Kauj Ruam 1. Sau koj daim ntawv qhia
Txij li S txoj kab nkhaus qhia cov ntaub ntawv nyob rau lub sijhawm, nco ntsoov khaws tseg ib kab lossis kab ntawv txhawm rau qhia lub sijhawm. Piv txwv li, cia peb hais tias koj xav qhia S nkhaus ntawm cov nyiaj tshiab hauv kaum ob lub hlis. Nws yuav zoo ib yam li no:
| A | B | C | D | E | F | G | H | Kuv | J | K | L | M | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | TUAG | FEB | MAR | APR | YOG | LUAG | JUL | AUG | SEP | OCT | NOV | DEC | |
| 2 | Tshiab | 54 | 62 | 74 | 390 | 420 | 90 | 800 | 151 | 220 | 130 | 145 | 280 |
| 3 | Tag nrho | 54 | 116 | 190 | 580 | 1000 | 1090 | 1890 | 2041 | 2261 | 2391 | 2536 | 2816 |
Hauv qhov piv txwv no, cov qauv peb siv kom tau txais tus nqi C3 (Lub Ob Hlis Ntuj suav tag nrho ntawm 116) yog = B3+C2, uas ntxiv cov npe sau npe ib hlis txij li Lub Ob Hlis mus rau yav dhau los suav ntawm 54. Zoo sib xws, Lub Peb Hlis suav sau tag nrho yog xam siv = D2+C3
Kauj Ruam 2. Qhia cov ntaub ntawv
Nco ntsoov suav nrog kab thiab kab taub hau. Txhua cov ntaub ntawv xaiv yuav raug ntxiv rau daim duab.
Kauj Ruam 3. Nyem rau Insert tab
Nws nyob saum toj ntawm lub cuab yeej nyob rau sab saum toj ntawm Excel.
Kauj Ruam 4. Xaiv hom kab ntawv
Koj yuav pom ntau lub cim thiab cov ntawv qhia zaub mov hauv "Charts" vaj huam sib luag nyob rau sab saum toj ntawm Excel, thiab yuj koj tus cursor nas hla lawv yuav tso saib cov kab kos zoo li cas hauv. Koj tuaj yeem tsim S txoj kab nkhaus ntawm Kab lossis Kab Tsuag. Thaum koj xaiv kab ntawv, koj S nkhaus yuav tshwm, qhia txog kev loj hlob thiab poob rau lub sijhawm.
- Txhawm rau pom koj txoj kab raws li txoj kab nkhaus zoo, mus nrog daim phiaj Scatter. Txhawm rau ua qhov no, nyem lub cim nrog ntau qhov xim xiav thiab dub tawg nyob rau ntawm lub kaum sab xis, thiab tom qab ntawd xaiv lub Scatter nrog Kab Kab kev xaiv
- Txhawm rau ntxig daim kab ntawv ib txwm (nws yuav tsis du/nkhaus tab sis nws yuav qhia qhov tseeb cov ntaub ntawv ntawm kab), nyem lub cim nrog kab kab xiav thiab dub sib tshooj nrog cov cim ntawm txhua qhov chaw. Tom qab ntawd koj tuaj yeem xaiv ib qho ntawm kab kos hauv "2-D Line" lossis "3-D Line section."
Kauj Ruam 5. Kho koj daim duab
Tam sim no koj tus S nkhaus tshwm ntawm daim duab, koj tuaj yeem kho nws raws li koj pom zoo.
- Txhawm rau kho lub npe ntawm koj daim ntawv, ob-nias Daim Ntawv Teev Npe thiab ntaus lub npe tshiab.
- Nyem rau + ib sab ntawm koj daim duab los kho cov ntsiab lus. Qee qhov tseem ceeb tshwj xeeb uas koj tuaj yeem hloov kho yog Cov Ntaub Ntawv Cov Ntawv (los npaj cov txiaj ntsig ntawm txoj kab nkhaus), Cov Ntaub Ntawv (los qhia cov ntaub ntawv nyoos hauv qab), thiab Trendline (los qhia kev hloov pauv ntawm txhua qhov sib txawv).
- Nyem rau lub cim xim txhuam ib sab ntawm koj daim duab los xaiv cov qauv sib txawv thiab xim. Qee qhov sib txawv sib txawv muab cov ntaub ntawv muaj txiaj ntsig ntxiv rau kev txhais koj cov ntaub ntawv.
- Nyem rau kab cim icon nyob ib sab ntawm kab ntawv kom xaiv cov ntaub ntawv twg koj xav pom ntawm koj daim duab. Piv txwv li, yog tias koj tsuas xav pom S nkhaus rau cov ntaub ntawv sib sau ua ke, koj tuaj yeem tshem tus cim kos los ntawm cov ntawv nkag txhua hli.
Lub tswv yim
- Nyob ntawm hom kab ntawv uas koj xaiv, koj S txoj kab nkhaus yuav muaj ntau dua li nkhaus. Qhov no tsis txhais tau tias cov ntaub ntawv tsis raug.
- Yog tias koj tsis xav xaiv txhua cov ntaub ntawv rau kab ntawv, tuav cia Ctrl los yog Hais kom ua qhov tseem ceeb thaum koj nyem cov cell uas koj xav ntxiv hloov.
- Txheeb xyuas https://stats.areppim.com/calc/calc_scurve.php kom kawm paub yuav tsim S nkhaus li cas nrog lub tshuab hluav taws xob ntau dua li cov ntaub ntawv Excel.
