Umsebenzi we-trigonometric, njenge -cosine kunye ne -tangent , isekelwe kunxantathu ene-right-triangle (inxantathu ene-angle elingana nama-90 degrees) njengoko kuboniswe kumfanekiso ongentla.
Kwiklasi yamatriki, i-sine ye-angle ifunyanwa ngokuhlula ubude becala elibhekiselele kwinqanaba elide nobude be-hypotenuse.
Kwi-Excel, i-sine ye-angle ifunyanwa isebenzisa umsebenzi we-SIN njengoko nje loo ngqungquthela ibalwa ngama- radians .
Ukusebenzisa umsebenzi we-SIN kunokukugcina ixesha elininzi kwaye mhlawumbi uninzi lwe-head-scratching njengoko ungasayi kuphinda ukhumbule ukuba luphi uhlangothi lwendxantathu olukufuphi kwinqanaba, elibhekiselele, kwaye liyi-hypotenuse.
01 ka 02
IziGanga kunye namaRadi
Ukusebenzisa umsebenzi we-SIN ukufumana i-sine ye-angle ingaba lula kunokuba uyenze ngesandla, kodwa, njengoko kubonisiwe, kubalulekile ukuqaphela ukuba xa usebenzisa umsebenzi we-SIN, i-angle ifuna ukuba kuma- radians kunezi-degrees inxalenye yethu ininzi ayifumene nayo.
AmaRidiya anxulumene nomda weesangqa kunye ne-radian esilingana nokulingana nama-57 degrees.
Ukwenza kube lula ukusebenza kunye ne-SIN kunye nezinye izinto ze- Excel, sebenzisa umsebenzi we-RADIANS we-Excel ukuguqula i-angle ekulinganiselwe ukusuka kwiiyure ukuya kuma-radians njengoko kuboniswe kwiseli B2 kumfanekiso ongentla apho i-angle ye-degrees ezingama-30 iguqulwa ibe ngu-0.523598776.
Ezinye iinketho zokuguqula ukusuka kwiiyure ukuya kuma-radians ziquka:
- Ukwenza umsebenzi we-RADIANS ngaphakathi komsebenzi we-SIN - njengoko kuboniswe kumgca 3 kumzekelo.
- Ukusebenzisa umsebenzi we-Excel we- PI kwifom ye-formula: i- angle (degrees) * PI () / 180 njengoko kuboniswe kumgca 4 kumzekelo.
02 we 02
I-Syntax yeeNkqubo kunye neArguments
I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi , amabakethi kunye neengxabano .
I-syntax yomsebenzi we-SIN yi:
= ISIN (Inombolo)
Inombolo = i-angle ibalwa, ilinganiswe kuma-radians. Ubungakanani bekota kuma-radians zingangeniswa kule ngxabano okanye isalathisi yeseli kwindawo yendawo kule fom yokusebenzela ingafakwa endaweni yoko.
Umzekelo: Ukusebenzisa umsebenzi we-Excel ye-SIN
Lo mzekelo uphawula amanyathelo asetyenziswa ukufaka umsebenzi we-SIN kwiseli C2 (njengoko kuboniswe kumfanekiso ongentla) ukufumana i-sine ye-angle-degree engama-30 okanye i-radius 0.523598776.
Okukhethwa kukho ukungena kumsebenzi we-SIN kubandakanya ukuthayipha ngesandla kuyo yonke imisebenzi = ISIN (B2) , okanye usebenzisa ibhokisi yencoko yencoko yomsebenzi, njengoko kuchazwe ngezantsi.
Ukufaka iSIN Umsebenzi
- Cofa kwiseli C2 kwiphepha lokusebenzela ukuze wenze iseli esebenzayo .
- Cofa kwiTrafom ithebhu yemenyu yebhondi .
- Khetha i- Math & Trig kwi-ribbon ukuvula uluhlu lwehla lokuhla.
- Cofa kwi- SIN kuloluhlu ukukhupha ibhokisi yencoko yencoko yomsebenzi.
- Kwibhokisi yencoko, nqakraza kumgca weNombolo .
- Cofa kwifowuni B2 kwiphepha lokusebenzela ukuze ufake leyo fom yefomula kwifom.
- Cofa u- OK ugcwalise ifomu uze ubuyele kwiphepha lokusebenzela.
- Impendulo ye-0.5 kufuneka ibonakale kwiselfowuni C2 - yintoni isine ye-angle-degree.
- Xa ucofa kwiseli C2 umsebenzi opheleleyo = ISIN (B2) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela.
#VALUE! Iimpazamo kunye neziphumo zeeMbewu ezingenanto
- Umsebenzi we-SIN ubonisa i- #VALUE! Impazamo xa isalathiso esetyenziswe njengengxoxo yomsebenzi ibonisa iseli elineenkcukacha zedata yecatshulwa emithathu umzekelo apho isalathisi esetyenzisiweyo isetyenziswe kwibhile yombhalo: I- Angle (Radians) .
- Ukuba iseli likhomba kwisitenki esingenalutho, umsebenzi ubuyisela ixabiso le-zero njengoko kuboniswe kumqolo wesithandathu ngentla. Imisebenzi ye-Excel ye-trig isichaza iifenki ezingenanto njenge-zero, kwaye i-sine ye-radios i-zero ilingana ne-zero.
Ukusetyenziswa kweTrigonometric kwi-Excel
I-Trigonometry igxininisa ubudlelwane phakathi kwamacandelo kunye neengcangca zontathutathu, kwaye ngelixa abaninzi bethu abayidingi ukuyisebenzisa imihla ngemihla, i-trigonometry inezicelo kwiinkalo ezininzi ezibandakanya izakhiwo, i-physics, ubunjineli kunye nokuhlola.
Abacwangcisi, umzekelo sebenzisa i-trigonometry ngokubala okubandakanya umthunzi welanga, umthwalo wendawo, kunye neentaba.