Akwai hanyoyi da yawa na auna yawan al'amuran tsakiya ko, kamar yadda ake kira da yawa, matsakaici, don ƙayyadaddun dabi'u.
Mafi yawan ma'auni na ma'auni na tsakiya shine ƙididdigar mahimmanci - ko sauƙi - kuma an ƙidaya ta ƙara wata ƙungiyar lambobi tare sannan rarraba ta ƙidaya waɗannan lambobin. Alal misali, yawancin 4, 20, da 6 sun hada da juna kamar 10 kamar yadda aka nuna a jere 4.
Shafukan Wizard na Google yana da ayyuka masu yawa wanda zai sa ya sauƙi a sami wasu daga cikin dabi'u mafi yawan amfani. Wadannan sun haɗa da:
- Ayyukan aikin AVERAGE - sami alamar lissafi don lissafin lambobi.
- Ayyukan MEDIAN - sami darajar tsakiyar cikin lissafin lambobi.
- Ayyukan MODE - yana samun darajar mafi yawan gaske a jerin lambobi.
Haɗin Gudanar da Ayyuka da Jayayya
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 AVERAGE shine:
= BABI NA (lambar_1, number_2, ... number_30)
- number_1 - (da ake buƙata) bayanan da za a iya ɗauka ta hanyar aiki
- number_2 zuwa number_30 - (na zaɓi) ƙarin bayanan halayen da za a haɗa su cikin matsakaita. Matsakaicin adadin shigarwar da aka yarda shi ne 30
Ƙididdigar lissafi na iya ƙunsar:
- Jerin lambobin da za su kasance masu girma;
- Siffofin da aka kwatanta da sassan layi na bayanai a cikin takardun aiki;
- Hanyoyin tantancewar salula;
- Sunan mai suna.
Lura: Bayanin rubutun da Kwayoyin da ke ƙunshi dabi'un Boolean (TRUE ko FALSE) an rasa su ta hanyar aikin kamar yadda aka nuna a layuka 8 da 9 a cikin hoton da ke sama.
Idan kwayoyin da ba su da cikakkun bayanai ko sun ƙunshi rubutu ko Boolean dabi'un an canja su a baya don rike lambobi, matsakaita za su sake dawowa don sauke canje-canje.
Cells Blank vs. Zero
Idan yazo ga gano dabi'u mai mahimmanci a cikin Shafukan Rubutun Google, akwai bambanci tsakanin nau'in komai ko kullun da waɗanda suke dauke da nau'i maras kyau.
Kwayoyin raguwa ba su kula da aikin AVERAGE, wanda zai iya zama mai amfani tun lokacin da ya sa gano ƙayyadadden ƙwayoyin marasa jigilar bayanai kamar yadda aka nuna a jere na 6 a sama.
Sel ɗin da ke dauke da darajar zabin, duk da haka, an haɗa su cikin matsakaicin kamar yadda aka nuna a jere 7.
Sakamakon aikin gyaran fuska
Kamar yadda sauran ayyukan da aka gina a cikin Shafukan Gidan Google, ana iya samun dama ga aikin AVERAGE ta danna Saka > Aikace-aikace a cikin menus don buɗe jerin ɓangaren ayyukan da aka yi amfani da su wanda ya haɗa da aikin AVERAGE.
A madadin, saboda ana amfani dashi, an sanya hanya zuwa hanya zuwa shirin kayan aiki na shirin, don ya sa ya fi sauki don ganowa da amfani.
Alamar a kan kayan aiki don wannan da sauran ayyukan da ake amfani da shi shine rubutun Helenanci Sigma ( Σ ).
Shafukan Lissafi na Google Ayyukan GABATARWA Misali
Matakan da ke ƙasa suna rufe yadda za a shiga aikin AVERAGE da aka nuna a jere hudu a cikin misalin a cikin hoton da ke sama ta amfani da gajeren hanya zuwa aikin AVERAGE da aka ambata a sama.
Shigar da aikin NASIHIYA
- Danna kan tantanin halitta D4 - wurin da za a nuna sakamakon zafin.
- Danna maɓallin ayyuka a kan kayan aiki a sama da aikin aiki don buɗe jerin abubuwan da aka sauke.
- Zaži Matsakaici daga lissafi don sanya kwafin kwafin aikin a cikin dakin D4.
- Sakamakantar sassan A4 zuwa C4 don shigar da waɗannan nassoshi kamar yadda muhawarar ke aiki kuma latsa maɓallin Shigar da ke keyboard.
- Yawan lamba 10 ya kamata ya bayyana a cell D4. Wannan shine adadin lambobi uku - 4, 20, da 6.
- Lokacin da ka danna kan salula A8 cikakken aikin = BABI NA AYA (A4: C4) ya bayyana a cikin maɓallin tsari a sama da takardun aiki.
Bayanan kula:
- Kwayoyin mutum guda, maimakon wani ci gaba mai ɗorewa za'a iya ƙara su a matsayin muhawara amma dole ne a raba raƙuman tantanin halitta ta hanyar wakafi.
- Bayan shigar da aikin, idan an yi canje-canjen zuwa bayanai a cikin sel da aka zaɓa, aikin, ta tsoho, ta sake saukewa ta atomatik don nunawa canji.