Excel yapangitsa kuwerengera pafupifupi maselo angapo kukhala ntchito yosavuta - ingogwiritsani ntchito MALANGIZO (AVERAGE). Koma bwanji ngati mfundo zina zimalemera kwambiri kuposa zina? Mwachitsanzo, m'maphunziro ambiri, mayeso amalemera kwambiri kuposa ntchito. Zikatero, m'pofunika kuwerengera kulemera kwapakati.
Excel ilibe ntchito yowerengera kulemera kwake, koma pali ntchito yomwe ingakuchitireni zambiri: SUMPRODUCT (SUM PRODUCT). Ndipo ngakhale simunagwiritsepo ntchito izi, kumapeto kwa nkhaniyi mudzakhala mukuigwiritsa ntchito ngati pro. Njira yomwe timagwiritsa ntchito imagwira ntchito mumtundu uliwonse wa Excel komanso masamba ena monga Google Sheets.
Timakonza tebulo
Ngati muwerengera zolemetsa, mufunika mizati iwiri. Gawo loyamba (gawo B mu chitsanzo chathu) lili ndi zigoli za ntchito iliyonse kapena mayeso. Mzere wachiwiri (gawo C) uli ndi zolemera. Kulemera kochulukirapo kumatanthauza kukhudzidwa kwambiri kwa ntchitoyo kapena mayeso pagiredi yomaliza.
Kuti mumvetse kulemera kwake, mungaganizire ngati peresenti ya kalasi yanu yomaliza. M'malo mwake, izi sizili choncho, chifukwa pamenepa zolemera ziyenera kuwonjezera mpaka 100%. Njira yomwe tikambirane m'phunziroli iwerengera zonse molondola ndipo sizitengera kuchuluka kwa masikelo.
Timalowetsa fomula
Tsopano kuti tebulo lathu lakonzeka, timawonjezera ndondomeko ku selo B10 (selo iliyonse yopanda kanthu idzachita). Monga njira ina iliyonse mu Excel, timayamba ndi chizindikiro chofanana (=).
Gawo loyamba la formula yathu ndi ntchito SUMPRODUCT (SUM PRODUCT). Zotsutsana ziyenera kutsekedwa m'mabokosi, kotero timatsegula:
=СУММПРОИЗВ(
=SUMPRODUCT(
Kenako, onjezerani zotsutsana za ntchito. SUMPRODUCT (SUMPRODUCT) ikhoza kukhala ndi mikangano yambiri, koma nthawi zambiri ziwiri zimagwiritsidwa ntchito. Mu chitsanzo chathu, mkangano woyamba udzakhala ma cell angapo. B2:b9A yomwe ili ndi zigoli.
=СУММПРОИЗВ(B2:B9
=SUMPRODUCT(B2:B9
Mtsutso wachiwiri udzakhala ma cell angapo c2: c9, yomwe ili ndi zolemera. Mfundozi ziyenera kulekanitsidwa ndi semicolon (comma). Zonse zikakonzeka, tsekani mabulaketi:
=СУММПРОИЗВ(B2:B9;C2:C9)
=SUMPRODUCT(B2:B9,C2:C9)
Tsopano tiyeni tiwonjezere gawo lachiwiri la chilinganizo chathu, chomwe chidzagawanitse zotsatira zowerengedwa ndi ntchito SUMPRODUCT (SUMPRODUCT) ndi kuchuluka kwa zolemera. Tidzakambilana pambuyo pake cifukwa cake izi zili zofunika.
Kuti tichite ntchito yogawa, timapitiriza ndondomeko yomwe yalowetsedwa kale ndi chizindikiro / (kudula molunjika), ndiyeno lembani ntchitoyo SUM (SUM):
=СУММПРОИЗВ(B2:B9;C2:C9)/СУММ(
=SUMPRODUCT(B2:B9, C2:C9)/SUM(
Za ntchito SUM (SUM) tidzafotokoza mkangano umodzi wokha - ma cell angapo c2: c9. Musaiwale kutseka mabatani mutalowa mkangano:
=СУММПРОИЗВ(B2:B9;C2:C9)/СУММ(C2:C9)
=SUMPRODUCT(B2:B9, C2:C9)/SUM(C2:C9)
Okonzeka! Pambuyo kukanikiza kiyi Lowani, Excel idzawerengera kulemera kwake. Mu chitsanzo chathu, zotsatira zomaliza zidzakhala 83,6.
Momwe ntchito
Tiyeni tidutse gawo lililonse la fomula, kuyambira ndi ntchitoyo SUMPRODUCT (SUMPRODUCT) kuti mumvetsetse momwe zimagwirira ntchito. Ntchito SUMPRODUCT (SUMPRODUCT) imawerengetsera zomwe zapeza pachinthu chilichonse ndi kulemera kwake, kenako ndikuwerengera zonse zomwe zatuluka. Mwa kuyankhula kwina, ntchitoyi imapeza kuchuluka kwazinthu, motero dzina. Choncho kwa Ntchito 1 chulukitsani 85 ndi 5, ndi kwa Mayeso chulukitsa 83 ndi 25.
Ngati mukuganiza kuti chifukwa chiyani tiyenera kuchulutsa zikhalidwe mu gawo loyamba, taganizirani kuti kulemera kwa ntchitoyo, ndiye kuti nthawi zambiri timayenera kuganizira za kalasi yake. Mwachitsanzo, Ntchito 2 anawerenga ka 5 ndi Mayeso omaliza - 45 nthawi. Ndichifukwa chake Mayeso omaliza zimakhudza kwambiri kalasi yomaliza.
Poyerekeza, powerengera tanthawuzo la masamu, mtengo uliwonse umatengedwa kamodzi kokha, ndiye kuti, mfundo zonse zimakhala ndi kulemera kofanana.
Ngati mungathe kuyang'ana pansi pa hood ya ntchito SUMPRODUCT (SUMPRODUCT), tawona kuti amakhulupirira izi:
=(B2*C2)+(B3*C3)+(B4*C4)+(B5*C5)+(B6*C6)+(B7*C7)+(B8*C8)+(B9*C9)
Mwamwayi, sitifunika kulemba ndondomeko yaitali choncho chifukwa SUMPRODUCT (SUMPRODUCT) imachita zonsezi zokha.
Ntchito yokha SUMPRODUCT (SUMPRODUCT) imatibwezera chiwerengero chachikulu − 10450. Pakadali pano, gawo lachiwiri la fomula likuyamba kugwira ntchito: /SUM(C2:C9) or /SUM(C2:C9), zomwe zimabweza zotsatira pamlingo wabwinobwino wa zigoli, kupereka yankho 83,6.
Gawo lachiwiri la fomula ndilofunika kwambiri chifukwa limakupatsani mwayi wowongolera mawerengedwe. Kumbukirani kuti zolemera siziyenera kuwonjezera mpaka 100%? Zonsezi chifukwa cha gawo lachiwiri la chilinganizo. Mwachitsanzo, ngati tiwonjezera kulemera kwa chinthu chimodzi kapena zingapo, gawo lachiwiri la chilinganizo lidzangogawana ndi mtengo wokulirapo, ndikupangitsanso yankho lolondola. Kapena titha kupanga zolemera kukhala zazing'ono, mwachitsanzo pofotokoza zamtengo wapatali ngati 0,5, 2,5, 3 or 4,5, ndipo ndondomekoyi idzagwirabe ntchito moyenera. Ndi zabwino, chabwino?