Arc tangent an haɗa shi cikin jerin maganganun rashin daidaituwa na magana. Wannan kishiyar tangent ne. Kamar kowane irin waɗannan adadi, ana lissafta shi a cikin radians. Excel yana da aiki na musamman wanda zai baka damar lissafin arc tangent na lambar da aka bayar. Bari mu ga yadda ake amfani da wannan mai aiki.
Lissafin darajar arctangent
Arc tangent magana ce ta tauhidi. An lasafta shi azaman kusurwa a cikin radians waɗanda tangent ɗin nata daidai yake da adadin huɗun arc tangent.
Don yin lissafin wannan darajar, Excel yana amfani da mai aiki ATANwanda shine bangare na ayyukan lissafi. Hujjar sa kawai lamba ce ko nuni ga tantanin halitta wanda ya kunshi magana adadi. Ginin kalma yana ɗaukar wadannan hanyar:
= ATAN (lamba)
Hanyar 1: Shigarwa kayan aikin hannu
Don ƙwararre mai ƙwarewa, saboda sauƙi na daidaitawar wannan aikin, ya fi sauƙi da sauri don shigar da shi da hannu.
- Zaɓi tantanin da yakamata a sami sakamako na lissafin, sannan a rubuta fom ɗin wannan nau'in:
= ATAN (lamba)Maimakon jayayya "Lambar", hakika, zamu musanya takamaiman darajar lamba. Don haka arctangent na hudu za'a lissafta shi ta dabarun mai zuwa:
= ATAN (4)Idan lambar ƙidaya tana cikin takamaiman sel, to adireshin aikin na iya zama hujja ga aikin.
- Don nuna sakamakon lissafin akan allon, danna maɓallin Shigar.
Hanyar 2: Lissafta Amfani da Mayen aikin
Amma ga waɗancan masu amfani waɗanda ba su da cikakkiyar masaniyar hanyoyin shigar da dabaru ko waɗanda suka saba da aiki tare da su ta hanyar keɓaɓɓiyar ma'ana, ƙididdigar ta amfani da Wizards na Aiki.
- Zaɓi waya don nuna sakamakon sarrafa bayanai. Latsa maballin "Saka aikin"an sanya shi a hagu na dabarar dabara.
- Budewa yana faruwa Wizards na Aiki. A cikin rukuni "Ilmin lissafi" ko "Cikakken jerin haruffa" ya kamata a samo suna ATAN. Don buɗe taga gardamar, zaɓi shi kuma danna maballin "Ok".
- Bayan aiwatar da waɗannan matakan, taga mai muhawara na window yana buɗewa. Tana da filin guda ɗaya kawai - "Lambar". A ciki, kuna buƙatar shigar da lambar wanda yakamata a lissafta baka. Bayan haka, danna maɓallin "Ok".
Hakanan, azaman hujja, zaku iya amfani da hanyar haɗi zuwa tantanin da acikin wannan lambar take. A wannan yanayin, ya fi sauƙi kar a shigar da masu gudanarwa da hannu, amma don sanya siginan kwamfuta a cikin filin filin kuma kawai zaɓi kan takardar da sashin abin da ƙimar da ake so ke ciki. Bayan waɗannan matakan, adireshin wannan tantanin zai nuna a cikin taga muhawara. To, kamar yadda yake a sigar da ta gabata, danna maballin "Ok".
- Bayan aiwatar da matakan bisa ga algorithm ɗin da ke sama, ƙimar arc tangent a radians na adadin da aka saita a cikin aikin za a nuna shi a cikin tantanin da aka tsara a baya.
Darasi: Wizard ɗin Aiki a cikin Excel
Kamar yadda kake gani, ganowa daga adadin alctangent a cikin Excel ba matsala. Za'a iya yin wannan ta amfani da ma'aikaci na musamman. ATAN tare da kyawawan sauki Syntax. Kuna iya amfani da wannan dabara ko ta hanyar shigarwar ko kuma ta hanyar dubawa Wizards na Aiki.
