Izihlwele Mathematics. avareji

Kwimathematika, i-avareji lokubala eliguqukayo amanani (okanye avareji) - udibaniso lwamaxabiso wonke amanani kweli iseti, lahlulwe ngenani labo. Lo gama kunayo kunye ngokubanzi kwe-avareji ubukhulu. Njengoko usazi, ukufumana ixabiso avareji, kuyimfuneko ukuba azihlanganisele yonke idatha kufuneka uze ulahlule ngenani ngokwalo.

Yintoni arithmetic ukuthini?

Makhe sijonge umzekelo.

Umzekelo 1. amanani anikiweyo 6, 7, 11. Kufuneka ukufumana ixabiso labo avareji.

Isigqibo.

Okokuqala, fumana isiphumo onke amanani data.

6 + 7 + 11 = 24

Ngoku yahlula imali waba inani ngokwalo. Ekubeni amagama amathathu, ngokulandelelana, sisahlula amathathu.

24: 3 = 8

Ngenxa yoko, ixabiso umndilili amanani 6, 7 no-11 - ngu 8. Kutheni 8? Ngenxa inani 6, 7 no-11 ziya kuba ngokufanayo eights ezintathu. Oku ngokucacileyo mzekeliso.

Ixabiso avareji Kuthi efanayo i "sokulinganisa" lwamanani. Njengoko ubona, iqela iipensile baye baba kwinqanaba elifanayo.

Cinga omnye umzekelo, ukuba ukubethelela ulwazi lwabo.

Umzekelo 2. amanani Xa: 3, 7, 5, 13, 20, 23, 39, 23, 40, 23, 14, 12, 56, 23, 29. Kubalulekile ukufumana ixabiso labo avareji.

Isigqibo.

Sifumana sum.

3 + 7 + 5 + 13 + 20 + 23 + 39 + 23 + 40 + 23 + 14 + 12 + 56 + 23 + 29 = 330

Yahlula ngenani ngokwalo (kulo mzekelo - 15).

330: 15 = 22

Ngenxa yoko, ixabiso kwe iseti yamanani ilingana no-22.

Ngoku cinga amanani akhabayo. Khumbula ukushwankathela njani. Umzekelo, ukuba une amanani amabini-1 no -4. Iya bawadibanise.

1 + (-4) = 1 - 4 = -3

Ukwazi oku, makhe siqwalasele omnye umzekelo.

Umzekelo 3. Fumana ixabiso koko lwamanani: 3, -7, 5, 13, -2.

Isigqibo.

Fumana inani amanani.

3 + (-7) + 5 + 13 + (-2) = 12

Ekubeni imiqathango ye-5, bayahlule imali leyo yi-5.

12: 5 = 2,4

Ngenxa yoko, le yokalo emileyo kuthetha ixabiso-3, -7, 5, 13, -2 ngu 2.4.

Kule mihla, inkqubela zeteknoloji Kulula kakhulu ukuba ukusebenzisa i ekufumaneni ixabiso avareji lweenkqubo ze computer. Microsoft Office Excel - omnye wabo. Khangela ixabiso avareji e-Excel kuphekeka lula. Ingakumbi, le nkqubo kwi Microsoft Office iphakheji software. , Cinga imiyalelo emfutshane ukufumana indlela yokalo emileyo kuthetha ixabiso le program.

Ukuze kubalwe ixabiso avareji uthotho amanani, sebenzisa umsebenzi AVERAGE. Syntax kuba lo msebenzi:
= Avareji (argument1, argument2, ... argument255)
apho argument1, argument2, ... argument255 - ukuba mhlawumbi amanani okanye izikhombisi iseli (iiseli ithetha leenomboro lens).

Ukwenza kucace ngakumbi, siya ukuvavanya ulwazi olufunyenweyo.

1. Faka inombolo 11, 12, 13, 14, 15, 16 kwisisele C1 - B6.
2. Khetha iseli C7, ngokunqakraza kwi kuyo. Kule ndawo, siya kubonisa ukubaluleka avareji.
3. Nqakraza kwi "Iifomula 'tab.
4. Khetha Imisebenzi Okunye> ukuze Statistical ukuvula i drop-phantsi uluhlu.
5. Khetha AVERAGE. Emva kule bhokisi yencoko yababini kufuneka ukuvula.
6. Khetha kwaye tsala wesisele C1-C6, ukuba ukhankanye ulungiso kwibhokisi yencoko yababini.
7. Qinisekisa isenzo yakho ngokucinezela "Kulungile".
8. Ukuba wenza yonke into ngokuchanekileyo, i-C7 iseli, kufuneka ubone impendulo - 13.7. Ngokunqakraza kwi ariya umsebenzi C7 (= avareji (C1: B6)) ziya kuboniswa kwi bar formula i.

elula kakhulu ukuba ukusebenzisa lo msebenzi ku ukugcina iirekhodi, ii-invoyisi okanye xa nje kufuneka ukuba ufumane ixabiso avareji kuthotho elide kakhulu amanani. Ngoko ke, oko kudla ngokusetyenziswa ofisi kunye neenkampani ezinkulu. Oku kukuvumela ukuba ndinimisele umyalelo iirekhodi, kwaye yenza kube lula ngokukhawuleza ukufumana nantoni na (umzekelo, ingeniso-avareji ngenyanga nganye). Kwakhona ngoncedo Excel, unako ukufumana ixabiso avareji lo msebenzi.