01 na 05
Nemo darajar ta tsakiya tare da aikin aikin MEDIAN
Akwai hanyoyi da dama na aunawa ko, kamar yadda ake kira shi, matsakaicin, don saitin dabi'u.
Don yin sauki don auna ma'auni na tsakiya, Google Spreadsheets yana da ayyuka masu yawa wanda zasu lissafta dabi'un da aka fi amfani dasu da yawa. Wadannan sun haɗa da:
- Ayyukan MEDIAN - sami adadi na tsakiya ko tsakiyar cikin lissafin lambobi;
- Ayyukan aikin AVERAGE - sami mahimmanci na mahimmanci don lissafin lambobi;
- Ayyukan MODE - sami yanayin ko mafi yawan lamarin da ke faruwa a jerin lambobi.
02 na 05
Gano Harshen Lissafi na Median
An fi sauƙi a ƙididdige tsakiyar tsakiyar don ƙidayar lambobin dabi'u. Don lambobi 2,3,4, tsakiyar tsakiya, ko darajar tsakiya, ita ce lamba 3.
Tare da yawan adadin lambobin, an ƙidaya tsakiyar tsakiyar ta hanyar gano mahimmanci ko mahimmanci ga dabi'u biyu.
Alal misali, adadi na lambobi 2,3,4,5, an ƙayyade ta hanyar ƙaddara tsakiyar lambobin lambobi 3 da 4:
(3 + 4) / 2wanda ke haifar da wata tsakani na 3.5.
03 na 05
Hanyoyin aikin MEDIAN da maganganu
Haɗin aikin aiki yana nufin layout na aikin kuma ya haɗa da sunan aiki, shafuka, rabuɗɗun takaddama, da muhawara .
Haɗin aikin aikin MEDIAN shine:
= MEDIAN (lambar_1, number_2, ... number_30)
number_1 - (da ake buƙata) bayanan da za a hada a lissafta tsakiyar
number_2: number_30 - (na zaɓi) ƙarin bayanan dabi'u don a haɗa su a cikin lissafi na tsakiya. Matsakaicin adadin shigarwar da aka yarda shi ne 30
Ƙididdigar lissafi na iya ƙunsar:
- jerin lambobi;
- tantanin halitta sunyi bayanin wuri na bayanai a cikin takardun aiki;
- wani kewayon tantancewar salula;
- wani layi mai suna .
04 na 05
Misali ta yin amfani da aikin MEDIAN
Ana amfani da matakan da aka biyo don shigar da aikin MEDIAN a D2 cell.
- Rubuta alamar daidai (=) biye da sunan aikin tsakani;
- Yayin da kake bugawa, akwatin zane - zane yana nuna tare da sunaye da haɗin ayyukan da suka fara da wasika M;
- Lokacin da sunan dan labaran ya bayyana a cikin akwatin, danna maɓallin shigarwa a kan keyboard don shigar da aikin aiki da bude budewa zuwa cikin cell D2;
- Sanya siffofin A2 zuwa C2 don hada su a matsayin muhawarar aikin;
- Latsa maɓallin Shigar don ƙara maƙallin rufewa da kuma kammala aikin;
- Lambar 6 ya kamata ya bayyana a cell A8 a matsayin matsakaicin lambobi uku;
- Lokacin da ka danna kan tantanin halitta D2 cikakkiyar aikin = MEDIAN (A2C2) ya bayyana a cikin maɓallin tsari a sama da takardun aiki .
05 na 05
Cells Blank vs. Zero
Idan ya zo ne don gano maƙalli a cikin rubutun Gidan Google, akwai bambanci tsakanin nau'in kullun ko kullun da wadanda ke dauke da nau'i maras kyau.
Kamar yadda aka nuna a misalai da ke sama, Kwayoyin suturta suna watsi da aikin MEDIAN amma ba wadanda suke dauke da nau'i maras nauyi ba.
Bambanci yana canzawa tsakanin misalai a cikin layuka hudu da biyar saboda an ƙara siffar ƙwayar jikin B5 a yayin da cell B4 ta kasance maras nauyi.
Saboda,:
- Ƙididdigar jinsi na jere hudu an ƙidaya ta ƙara (6 + 4) / 2 = 5
- Tsakanin jinsin na jere biyar shine kawai tsakiyar abubuwa uku: 4