Izvo zvinonzi trigonometric function sine , kufanana ne cosine uye tangent , inobva pakateteteredzwa yakarurama (katatu ine ine angle yakaenzana ne 90 degrees) sezvinoratidzwa mumufananidzo uri pamusoro.
Mumatunhu ekirasi, sine yekona inowanikwa nekuparadzanisa kureba kwerutivi rwakatarisana nekona nehurefu hwehuwandu.
MuExcel, sine yekona inogona kuwanikwa kushandiswa kweSIN inoshanda chero yakareba iyo iyo ngero inotaridzwa mumayera .
Kushandisa SIN basa kunogona kukuchengetedza nguva yakawanda uye zvichida kuwanda kwekucheka musoro sezvo iwe usisatombofaniri kuyeuka kuti rutivi runei runyararo ruri pedo nekona, iyo inopesana, uye iyo inofungidzira.
01 ye 02
Degrees vs. Radians
Kushandisa SIN basa kuti uwane sine yekona ingava nyore kupfuura kuzviita, asi, sezvakataurwa, zvakakosha kuona kuti kana uchishandisa SIN basa, ingiro inofanirwa kunge iri mumasara panzvimbo pe - madigiri chikwata chedu vazhinji havazive.
VaRadio vanowirirana nezera redu denderedzwa nerimwe radian riri rinenge rakaenzana ne 57 degrees.
Kuita kuti zvive nyore kushanda pamwe neSIN neExcel mamwe mabasa akadai, shandisa basa reRALANS reEcelcel kuti uchinje ma angle ari kuyerwa kubva kumadigiri kusvika kuma radians sezvinoratidzwa muchitokisi B2 mumufananidzo uri pamusoro apa iyo yakaenzana yegrigiri 30 inoshandurwa kuva 0.523598776 radians.
Zvimwe zvingasarudzwa zvekushandura kubva kumadiresi kusvika kuma radians zvinosanganisira:
- Kunyorera basa reRADIANS mukati meSIN function - sezvinoratidzwa mumutsara wechitatu mumuenzaniso.
- Kushandisa Excel PI inoshanda mumutsetse: angle (digrii) * PI () / 180 sezvinoratidzwa mumutsara wechina mumuenzaniso.
02 of 02
Syntax yeSIN Function uye Arguments
Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa , mabheji, uye nharo .
Izwi rechirevo cheSIN rinoshanda:
= SIN (Nhamba)
Nhamba = iyo yakaenzana yakaverengwa, inoyerwa mumayera. Ukuru hwema angle mu radians kunogona kupindirwa nekuda kwechikonzero ichi kana sero rinotarisa kune nzvimbo yedata iri mubhuku rinogona kuiswa panzvimbo.
Muenzaniso: Kushandisa SIN Basa reSIN
Muenzaniso uyu unobatanidza matanho anoshandiswa kupinda muSIN inoshanda muchitokisi C2 (sezvinoratidzwa mumufananidzo uri pamusoro) kuwana sine ye 30-degree angle kana 0.523598776 radians.
Sarudzo yekupinda muSIN basa inosanganisira kuverenga manyore mubasa rose = SIN (B2) , kana kushandisa sarudzo yebasa, sezvinotsanangurwa pasi apa.
Kupinda muSIN Function
- Dzvanya pachitokisi C2 mune pepa rekushanda kuti uite sero rinoshanda .
- Dzvanya paMafomu yebhu yebhoni yebhoni .
- Sarudza Math & Trig kubva kubhoni kuti uzarure basa rakaderera pasi.
- Dzvanya paSIN muzorongwa kuti ubudise bhokisi rebasa rebasa.
- Mubhokisi rebhokisi, tora paNhamba yemurongo.
- Dzvanya pachitokisi B2 mune pepa rekushanda kuti uise iyo seferensi iri mumutsetse.
- Dzvanya OK kuti upedze rondedzero uye dzokera kubasa rekushanda.
- Mhinduro 0.5 inofanira kuonekwa muchitokisi C2 - iyo inonzi sine ye 30-degree angle.
- Paunenge uchinyora pachitsime C2 yakakwana basa = SIN (B2) inowanikwa mubhairi yepamusoro pane pepa pepaji.
#VALUE! Zvikanganiso uye Mucheka Asina Kubatsira
- IIN Sinoshanda inoratidza #VALUE! kukanganisa kana shanduro inoshandiswa senyaya yebasa inongedzera kune imwe sero rine text data row mishanu yemuenzaniso apo sero rinoshandiswa rinoshandiswa rinotarisa kumashoko okuti: Angle (Radians) .
- Kana sero rinotaurira kusero risina chinhu, basa rinodzorera kukosha kwe zero sezvaratidzwa munharaunda yepamusoro yechitanhatu. Basa reCexcel rinoshandura kushandura pasina masero se zero, uye sine ye zero radians yakaenzana ne zero.
Trigonometric Uses mu Excel
Trigonometry inotarisa kuhukama pakati pemakona nemakona emakatatu, uye nepo vazhinji vedu tisingafaniri kuishandisa zuva rega rega, trigonometry ine maitiro mune zvimwe zvinhu zvakasanganisira mashizha, physics, engineering, nekuongorora.
Architects, somuenzaniso shandisa trigonometry kuti zviverengwe zvinosanganisira zuva shading, chimiro chetsika, uye, pamusoro pematenga.