Bayanan lissafin bayanai shine tarin, sarrafawa, tattarawa da kuma nazarin bayanai tare da ikon ƙayyade abubuwan da suka shafi abubuwan da ake nazarin. A cikin Excel, akwai kayan aiki masu yawa waɗanda zasu taimake su gudanar da bincike a wannan yanki. Sabbin sifofin wannan shirin ba su da ƙari ga aikace-aikace na ƙididdigar ƙwarewa dangane da damar. Babban kayan aiki don yin lissafi da bincike su ne ayyuka. Bari mu binciko fasalin fasali na aiki tare da su, da kuma zama a kan wasu kayan aiki masu amfani.
Ayyukan lissafi
Kamar sauran ayyuka a cikin Excel, ayyuka na ilimin lissafin aiki suna aiki a kan jayayya wanda zai iya kasancewa a cikin nau'i na lambobi, nassoshi akan sel ko na'ura.
Za a iya shigar da maganganu da hannu a cikin wani ƙirar maɓalli ko kuma a cikin sashin sharaɗin, idan kun san sassauci na musamman. Amma yana da mafi dacewa don amfani da maɓallin bayani na musamman, wanda ya ƙunshi alamu da kayan shigarwa na shirye-shirye. Je zuwa mabudin hujja na maganganun lissafi na iya zama ta hanyar "Ma'aikatar Ayyuka" ko amfani da maballin "Dakunan Gidan Ma'aikata" a kan tef.
Akwai hanyoyi uku don fara aikin aiki:
- Danna kan gunkin "Saka aiki" zuwa hagu na dabarun tsari.
- Da yake cikin shafin "Formulas", danna kan rubutun a kan maballin "Saka aiki" a cikin asalin kayan aiki "Gidan Kayan aiki".
- Rubuta gajeren hanya na keyboard Shift + F3.
Lokacin yin wani zaɓi na sama, taga zai bude. "Masters na ayyuka".
Sa'an nan kuma kana buƙatar danna kan filin "Category" kuma zaɓi darajar "Labarin lissafi".
Bayan haka jerin jerin kalmomi zasu buɗe. A cikin duka akwai fiye da mutum ɗari. Don zuwa jigon gardama na kowane ɗayan su, kawai kuna buƙatar zaɓar shi kuma danna maballin "Ok".
Domin mu je abubuwan da muke bukata ta wurin rubutun, kunna zuwa shafin "Formulas". A cikin ƙungiyar kayan aiki a kan tef "Gidan Kayan aiki" danna maballin "Sauran Ayyuka". A cikin jerin da ya buɗe, zaɓi wani layi "Labarin lissafi". Jerin abubuwa masu samuwa na jagoran da ake so. Don zuwa jayayya, kawai danna kan ɗaya daga cikinsu.
Darasi: Wizard Function Wizard
MAX
An tsara MAX mai aiki don ƙayyade yawan adadin samfurori. Yana da wadannan haruɗɗa:
= MAX (lamba 1; lambar 2; ...)
A cikin bangarori na muhawara kana buƙatar shigar da jeri na sel wanda aka samo jerin jerin. Mafi yawan yawan shi, wannan tsari yana nuna a tantanin halitta wanda shine kanta.
MIN
Da sunan aikin MIN, ya bayyana cewa ayyukansa suna fuskantar tsayayya ga ma'anar da ta gabata - yana bincika mafi ƙanƙanci daga jerin lambobi kuma yana nuna shi a cikin cell da aka ba su. Yana da wadannan haruɗɗa:
= MIN (lamba1; number2; ...)
GABAWA
Ayyukan aikin kulawa na neman lambobi a cikin kundin da aka keɓance shi ne mafi kusa da ilmin lissafi. Sakamakon wannan lissafin yana nunawa a cikin tantanin salula wanda aka kunshi tsari. Ta samfurin kamar haka:
= BINCIKE (lamba1; number2; ...)
GABAWA
Ayyukan aikin kulawa yana da nau'ikan ayyuka kamar wanda ya gabata, amma a ciki akwai damar da za a saita ƙarin yanayin. Alal misali, mafi, žasa, ba daidai da wani lamba ba. An saita shi a filin daban don gardama. Bugu da ƙari, za a iya ƙila zaɓuɓɓun ƙaura a matsayin shawara na zaɓi. Haɗin yana kamar haka:
= GARANTI (lamba1; number2; ...; yanayin; [matsakaicin adadi])
MODA.ODN
Maganin MOD.AODN ya nuna a tantanin salula lambobin daga saita da ke faruwa sau da yawa. A cikin tsofaffin sutura na Excel, akwai aikin MODA, amma a wasu daga baya an raba shi zuwa biyu: MODA.ODN (na lambobi ɗaya) da MODANASK (don kayan aiki). Duk da haka, tsohuwar ɗaba'ar ta kasance a cikin ƙungiya mai raɗaɗi, wadda aka tattara abubuwa daga jerin su na gaba na shirin don tabbatar da daidaito da takardu.
= MODA.ODN (lambar1; number2; ...)
= MODAHNA (lamba1; number2; ...)
MEDIANA
MEDIANA mai aiki yana ƙayyade matsakaicin adadi a cikin kewayon lambobi. Wato, ba ya ƙaddamar da matsakaicin matsakaici ba, amma kawai matsakaicin adadi tsakanin mafi girma da kuma ƙaramin adadin dabi'u. Haɗin aikin shine:
= MEDIAN (lamba1; number2; ...)
STANDOWCLONE
Dabarar STANDOCLON da kuma MODA wani sashi ne na tsofaffin sifofin wannan shirin. Yanzu ana amfani da tallafin zamani na - STANDOCLON.V da STANDOCLON.G. Na farko daga cikinsu an tsara su don ƙididdige daidaitattun daidaitattun samfurin, kuma na biyu - yawan jama'a. Ana amfani da waɗannan ayyuka don lissafta daidaitattun daidaituwa. Haɗarsu ita ce kamar haka:
= STDEV.V (lambar1; number2; ...)
= STDEV.G (lamba1; number2; ...)
Darasi: Excel Standard Deviation Formula
Mafi Girma
Wannan afaretan yana nunawa a cikin cell da aka zaɓa lambar a cikin tsari a cikin tsari mai saukowa. Wato, idan muna da nauyin 12.97.89.65, kuma mun ƙayyade 3 a matsayin matsayi na matsayi, to, aikin a cikin tantanin halitta zai dawo na uku mafi girma. A wannan yanayin, shine 65. Bayanan sanarwa shine:
= LARGEST (tsararraki; k)
A wannan yanayin, k shine darajar ƙimar da yawa.
ƘARAR
Wannan aikin shine hoton madubi na bayanan da ya gabata. Har ila yau, gardama ta biyu ita ce lambar ƙira. A nan kawai a wannan yanayin, ana yin la'akari daga ƙananan. Haɗin aikin shine:
= KASHE (Tsarin; k)
RANG.SR
Wannan aikin yana da akasin aikin da ya gabata. A cikin ƙayyadaddun tantanin halitta, yana bada lamba na lamba ta lamba a samfurin ta yanayin, wanda aka ƙayyade a cikin gardama dabam. Wannan na iya zama a cikin hawan sama ko saukowa. An saita karshen ta asali idan filin yana "Dokar" bar blank ko sanya akwai lambar 0. Rubutun wannan magana shine kamar haka:
= RANK.SR (lambar; array; tsari)
A sama, kawai mafi mashahuri kuma ana buƙatar ayyukan aikin lissafi a Excel an bayyana. A gaskiya ma, suna da yawa sau da yawa. Duk da haka, ainihin ka'idodin ayyukansu shine kama: aiwatar da jigilar bayanai kuma ya dawo sakamakon sakamakon aiki zuwa ƙayyadaddun tantanin halitta.
