Wannan sashe yana ba da bayyani na wasu ayyukan ƙididdiga masu fa'ida a Excel.
GABAWA
aiki GABAWA (AVERAGE) ana amfani da shi don ƙididdige matsakaicin ƙididdiga. Ana iya ba da muhawara, alal misali, a matsayin nuni ga kewayon sel.
RASHIN ZUCIYA
Don ƙididdige ma'anar lissafin sel waɗanda suka dace da ma'auni, yi amfani da aikin RASHIN ZUCIYA (AVERAGEIF). Anan ga yadda, alal misali, zaku iya ƙididdige ma'anar lissafin duk sel a cikin kewayo A1:O1, wanda darajarsa ba ta kai sifili ba (<>0).
lura: Sign <> yana nufin BA DADAI BA. Aiki RASHIN ZUCIYA yayi kama da aiki SUMMESLI.
MADIYA
Amfani da ayyuka MADIYA (MEDIAN) zaku iya ayyana matsakaicin (tsakiyar) na saitin lambobi.
Duba:
FASHION
aiki FASHION (MODE) yana samun lambar da ta fi faruwa akai-akai a cikin saitin lambobi.
Daidaitawar daidaituwa
Don ƙididdige madaidaicin karkata, yi amfani da aikin STDEV (STDEV).
MIN
Amfani da ayyuka MIN (MIN) zaku iya nemo mafi ƙarancin ƙima daga saitin lambobi.
MAX
Amfani da ayyuka MAX (MAX) zaku iya nemo madaidaicin ƙimar daga saitin lambobi.
manyan
Ga yadda ake amfani da aikin manyan (BABBAN) zaku iya nemo kima mafi girma na uku daga saitin lambobi.
Duba:
KASHE
Anan ga yadda ake nemo mafi ƙarancin ƙima ta biyu ta amfani da aikin KASHE (KARAMIN).
Duba: