Ayyukan kwakwalwa, kamar cosine da tangent , suna dogara ne a kan alƙalan hagu-angled (wani ɓangaren triangle mai dauke da kusurwa daidai da digiri 90) kamar yadda aka nuna a cikin hoto a sama.
A cikin lissafin lissafi, ana samun sine na kusurwa ta hanyar rarraba tsawon gefen gefe da kusurwa ta tsawon tsayin hypotenuse.
A cikin Excel, ana iya samun sine na kusurwa ta amfani da aikin SIN muddin ana auna wannan kusurwa a cikin radians .
Yin amfani da aikin SIN zai iya ceton ku lokaci mai yawa da kuma yiwuwar mai girma da yawa tun lokacin da ba ku da abin tunawa da wane ɓangaren triangle yana kusa da kusurwar, wanda ke da akasin, kuma wane ne hypotenuse.
01 na 02
Digiri da Radians
Yin amfani da aikin SIN don neman sakin kwana zai iya zama sauki fiye da yin shi da hannu, amma, kamar yadda aka ambata, yana da mahimmanci a gane cewa lokacin amfani da aikin SIN, buƙatar ya kamata a kasance a cikin radians maimakon - digiri wanda shine ɗayanmu ba mu san ba.
Radians suna da dangantaka da radius na da'irar tare da radian daya kamar daidai da digiri 57.
Don yin sauki a aiki tare da ayyukan SIN da Excel na sauran nau'o'in, sai ku yi amfani da ayyukan RADIANS na Excel don juyawa da kusurwar da aka auna daga digiri zuwa radians kamar yadda aka nuna a cikin b2 B2 a cikin hoton da ke sama inda inda kwana 30 ke juyawa zuwa 0.523598776 radians.
Wasu zaɓuɓɓukan don canzawa daga digiri zuwa radians sun haɗa da:
- Nesting ayyukan RADIANS cikin aikin SIN - kamar yadda aka nuna a jere 3 a misali.
- Yin amfani da aikin PI na Excel a cikin tsari: kwana (digiri) * PI () / 180 kamar yadda aka nuna a jere 4 a misali.
02 na 02
Ƙungiyar SIN Function da Arguments
Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, da muhawara .
Haɗin aikin aikin SIN shine:
= SIN (Lambar)
Lambar = An ƙidaya kwana, an auna shi a cikin masu radians. Za'a iya shigar da girman girman ɗakunan a cikin masu ra'ayin gaskanci don wannan hujja ko kuma tantance tantanin halitta zuwa wuri na wannan bayanan a cikin takardar aiki za a iya shiga a maimakon.
Misali: Yin amfani da aikin SAS na Excel
Wannan misali yana rufe matakan da ake amfani dashi don shigar da aikin SIN cikin cell C2 (kamar yadda aka nuna a cikin hoton da ke sama) don samun sine na kuskure 30-digiri ko 0.523598776 radians.
Zaɓuɓɓuka don shigar da aikin SIN sun haɗa da hannu da rubutu a cikin aikin duka = SIN (B2) , ko yin amfani da akwatin maganganun , kamar yadda aka tsara a kasa.
Shigar da aikin SIN
- Danna maɓallin C2 a cikin takardun aiki don sa shi tantanin halitta mai aiki .
- Danna maɓallin Formulas na shafin rubutun .
- Zabi Math & Trig daga ribbon don buɗe jerin aikin da aka sauke.
- Danna SIN a cikin jerin don kawo akwatin maganganu na aikin.
- A cikin akwatin maganganu, danna kan Lambar .
- Danna sel B2 a cikin takardun aiki don shigar da wannan tantanin halitta a cikin tsari.
- Danna Ya yi don kammala tsarin da komawa zuwa aikin aiki.
- Amsar ya kamata ya bayyana a C2 cell - wanda shine sine na kwana 30-digiri.
- Idan ka danna kan tantanin halitta C2 cikakkiyar aikin = SIN (B2) ya bayyana a cikin maɓallin tsari a sama da takardun aiki.
#VALUE! Kurakurai da Sakamakon Sakamakon Blank
- Ayyukan SIN na nuna #VALUE! kuskure idan tunani da aka yi amfani dashi azaman jigidar aikin yana nuna wani kwayar halitta dauke da rubutun kalmomin rubutu biyar na misalin inda inda kalmar salula ta yi amfani da kalmomi zuwa lakabin rubutu: Angle (Radians) .
- Idan tantanin halitta yana nunawa ga maras komai, aikin zai dawo da darajar sifilin da aka nuna a jere na shida a sama. Ayyukan Excel na trigon fassara fassarar kwayoyin halitta kamar sifili, kuma sine na masu zane-zane ba daidai ba ne.
Mahimmanci yana amfani da shi a Excel
Tantance na al'ada yana mayar da hankali akan dangantakar tsakanin bangarori da kusurwar magungunan, kuma yayin da yawancin mu bazai buƙaci amfani dasu a kullum, tasirin na da aikace-aikace a wasu fannoni ciki har da gine-gine, fasaha, aikin injiniya, da kuma binciken.
Gidajen tarihi, misali suyi amfani da fassarar lissafi don lissafi da suka shafi shading, kayan aiki, da kuma rufin rufin.