Amincewa da tsaka-tsaki a Foreved

Ofaya daga cikin hanyoyin don warware matsalolin ilimin ƙididdiga shine lissafin ƙarfin ƙarfin gwiwa. Ana amfani dashi azaman madadin madadin zuwa kimanta ma'ana tare da karamin samfuri. Ya kamata a lura cewa tsari na yin lissafin ƙarfin ƙarfin gwiwa shine rikitarwa. Amma kayan aikin na Excelincepast shirin ba ka damar sauƙaƙe shi. Bari mu gano yadda ake yi a aikace.

Hanyar 2: Sigar Abokin Ciniki.

Bugu da kari, akwai wani fasalin da yake da alaƙa da lissafin kwarin gwiwa - dogara. Ya bayyana, kawai farawa ne da Excel 2010. Wannan mai aiki yana yin lissafin tazarar jama'a ta amfani da rarraba ɗalibi. Ya dace sosai don amfani lokacin da watsawa kuma, saboda haka, ba a san daidaituwar karkacewa ba. SynTax na mai aiki shine:

= Amincewa da tushe (Alfa; Standard_otchal; Girma)

Kamar yadda muke gani, sunayen masu aiki kuma a wannan yanayin ba a canzawa.

Bari mu ga yadda za a lissafta iyakokin ƙarfin gwiwa tare da daidaitaccen daidaitaccen tsari game da misalin wannan hanyar da muka yi la'akari da shi. Matsayin kwarin gwiwa, kamar yadda na ƙarshe, ɗauki 97%.

1. Muna haskaka tantanin halitta wanda za a yi lissafin. Yumbu kan "saka aiki" button.



2. A cikin aikin aiki na ayyukan, je zuwa rukuni "ƙididdiga". Zaɓi sunan "amana" Dalibi ". Yumbu a kan "Ok" maballin.



3. An ƙaddamar da muhawara ta muhawara ta musamman.

   A cikin Alfa filin, wanda aka ba cewa matakin amincewa shine kashi 97%, yin rikodin lamba 0.03. A karo na biyu kan ka'idodin lissafin wannan siga ba zai tsaya ba.

   Bayan haka, saita siginan kwamfuta a cikin "daidaitaccen karkacewa" filin. Wannan lokacin da wannan mai nuna alama ba a san shi ba kuma ana buƙatar ta lissafta shi. Ana yin wannan ta amfani da aiki na musamman - Standotclone. Don kiran taga wannan ma'aikacin, danna kan alwatika zuwa hagu na kirtani na dabara. Idan baku sami sunan da ake so a cikin jerin da ke buɗe ba, to sai ku shiga cikin "ayyukan da ...".



4. Jagora na Ayyuka ya fara. Mun koma zuwa rukunin "ƙididdiga" da rubutu a ciki sunan "tsaya.pccccclona.b". Sannan yumbu a kan "Ok" maballin.



5. Tagan taga yana buɗe. Aikin daidaitaccen aiki. Shine ma'anar daidaitattun daidaitawa yayin samfurin. Syntax ta yi kama da wannan:

   = Tsakiyar (Number1; Lambar2; ...)

   Abu ne mai sauki ka yi tsammani cewa "lambar" gardamar ce adireshin samfurin samfurin. Idan an sanya samfurin a cikin tsararru guda, to, zaku iya, yin amfani da hujja guda ɗaya, ba da hanyar haɗi zuwa wannan kewayon.

   Shigar da siginan kwamfuta a filin "lamba" kuma, kamar yadda koyaushe, riƙe maɓallin linzamin kwamfuta na hagu, muna ware saiti. Bayan daidaitawa ya afka filin, kada ku yi sauri ka latsa maɓallin "Ok", saboda haka ba daidai ba ne. Tsohon, muna buƙatar komawa zuwa Grogs ɗin da ke aiki da kayan aiki. Dalibin ya yi muhawara ta ƙarshe. A saboda wannan, danna sunan da ya dace a cikin tsari.



6. Ana sake maye gurbin taga sake. Shigar da siginan kwamfuta a filin "Girma". Kuma, danna kan alwatika ya riga ya fi saninmu mu je zabin masu aiki. Kamar yadda kuka fahimta, muna buƙatar sunan "Asusun". Tunda mun yi amfani da wannan fasalin lokacin da aka lissafta a cikin hanyar da ta gabata, yana yanzu a cikin wannan jeri, don haka danna kan shi. Idan baku gano shi ba, to ku aikata gwargwadon algorithm wanda aka bayyana a farkon hanyar.



7. Bayan bugun da taga muhawara, mun sanya siginan kwamfuta a filin "lamba" da kuma tare da kuma tare da claming maɓallin linzamin kwamfuta, muna haskaka saiti. Sannan yumbu a kan "Ok" maballin.



8. Bayan haka, shirin yana sanya ƙididdigar kuma yana nuna ƙimar ƙarfin gwiwa.



9. Don sanin iyakokin, za mu sake buƙatar ƙididdige ƙimar samfurin. Amma, aka ba da gaskiyar cewa lissafin algorithm tare da taimakon Tsarin daidai yake da a cikin ta baya, har ma sakamakon bai canza ba, ba za mu dakatar da daki-daki a karo na biyu ba.



10. Bayan ƙirƙirar sakamakon lissafin Srvnah da amana. Mai gano, muna samun iyakar ƙarfin ƙarfin gwiwa.



11. Mai danganta da sakamakon lissafin, sakamakon lissafin da aka amince da shi. An gano, iyakar hagu na kwarin gwiwa.



12. Idan lissafin shine a rubuta tare da tsari ɗaya, to lissafin iyakar ya dace a shari'ar mu zai yi kama da wannan:

    = Srnavov (B2: B13) + Amincewa



13. Dangane da tsari na yin lissafin iyakar hagu zai yi kama da wannan:

    = Srnavov (B2: B13) - Mahimmanci (0.03; Standotclonal.v (B2); Asusun (B2: B13)

Kamar yadda kake gani, kayan aikin Excel zai iya sauƙaƙe lissafin yawan ƙarfin gwiwa da iyakokinta. Don waɗannan dalilai, ana amfani da masu aiki na mutum don samfurori, wanda aka san watsawa da ba a sani ba.