Cov txheej txheem:

Yuav ua li cas koj ua ib daim ntawv piav qhia txheeb cais hauv Excel?
Yuav ua li cas koj ua ib daim ntawv piav qhia txheeb cais hauv Excel?

Video: Yuav ua li cas koj ua ib daim ntawv piav qhia txheeb cais hauv Excel?

Video: Yuav ua li cas koj ua ib daim ntawv piav qhia txheeb cais hauv Excel?
Video: Tsis Muaj Peev Xwm Yuav Ua Li Cas 2024, Lub peb hlis ntuj
Anonim

Kauj ruam 1: Ntaus koj cov ntaub ntawv rau hauv Excel , nyob rau hauv ib kem. Piv txwv li, yog tias koj muaj kaum yam khoom hauv koj cov ntaub ntawv teev, ntaus lawv rau hauv hlwb A1 txog A10. Kauj ruam 2: Nyem qhov "Cov ntaub ntawv" tab thiab ces nias "Cov ntaub ntawv Kev tsom xam ”hauv Kev tsom xam pab pawg. Kauj ruam 3: Highlight " Kev piav qhia Statistics "nyob rau hauv cov ntaub ntawv pop-up Kev tsom xam qhov rai.

Yog li ntawd, ua li cas koj suav cov txheeb cais hauv Excel?

Txhawm rau suav cov txheeb cais piav qhia rau cov ntaub ntawv teev, ua raws cov kauj ruam no:

  1. Nyem rau ntawm cov ntaub ntawv tab cov ntaub ntawv Kev Ntsuam Xyuas cov lus txib kom qhia rau Excel tias koj xav suav cov txheeb cais piav qhia.
  2. Nyob rau hauv cov ntaub ntawv Analysis dialog box, taw qhia qhov piav qhia Statistics nkag rau hauv cov cuab yeej tshuaj ntsuam xyuas thiab ces nias OK.

Ib yam li ntawd, koj yuav piav qhia txog kev txheeb xyuas hauv Excel li cas? Nyem qhov File tab, nyem Options, thiab tom qab ntawd nyem rau Ntxiv -Ins qeb. Hauv Manage box, xaiv Excel Ntxiv -ins thiab ces nias mus. Hauv Ntxiv -Ins muaj lub thawv, xaiv lub Kev tsom xam ToolPak kos lub thawv, thiab tom qab ntawd nyem OK.

Tom qab ntawd, koj ua li cas piav qhia txheeb cais?

Kev piav qhia txheeb cais yog siv los piav qhia txog cov yam ntxwv ntawm cov ntaub ntawv hauv kev kawm.

Piv txwv li, koj tuaj yeem siv feem pua los piav txog cov:

  1. feem pua ntawm cov neeg hauv cov nyiaj tau los sib txawv.
  2. feem pua ntawm cov neeg nyob hauv ntau lub hnub nyoog sib txawv.
  3. feem pua ntawm cov neeg nyob hauv ntau qhov sib txawv ntawm cov qhab nia xeem.

Dab tsi yog qee qhov piv txwv ntawm kev piav qhia txheeb cais?

Muaj plaub hom kev piav qhia tseem ceeb:

  • Kev ntsuas zaus: * Suav, feem pua, zaus.
  • Kev ntsuas ntawm Central Tendency. * Qhov nruab nrab, nruab nrab, thiab hom.
  • Kev ntsuas ntawm Dispersion lossis Variation. * Ntau yam, Variance, Standard Deviation.
  • Kev ntsuas ntawm Txoj Haujlwm. * Qib Qib Qib, Qib Qib Quartile.

Pom zoo: