A cikin aiwatar da ƙididdigar daban-daban da aiki tare da bayanai, yawanci wajibi ne don lissafin ƙimar matsakaicinsu. An ƙididdige shi ta ƙara lambobi da rarraba jimlar adadin ta lambar. Bari mu gano yadda za a ƙididdige matsakaicin darajar ɗin adadin lambobi ta amfani da Microsoft Excel ta hanyoyi daban-daban.
Hanya madaidaiciya don yin lissafi
Hanya mafi sauƙi kuma sananniyar hanya don gano ma'anar ilimin lissafi na jerin lambobi shine amfani da maɓallin na musamman akan kintinkiri na Microsoft Excel. Zaɓi lambobi da yawa dake cikin akwati ko jere na daftarin aiki. Kasancewa cikin shafin "Gida", danna maɓallin "AutoSum", wanda ke kan kintinkiri a cikin toshe kayan aiki "Gyara". Daga jerin zaɓin-zaɓi, zaɓi "Matsakaici".
Bayan wannan, ta yin amfani da aikin "AVERAGE", ana yin lissafin. Ana nuna ma'anar ilmin lissafi na wannan saitin lambobi a cikin tantanin halitta a ƙarƙashin sashin da aka zaɓa, ko zuwa dama na layin da aka zaɓa.
Wannan hanyar tana da kyau don sauƙi da saukakawa. Amma, har ila yau yana da mahimmancin rashin nasara. Ta amfani da wannan hanyar, zaku iya ƙididdige matsakaiciyar adadin waɗancan lambobin da suke a jere a cikin layi ɗaya, ko a layi ɗaya. Amma, tare da tsararru na sel, ko tare da sel da aka warwatsa akan takarda, ba za ku iya aiki da wannan hanyar ba.
Misali, idan ka zabi biyu sassan biyu kuma ka kirkiri ma'anar ilmin lissafi ta hanyar da aka bayyana a sama, to za a bayar da amsar ga kowane shafi daban, kuma ba duka rukunin sel ba.
Lissafi ta amfani da Wijin Aiki
Don lokuta idan kuna buƙatar lissafin matsakaita na tsararru na sel, ko sel disparate, zaku iya amfani da Wurin Aiki. Yana amfani da ɗayan "AUTAGE" ɗaya ɗaya, wanda muka sani daga hanyar ƙididdigar farko, amma yana aikatawa ta wata hanyar dabam.
Mun danna kan sel inda muke son sakamakon ƙididdige matsakaiciyar ƙimar da za a nuna. Danna maɓallin "Saka aikin", wanda ke gefen hagu na masarar dabara. Ko kuma, mun buga a kan madannin hade da Shift + F3.
Mai maye aikin yana farawa. A cikin jerin ayyukan da aka gabatar, nemi “KYAUTA”. Zaɓi shi, kuma danna maɓallin "Ok".
Za a buɗe taga gardamar wannan aikin. An shigar da huɗar da ke cikin aikin a cikin filayen Lambobi. Wadannan na iya zama lambobin talakawa ko adireshin sel inda wadannan lambobin suke. Idan ba shi da wahala a gare ku shigar da adiresoshin sel hannu da hannu, ya kamata ku danna maballin da yake gefen dama na filin shigarwar bayanai.
Bayan haka, taga muhawara na aiki za a rage, kuma zaku iya zaɓar rukuni na sel akan takardar da kuka ɗauka don ƙididdigewa. Bayan haka, sake danna maɓallin a hagu na filin shigarwa don komawa zuwa taga muhawara na aiki.
Idan kana son yin lissafin ma'anar ilmin lissafi tsakanin lambobin da ke cikin rabe-raben sel, to aikata ayyukan da aka ambata a sama, yi a filin "Lambar 2". Sabili da haka har sai an zaɓi duk ƙungiyoyin da suka zama dole.
Bayan haka, danna maɓallin "Ok".
Sakamakon yin lissafin ma'anar ilmin lissafi za a nuna alama a cikin tantanin da ka zaɓi kafin fara Wizard ɗin aiki.
Hanyar Gas
Akwai hanya ta uku don gudanar da AUTAGE. Don yin wannan, je zuwa shafin "Kayan tsari". Zaɓi tantanin da za'a nuna sakamakon shi. Bayan haka, a cikin rukunin kayan aiki na "Kayan Aiki" a kan kintinkiri, danna maballin "Sauran Ayyuka". Jerin yana bayyana wanda kake buƙatar tafiya kai tsaye zuwa abubuwan "ƙididdiga" da "AVERAGE".
To, ainihin wannan taga na muhawara na aiki an ƙaddamar da shi azaman lokacin amfani da Wizard Function, aikin da muka bayyana dalla-dalla a sama.
Actionsarin ayyuka iri ɗaya ne.
Shigarwa aikin hannu
Amma, kar a manta cewa koyaushe zaka iya shiga aikin “KYAUTA” da hannu idan kana so. Zai sami tsari mai zuwa: "= AVERAGE (cell_range_address (lamba); cell_range_address (lamba)).
Tabbas, wannan hanyar ba ta dace da wacce ta gabata ba, kuma tana buƙatar wasu dabarun da za'a kiyaye su a zuciyar mai amfani, amma tana da sassauƙa.
Lissafi na matsakaicin darajar don yanayin
Bayan ƙididdigar da aka saba da ƙimar matsakaicin, yana yiwuwa yin lissafin ƙimar matsakaicin gwargwadon yanayin. A wannan halin, lambobin kawai daga zaɓin da aka zaɓa waɗanda suka dace da wani yanayin za a la'akari. Misali, idan wadannan lambobin sunfi girma ko kasa da takamaiman darajar.
Don waɗannan dalilai, ana amfani da "AUTAGE". Kamar aikin "AUTAGE", za'a iya ƙaddamar da shi ta hanyar Wutar da Aiki, daga masarar dabara, ko ta shiga hannu da hannu. Bayan taga muhawara na aikin ya bude, kana buƙatar shigar da sigoginsa. A cikin filin "Range", shigar da kewayon sel waɗanda dabi'un su za su shiga tsakani don ƙididdige matsakaitan lissafi. Munyi wannan ne daidai kamar yadda yake tare da AUTAGE aiki.
Kuma a nan, a cikin filin "Yanayi" dole ne mu nuna takamaiman darajar, lambobi fiye da ƙasa waɗanda zasu shiga cikin lissafin. Ana iya yin wannan ta amfani da alamun kwatanta. Misali, mun dauki taken "> = 15000". Wannan shine, kawai sel na kewayon wanda lambobi mafi girma ko daidai suke da 15000 ana samun su don yin lissafi Idan ya cancanta, maimakon takamaiman lambar, anan zaka iya tantance adireshin tantanin da acikin lambar daidai yake.
Filin filin tsakani yana da zaɓi. Shigar da bayanai a ciki ya zama dole ne kawai lokacin amfani da sel tare da abubuwan rubutu.
Lokacin da aka shigar da dukkan bayanai, danna maɓallin "Ok".
Bayan wannan, sakamakon ƙididdigar lissafin matsakaitan kewayon da aka zaɓa ana nuna shi a cikin sel da aka zaɓa, ban da sel waɗanda bayanansu basu cika sharuɗan ba.
Kamar yadda kake gani, a cikin Microsoft Excel, akwai kayan aikin da yawa waɗanda za ku iya ƙididdige yawan adadin adadin zaɓaɓɓun lambobin da aka zaɓa. Haka kuma, akwai aikin da zai zaɓi lambobi ta atomatik daga kewayon da bai cika ka'idodin da mai amfani ya shimfida ba. Wannan yana sanya lissafi a Microsoft Excel har ma ya fi dacewa ga masu amfani.
