Whakangahau Pāngarau. toharite

I roto i te pāngarau, te toharite tauhanga o nga tau (ranei toharite) - te moni o nga tau katoa i roto i tenei huinga, wehea e ratou te maha. Ko te ariā tino whānui, me te whānui rahi toharite o tenei. Ka rite ki matau ana koe, ki te kitea te uara toharite, he mea e tika ana katoa o te raraunga e hiahia ana koe ki te huihuia ake, ka wehe ai i te maha o ngā.

He aha te mea toharite tauhanga?

Kia titiro a i te tauira.

Tauira 1. tau hoatu 6, 7, 11. Me matou ki te kitea to ratou uara toharite.

Whakatau.

Hei timata, kitea te moni o nga tau katoa o te raraunga.

6 + 7 + 11 = 24

wehe nei tatou i te moni hua i te maha o ngā. Mai to tatou e toru ngā, aua, wehe matou i te toru.

24: 3 = 8

Nō reira, ko te uara toharite o te tau 6, 7 me te 11 - ko te 8. He aha 8? No te mea ka waiho i te taua rite toru eights te nui o 6, 7 me te 11. Kei te mārama kitea tenei i roto i te faahoho'araa.

Ko te ahua rite ki te "te whakaōritenga" o tau te uara toharite. Ka rite ki a koutou e taea te kite, kua riro te paihere o pene rākau te taumata kotahi.

Fakakaukau ki tetahi atu tauira, ki te whakatōpū ratou matauranga.

Tauira 2. tau Homai: 3, 7, 5, 13, 20, 23, 39, 23, 40, 23, 14, 12, 56, 23, 29. Ko reira tika ki te kitea to ratou uara toharite.

Whakatau.

kitea e matou i te moni.

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

Vahevahe e te maha o ngā kupu (i roto i tenei take - 15).

330: 15 = 22

Nā tēnei, he rite ki te 22 te uara toharite o te huinga o ngā tau.

whakaaro Na nga tau tōraro. A haamana'o pehea ki te whakarāpopoto ratou. Hei tauira, i koe e rua tau e 1 me -4. E kitea ratou moni.

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

E matau ana tenei, kia whakaaro tatou i tetahi atu tauira.

Tauira 3. Kimihia te uara toharite o tau: 3, -7, 5, 13, -2.

Whakatau.

Kimihia te moni o nga tau.

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

Mai te ngā o 5, wehe i te nui hua e 5.

12: 5 = 2.4

Nō reira, te tikanga o te tauhanga uara o te 3, -7, 5, 13, -2 he 2.4.

I tčnei wā, he nui atu watea hangarau te ahunga whakamua ki te whakamahi i mo te kimi i te uara toharite o ngā hōtaka rorohiko. Microsoft Office Excel - tetahi o ratou. Rapu uara toharite i roto i Excel tere, me te ngāwari. Rawa, Ko tenei hōtaka i runga i te mōkihi pūmanawa Microsoft Office. A feruri i te tohutohu poto, me pehea ki te kitea te tauhanga uara ki tenei hōtaka.

I roto i te tikanga ki te tātai i te raupapa uara toharite o tau, te whakamahi i te mahi AVERAGE. Ko te wetereo mō tenei mahi:
= Wawaenga (argument1, argument2, ... argument255)
te wahi argument1, argument2, ... argument255 - te reira rānei te tau tohutoro pūtau ranei (hoki te tikanga o ngā pūtau awhe me ngā huānga).

Ki te hanga i taua mea atu mārama, ka whakamatautau matou riro te matauranga.

1. E tomo te tau 11, 12, 13, 14, 15, 16 i roto i te C1 pūtau - C6.
2. Tīpakohia C7 pūtau, mā te pāwhiri i runga reira. I roto i tenei tauwāhi, ka whakaatu tatou te uara toharite.
3. Pāwhiritia i runga i te ripa "Tātai".
4. Tīpakohia Taumahi atu> tikanga Statistical ki te whakatuwhera i te rārangi taka-iho.
5. Tīpako AVERAGE. I muri kia whakatūwhera mai tēnei pouaka kōrero.
6. Tīpakohia me te tō ki te pūtau C1-C6, ki te tautuhi i te whānuitanga i roto i te pouaka kōrero.
7. Whakaūngia koutou mahi mā te pēhi i "OK".
8. Ki te meatia e koe nga mea katoa tika, te C7 pūtau, kia kite koe i te whakautu - 13.7. Mā te pāwhiri i runga i te C7 mahi pūtau (= Wawaenga (C1: C6)) ka whakaaturia i roto i te pae tātai.

Tino watea ki te whakamahi i tenei mahi ki te record-tauhi, nama ranei ka hiahia noa koe ki te kitea te uara toharite o te raupapa rawa roa o tau. Na reira, Kei te maha whakamahia te reira i roto i tari me kamupene nui. Tenei taea ki a koe e tiaki i te tikanga o nga pūkete, me hanga reira taea ki te kitea e hohoro tetahi (hei tauira, te moni toharite ia marama). Hoki ki te awhina o Excel, ka taea e kitea e koe i te uara toharite o te mahi.