Contents
Arctangent aiki ne na trigonometric sabanin zuwa tangent, wanda ake amfani dashi a cikin ainihin kimiyyar. Kamar yadda muka sani, a cikin Excel ba za mu iya yin aiki kawai tare da maƙunsar bayanai ba, amma kuma yin lissafin - daga mafi sauƙi zuwa mafi rikitarwa. Bari mu ga yadda shirin zai iya ƙididdige tangent arc daga ƙimar da aka ba.
Muna lissafin tangent na arc
Excel yana da aiki na musamman (operator) da ake kira "ATAN", wanda ke ba ka damar karanta arc tangent a cikin radians. Gabaɗaya syntax ɗinta yayi kama da haka:
=ATAN(lamba)
Kamar yadda muke iya gani, aikin yana da hujja ɗaya kawai. Kuna iya amfani da shi ta hanyoyi daban-daban.
Hanyar 1: Shigar da dabarar da hannu
Yawancin masu amfani waɗanda galibi suna yin lissafin lissafi, gami da na trigonometric, a ƙarshe suna haddar dabarar aikin kuma su shigar da shi da hannu. Ga yadda ake yi:
- Mun tashi a cikin tantanin halitta wanda muke son yin lissafi. Sa'an nan kuma mu shigar da dabara daga madannai, maimakon gardama mun ƙayyade takamaiman ƙima. Kar a manta da sanya alamar "daidai" kafin magana. Alal misali, a cikin yanayinmu, bari ya kasance “ATAN (4,5)”.
- Lokacin da dabara ta shirya, danna Shigardon samun sakamako.
Notes
1. Maimakon lamba, zamu iya ƙayyade hanyar haɗi zuwa wani tantanin halitta mai ɗauke da ƙima. Bugu da ƙari, ana iya shigar da adireshin ko dai da hannu, ko kuma kawai danna kan tantanin halitta da ake so a cikin tebur kanta.
Wannan zaɓin ya fi dacewa saboda ana iya amfani da shi zuwa ginshiƙi na lambobi. Misali, shigar da dabara don ƙimar farko a layin da ya dace, sannan danna Shigardon samun sakamako. Bayan haka, matsar da siginan kwamfuta zuwa ƙananan kusurwar dama na tantanin halitta tare da sakamakon, kuma bayan giciye baƙar fata ya bayyana, riƙe maɓallin linzamin kwamfuta na hagu kuma ja ƙasa zuwa mafi ƙasƙanci cike tantanin halitta.
Ta hanyar sakin maɓallin linzamin kwamfuta, muna samun lissafin atomatik na tangent na baka don duk bayanan farko.
2. Har ila yau, maimakon shigar da aikin a cikin tantanin halitta kanta, zaka iya yin shi kai tsaye a cikin ma'auni - kawai danna ciki don fara yanayin gyarawa, bayan haka mun shigar da bayanin da ake bukata. Lokacin da aka shirya, kamar yadda aka saba, danna Shigar.
Hanyar 2: Yi amfani da Wizard Aiki
Wannan hanyar tana da kyau saboda ba kwa buƙatar tuna komai. Babban abu shine samun damar yin amfani da mataimaki na musamman da aka gina a cikin shirin.
- Mun tashi a cikin tantanin halitta wanda kuke son samun sakamakon. Sannan danna gunkin "Fx" (Saka Aiki) zuwa hagu na mashaya dabara.
- Taga zai bayyana akan allon. Mayukan Ayyuka. Anan mun zaɓi nau'i "Cikakken jerin haruffa" (ko "Mathematical"), gungurawa cikin jerin masu aiki, alama "ATAN", sannan latsa OK.
- Taga zai bayyana don cika hujjar aikin. Anan mun ƙayyade ƙimar lamba kuma latsa OK.Kamar shigar da dabara da hannu, maimakon takamaiman lamba, za mu iya ƙayyade hanyar haɗi zuwa tantanin halitta (muna shigar da shi da hannu ko danna kan shi a cikin tebur kanta).
- Muna samun sakamako a cikin tantanin halitta mai aiki.
Kamar shigar da dabara da hannu, maimakon takamaiman lamba, za mu iya ƙayyade hanyar haɗi zuwa tantanin halitta (muna shigar da shi da hannu ko danna kan shi a cikin tebur kanta).
lura:
Don canza sakamakon da aka samu a cikin radians zuwa digiri, zaku iya amfani da aikin "DEGREES". Amfaninsa yana kama da yadda ake amfani da shi "ATAN".
Kammalawa
Don haka, zaku iya samun arc tangent lamba a cikin Excel ta amfani da aikin ATAN na musamman, wanda za'a iya shigar da tsarin nan da nan da hannu a cikin tantanin halitta da ake so. Wata hanyar ita ce ta amfani da mayen Aiki na musamman, wanda a cikin wannan yanayin ba lallai ne mu tuna da dabarar ba.