Umsebenzi we-trigonometric sine , njenge -cosine kanye ne -tangent , usekelwe kunxantathu elungile (inxantathu ene-angle elingana nama-degree angu-90) njengoba kuboniswe esithombeni ngenhla.
Esiklasini sesibalo, i-sine ye-angle itholakala ngokuhlukanisa ubude ohlangothini olubhekene ne-angle ngobude be-hypotenuse.
Esikhathini se-Excel, i-sine ye-angle ingatholakala ngokusebenzisa umsebenzi we-SIN uma nje lelo ngoma lilinganiswa kuma- radians .
Ukusebenzisa umsebenzi we-SIN kungakusiza isikhathi esiningi futhi mhlawumbe kunomsebenzi omkhulu wokukhanda ikhanda ngoba awusadingeki ukhumbule ukuthi yiliphi uhlangothi lendxantathu eliseduze ne-angle, okuphambene nalokho, futhi yikuphi okuyi-hypotenuse.
01 ngo-02
Ama-Degrees vs. Radians
Ukusebenzisa umsebenzi we-SIN ukuthola i-sine ye-angle kungase kube lula kunokukwenza ngesandla, kepha njengoba kubonisiwe, kubalulekile ukuqaphela ukuthi uma usebenzisa umsebenzi we-SIN, i-engela idinga ukuthi ibe ngama-radians kunama-degree iningi lethu iningi lingazi.
AmaRussia ahlobene nengqikithi yombuthano ngenye ye-radian esilingana nokulingana nama-57 degrees.
Ukuze wenze kube lula ukusebenza neminye imisebenzi ye-SIN kanye ne-Excel, sebenzisa umsebenzi we-RADIANS we-Excel ukuguqula i-angeli ukuthi ilinganiswe ukusuka kumadireyi kuya kuma-radians njengoba kuboniswe esitokisini B2 esithombeni ngenhla lapho i-angle yama-degrees angu-30 iguqulwa ibe yi-radians engu-0.523598776.
Okunye okukhethwa kukho ukuguqula kusuka kumadiresi kuya kuma-radians kufaka:
- Ukwenza umsebenzi we-RADIANS ngaphakathi komsebenzi we-SIN - njengoba kuboniswe kulayini 3 kusibonelo.
- Ukusebenzisa umsebenzi we-PC we-Excel kufomula: i- angle (degrees) * PI () / 180 njengoba kuboniswe kulayini 4 kusibonelo.
02 ka 02
I-syntax ye-SIN yomsebenzi kanye neziphakamiso
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi , amabakaki, nokuphikisana .
I-syntax yomsebenzi we-SIN yile:
= ISIN (Inombolo)
Inombolo = i-angle ibalwa, kulinganiswa kuma-radians. Ubukhulu be-angle kuma-radians bungangeniswa kule mpikiswano noma ukubhekisela kweseli endaweni yile datha kushidi lokusebenza kungangena esikhundleni.
Isibonelo: Ukusebenzisa umsebenzi we-SIN we-Excel
Lesi sibonelo sihlanganisa izinyathelo ezisetshenziselwa ukungena umsebenzi we-SIN ku-cell C2 (njengoba kuboniswe esithombeni ngenhla) ukuthola i-angle ye-degree-30 degree noma ama-radians angu-0.523598776.
Izinketho zokufaka umsebenzi we-SIN zihlanganisa ukuthayipha ngesandla kuyo yonke imisebenzi = SIN (B2) , noma usebenzisa ibhokisi lengxoxo lomsebenzi, njengoba kuchazwe ngezansi.
Ukufaka umsebenzi we-SIN
- Chofoza kuseli C2 kushidi lokusebenzela ukwenza kube iseli elisebenzayo .
- Chofoza kuthebhu yefomula yemenyu ye- ribbon .
- Khetha i- Math & Trig kusuka kubhoni ukuze uvule uhlu lwehla lokusebenza.
- Chofoza ku- SIN kuhlu ukuze ukhulise ibhokisi lengxoxo lomsebenzi.
- Ebhokisini lengxoxo, chofoza kulayini lombhalo.
- Chofoza kuseli B2 kushidi lokufaka ukuze ufake lelo referensi yeseli kufomula.
- Chofoza u- Kulungile ukuqedela ifomu bese ubuyela ekhasini lokusebenzela.
- Impendulo 0.5 kufanele ivele esitokisini C2 - okuyi-sine ye-angle engama-30 degree.
- Uma uchofoza ku-cell C2 umsebenzi ophelele = I-SIN (B2) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela.
#VALUE! Amaphutha kanye Nemiphumela Yelikhanda Elibukhali
- Umsebenzi we-SIN ubonisa i- #VALUE! iphutha uma ireferensi esetshenziselwa ukuphikisana komsebenzi ikhomba iseli eliqukethe idatha yombhalo omfushane wesibonelo esisihlanu lapho isethenjwa selesithenjwa esisetshenzisiwe sikhombise ilebula yombhalo: i- Angle (amaRudiya) .
- Uma iseli likhomba esitokisini esingenalutho, umsebenzi ubuyisela inani le-zero njengoba kuboniswe emgqeni wesithupha ngaphezulu. Imisebenzi ye-Excel ye-trig ihumusha amangqamuzana angenalutho njenge-zero, kanti i-sine yama-radians yelanga ilingana no-zero.
Ukusetshenziswa kwe-Trigonometric ku-Excel
I-Trigonometry igxile ebuhlotsheni phakathi kwezinhlangothi nezinhlangothi zontathu, futhi nakuba abaningi bethu kungadingeki bayisebenzise nsuku zonke, i-trigonometry inezinhlelo zokusebenza ezinkambu eziningi ezibandakanya izakhiwo, i-physics, ubunjiniyela, nokuhlola.
Abacwaningi, isibonelo sebenzisa i-trigonometry ngezibalo ezibandakanya ukushisa kwelanga, umthwalo wesakhiwo, kanye nemithambeka yephahla.