Entertaining Lej. nruab nrab

Nyob rau hauv kev kawm txog zauv, lub xam nruab nrab ntawm cov xov tooj (los yog nruab nrab) - lub sum ntawm tag nrho cov zauv nyob rau hauv no set, muab faib los ntawm lawv tus xov tooj. Qhov no yog lub feem ntau ntau thiab generalized tswvyim ntawm nruab nrab loj. Raws li koj paub, mus nrhiav qhov nruab nrab nqi, nws yog tsim nyog los zaum pem tag nrho cov ntaub ntawv uas koj xav tau thiab faib nws los ntawm tus xov tooj ntawm cov nqe lus.

Yuav ua li cas yog xam txhais li cas?

Cia saib ib qho piv txwv.

Piv txwv li 1. Muab cov xov tooj 6, 7, 11. Peb yuav tsum tau mus nrhiav tau lawv qhov nruab nrab tus nqi.

Kev txiav txim siab.

Yuav pib, nrhiav lub sum ntawm tag nrho cov zauv ntawm cov ntaub ntawv.

6 + 7 + 11 = 24

Tam sim no sib faib ua ntau npaum li cas los ntawm tus xov tooj ntawm cov nqe lus. Txij li thaum peb muaj peb nqe lus, ntsig txog, peb faib los ntawm peb.

24: 3 = 8

Li ntawd, cov nruab nrab tus nqi ntawm cov xov tooj 6, 7 thiab 11 - yog 8. Vim li cas 8? Vim hais tias tus nqi ntawm cov 6, 7 thiab 11 yuav tsum yog tib yam li peb eights. Qhov no yog kom meej meej pom nyob rau hauv daim duab.

Qhov nruab nrab nqi yog dog dig zoo li tus "leveling" ntawm cov zauv. Raws li koj tau pom, ib Rev ntawm tus cwj mem qhuav tau ua rau tib theem.

Xav txog lwm cov piv txwv, mus ntsaub lawv cov kev paub.

Piv txwv li 2. Muab tus xov tooj: 3, 7, 5, 13, 20, 23, 39, 23, 40, 23, 14, 12, 56, 23, 29. Nws yog tsim nyog mus nrhiav tau lawv qhov nruab nrab tus nqi.

Kev txiav txim siab.

Peb nrhiav tau cov sum.

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

Faib los ntawm tus xov tooj ntawm cov nqe lus (nyob rau hauv cov ntaub ntawv no - 15).

330: 15 = 22

Li ntawd, cov phem tus nqi ntawm lub teeb ntawm tus xov tooj yog sib npaug zos rau 22.

Tam sim no xav txog qhov tsis zoo tus xov tooj. Nco qab yuav ua li cas saib lub ntsab lug lawv. Piv txwv li, koj muaj ob tug zauv yog 1 thiab -4. Yuav nrhiav tau lawv sum.

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

Peb paub li no, cia peb xav txog lwm cov piv txwv.

Piv txwv li 3. Nrhiav qhov phem tus nqi ntawm tus xov tooj: 3, -7, 5, 13, -2.

Kev txiav txim siab.

Nrhiav cov sum ntawm cov zauv.

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

Txij li thaum cov ntsiab lus ntawm 5, faib lub resulting nqi los ntawm 5.

12: 5 = 2,4

Li ntawd, cov zauv txhais li cas tus nqi ntawm 3, -7, 5, 13, -2 yog 2.4.

Niaj hnub no, hauj kev kawm ntau npaum li cas yooj yim rau siv rau kev nrhiav qhov nruab nrab nqi ntawm computer programs. Microsoft Office Excel - ib tug ntawm lawv. Nrhiav nruab nrab tus nqi nyob rau hauv Excel ceev thiab yooj yim. Tshwj xeeb tshaj yog, qhov kev pab cuam yog nyob rau hauv Microsoft Office software pob. Xav txog cov nyuag lus qhia, yuav ua li cas nrhiav tau cov kev laij mean nqi nrog qhov kev pab cuam.

Nyob rau hauv thiaj li yuav xam qhov nruab nrab tus nqi ntawm ib tug series ntawm cov zauv, siv lub NRUAB NRAB muaj nuj nqi. Cov syntax rau no muaj nuj nqi:
= Nruab nrab (argument1, argument2, ... argument255)
qhov twg argument1, argument2, ... argument255 - nws yog tog twg los lub xov tooj los yog cell ua tim khawv (rau hlwb meant yog hom twg thiab arrays).

Yuav kom ua rau nws ntshiab, peb yuav ntsuam xyuas cov kev txawj ntse tau.

1. Sau xov tooj 11, 12, 13, 14, 15, 16 nyob rau hauv cell C1 - C6.
2. Xaiv cell C7, los ntawm txhaj rau nws. Nyob rau hauv no qhov chaw, peb yuav qhia qhov nruab nrab tus nqi.
3. Nyem rau ntawm qhov "qauv" tab.
4. Xaiv Ntau Tso> Statistical thiaj mus qhib ib tug nco-down daim ntawv teev.
5. Xaiv cov NRUAB NRAB. Tom qab no dialog box yuav tsum qhib.
6. Xaiv thiab luag yuav cell C1-C6, qhia kom meej rau ntau yam nyob rau hauv lub dialog box.
7. Paub meej tias koj txiav txim los ntawm nias "OK".
8. Yog hais tias koj tau ua txhua yam kom raug, lub cell C7, koj yuav tsum mus ntsib ib tug teb - 13.7. Yog txhaj rau cov cell muaj nuj nqi C7 (= nruab nrab (C1: C6)) yuav tsum tau muab tso tawm kom pom nyob rau hauv cov mis bar.

Heev yooj yim rau siv no muaj nuj nqi rau cov ntaub ntawv-cia, txib los yog thaum koj cia li yuav tau mus nrhiav qhov nruab nrab tus nqi ntawm ib tug ntev heev series ntawm cov zauv. Yog li ntawd, nws yog feem ntau siv nyob rau hauv chaw ua hauj lwm thiab loj tuam txhab uas muag. Qhov no tso cai rau koj kom cov ntaub ntawv nyob rau hauv kev txiav txim thiab yuav ua rau nws ua tau rau sai sai nrhiav tau dab tsi (piv txwv li, lub nruab nrab cov nyiaj khwv tau ntawm ib lub hlis). Tsis tas li ntawd nrog rau cov kev pab los ntawm Excel, koj yuav nrhiav tau qhov nruab nrab tus nqi ntawm cov nuj nqi.