OpenOffice Calc's built-in AVERAGE muaj nuj nqi ua rau xam qhov nruab nrab ntawm ib kem yooj yim.
Calc yog daim ntawv nthuav qhia ntawm Apache's dawb Open Office suite ntawm cov kev pab cuam.
Yuav xam qhov nruab nrab li cas
Ib qho nruab nrab yog xam los ntawm kev ntxiv ib pawg ntawm cov lej thiab faib tag nrho los ntawm kev suav cov lej.
Qhov piv txwv ntawm no suav qhov nruab nrab rau qhov tseem ceeb hauv kab C, uas tawm mus rau 13.5. Yog tias koj suav qhov no manually, koj yuav ntxiv tag nrho cov lej, thiab faib cov lej los ntawm 6 (11 + 12 + 13 + 14 + 15 + 16=81; 81 ÷ 6=13.5). Es tsis txhob nrhiav qhov nruab nrab no manually, txawm li cas los xij, koj tuaj yeem qhia OpenOffice Calc ua rau koj siv qhov kev ua haujlwm AVERAGE:
=AVERAGE(C1:C6)
Yuav tsum muaj ib qho ntawm qhov tseem ceeb hauv kab hloov pauv, qhov hloov tshiab nruab nrab tsim nyog.
Qhov Nruab Nrab Muaj nuj nqi's Syntax thiab Arguments
Nyob hauv OpenOffice thiab lwm yam kev pab cuam xws li Excel thiab Google Sheets, lub luag haujlwm lub ntsiab lus hais txog kev teeb tsa ntawm lub luag haujlwm thiab suav nrog lub luag haujlwm lub npe, kab cim, thiab kev sib cav. Cov syntax rau AVERAGE muaj nuj nqi yog:
=AVERAGE (tus naj npawb 1; tus lej 2; …number30)
Txog 30 tus lej tuaj yeem nruab nrab los ntawm kev ua haujlwm.
Ib qho kev sib cav yog cov lej cuam tshuam los ntawm kev ua haujlwm:
- Cov lus sib cav 1 (yuav tsum tau)-cov ntaub ntawv yuav tsum tau nruab nrab los ntawm kev ua haujlwm
- Nqe lus 2; … number30 (yeem)-cov ntaub ntawv ntxiv uas tuaj yeem muab ntxiv rau qhov nruab nrab suav.
Cov lus sib cav tuaj yeem muaj:
- ib daim ntawv teev cov lej yuav tsum tau nruab nrab
- xovtooj xa mus rau qhov chaw ntawm cov ntaub ntawv hauv daim ntawv ua haujlwm
- ntau yam ntawm cov ntaub ntawv xovtooj
Yog tias cov ntaub ntawv koj xav kom nruab nrab yog nthuav tawm hauv ib lub hlwb hauv daim ntawv ua haujlwm es tsis yog hauv ib kab lossis kab, nkag mus rau txhua tus xovtooj siv rau hauv lub thawv sib tham ntawm kab lus sib txawv (piv txwv li, C5, E4, G2).
Piv txwv: Nrhiav Tus Nqi Nruab Nrab ntawm ib kab ntawm tus lej
-
Tau cov ntaub ntawv hauv qab no rau hauv hlwb C1 rau C6: 11, 12, 13, 14, 15, 16.
Image - Xaiv Cell C7, qhov twg cov txiaj ntsig yuav tshwm sim.
-
Xaiv Insert > Function los ntawm cov ntawv qhia zaub mov raws sab saum toj ntawm lub vijtsam.
Image -
Xaiv Statistical los ntawm Qeb npe.
Image -
Xaiv Average, thiab nias los yog coj mus rhaub Next.
Image -
Highlight cells C1 txog C6 hauv daim ntawv nthuav qhia kom nkag mus rau qhov ntau yam no rau hauv lub thawv sib tham hauv number 1 kab lus sib cav; Nyem OK kom ua tiav txoj haujlwm thiab kaw lub thawv sib tham.
Yog koj tsis pom cov hlwb koj xav tau nyem, rub lub dialog box tawm ntawm txoj kev.
Image - Tus lej 13.5 yuav tsum tshwm sim hauv cell C7, uas yog qhov nruab nrab rau cov lej koj tau nkag rau hauv hlwb C1 txog C6. Thaum koj xaiv cell C7, qhov ua tiav=AVERAGE (C1: C6) tshwm nyob rau hauv kab ntawv sau saum toj no daim ntawv ua haujlwm
