Yadda ake yin lissafin daidaitawar canjin

Ofaya daga cikin manyan alamun ƙididdiga na jerin lambobin sune cikakken inganci. Don nemo yana da matukar rikitarwa. Kayan aikin kayan aikin Microsoft Excel damar ba ku damar sauƙaƙe su a cikin mai amfani.

Lissafta na rashin ingancin bambancin

Wannan mai nuna alama shine rabo na daidaitaccen daidaituwa ga ilimin lissafi. Sakamakon da aka samo ya bayyana a matsayin kashi.

Excel ba ya bambanta ayyuka don yin lissafin wannan mai nuna alama, amma akwai dabaru don lissafin daidaitattun lambobi, wato ana amfani dasu don samun ingantacciyar bambancin.

Mataki na 1: Lissafin daidaitaccen karkacewa

Daidaitacce, ko, kamar yadda ake kira daban, daidaitaccen karkatarwa shine tushen murabba'i daga watsawa. Don yin lissafin daidaitattun karkacewa, ana amfani da aikin tsayãwa. Farawa tare da sigar Excel 2010, an rarrabu, ya danganta da tsarin babban janar an lissafta shi ko ta samfurin, zaɓuɓɓuka biyu: tsayewa daban-daban: tsayewa daban-daban: Standotcclone.G da tsayewa.

Da syntax na waɗannan ayyuka suna daidai da haka:

= Tsakiyar Stoma (Lambar1; lamba2; ...)

= Tsayewa.g (lamba1; lamba2; ...)

= Tsakiyar (Number1; Lambar2; ...)

1. Domin yin lissafin daidaitattun daidaitattun karkara, zaɓi kowane sel mai kyauta a kan takardar, wanda ya dace da ku don nuna sakamakon lissafin. Latsa maɓallin "Manna aiki". Yana da bayyanar hoto kuma yana kan hagu na hanyar kirtani.



2. An yi kunna maye na maye na ayyuka, wanda aka fara azaman taga daban tare da jerin muhawara. Je zuwa rukunin "ƙididdiga" ko "cikakken jerin haruffa". Mun zabi sunan "tsaya.g" ko "Dokeotccccccccccccccccccccccccccccclona.V Latsa maɓallin "Ok".



3. Batun muhawara ta buɗe. Zai iya samun daga fannoni 1 zuwa 255, wanda akwai takamaiman lambobi da nassoshi zuwa sel ko jere. Mun sanya siginan kwamfuta a filin "lamba". Mouse ware kewayon dabi'un da za a sarrafa a kan takardar. Idan akwai irin waɗannan wuraren kuma ba sa kusa da juna, masu tsara waɗannan suna nuna filin "lambar", da sauransu. Lokacin da aka shigar da duk bayanan da suka zama dole, danna maɓallin "Ok"



4. A cikin pre-zaɓaɓɓen sel, jimlar lissafin da aka zaɓa da aka zaɓa ya nuna.

Darasi: Tsakanin Quadratic karkacewa a Excel

Mataki na 2: Lissafin matsakaicin lissafi

Matsakaicin lissafi matsakaita shine rabo na jimlar dukkanin dabi'un da yawa na jerin sunayen. Don lissafa wannan mai nuna alama, akwai kuma wani aiki daban - CPnph. Lissafta darajar ta akan takamaiman misali.

1. Selectel a kan takardar don fitarwa sakamakon. Muna danna maɓallin "Saka Aikin" Better Strike ya riga ya saba da mu.



2. A cikin nau'in ƙididdiga na maye na Wizard na ayyuka, muna neman sunan "srnvov". Bayan an zaɓi, danna maɓallin "Ok".



3. An ƙaddamar da taga. Muhawara gaba daya daidai ne ga cewa masu aiki kungiyar kungiyar. Wato, a cikin ingancin su na iya yin aiki kamar yadda lambobi daban da hanyoyin haɗin yanar gizo. Shigar da siginan kwamfuta a filin "lamba". Hakanan, kamar yadda a cikin lamarin da ya gabata, muna ware sahun sel a kan takardar. Bayan an jera su a cikin taga taga. Danna maɓallin "Ok".



4. Sakamakon lissafin matsakaiciyar lissafi an samo shi ne a cikin tantanin halitta wanda aka fi dacewa kafin buɗe wa maye maye.

Darasi: Yadda ake lissafta matsakaicin darajar a Fim

Mataki na 3: Gano madaidaicin bambancin

Yanzu muna da duk bayanan da suka zama dole don yin lissafin daidaitaccen bambancin kansa.

1. Selectel a cikin abin da za'a nuna sakamakon. Da farko dai, ya zama dole a yi la'akari da cewa madaidaicin madaidaicin shine kashi. A wannan batun, yakamata a canza tsarin sel zuwa wanda ya dace. Ana iya yin wannan bayan zaɓin sa, yayin da cikin "gida" shafin. Danna filin da aka tsara akan kintinkiri a cikin "lambar" kayan aiki. Daga jerin zaɓuɓɓuka na zaɓuɓɓuka, zaɓi "kashi". Bayan waɗannan ayyukan, tsarin a kan embiyar zai dace.



2. Dawowa zuwa tantanin halitta ya nuna sakamakon. Kunna shi tare da danna sau biyu na maɓallin linzamin kwamfuta na hagu. Mun sanya alamar "=". Zaɓi abu wanda sakamakon shine sakamakon lissafin daidaitattun daidaitawa. Latsa maɓallin "Ragewa" (/) akan keyboard. Bayan haka, za mu ware tantanin halitta wanda aka tsara shi a ilmin lissafi na al'adun lissafi ya sa lamba jerin is located. Don yin lissafin da fitarwa, danna maɓallin ENS Entest akan keyboard.



3. Kamar yadda kake gani, ana nuna sakamakon lissafin.

Don haka, mun lasafta tsarin bambancin, yana nufin sel da aka riga aka ƙididdige matsakaiciyar lissafi. Amma zaku iya ci gaba da ɗan bambanta, ba tare da lissafin waɗannan dabi'u ba.

1. Select da kwalin da aka tsara a ƙarƙashin tsarin da aka tsara wanda sakamakon zai samo asali. Mun rubuta wa wani nau'in tsari a ciki:

   = Tsayewa.v (fage_name) / sr nufin (fers_name)

   Maimakon sunan "kewayon kewayon" saka ainihin daidaitawar yankin, wanda aka sanya jerin sunayen da yawa. Za'a iya yin wannan ta hanyar saƙa wannan kewayon. Madadin mai aiki da tsayaki. A, idan mai amfani ya dauki ya zama dole, ana iya amfani da aikin daidaitaccen aikin.



2. Bayan haka, don ƙididdige ƙimar kuma nuna sakamakon akan allo mai kula, danna maɓallin Shigar.

Akwai bambanci na sharadi. An yi imani da cewa idan mai nuna alamar bambancin ƙasa ƙasa da 33%, to, saitunan lambobi suna kama da juna. A gaban batun, al'ada ce a rarrabe a matsayin mai heterogeneous.

Kamar yadda kake gani, kyakkyawan shirin yana ba ka damar sauƙaƙe lissafin irin wannan tsarin ƙididdigar ƙididdigar ƙididdigar na azaman bincika ƙarancin bambancin. Abin takaici, Rataye ba tukuna ke wanzu a aikin da zai lissafta wannan mai nuna alama a mataki guda, amma tare da taimakon daidaitattun ayyukan masu-iko, wannan aikin yana da sauƙin aiki. Don haka, a Excel, har ma wanda ba shi da babban matakin ilimin da ke da alaƙa da tsarin ƙididdiga za'a iya aiwatarwa.