Kugwiritsa ntchito ArcTangent mu Microsoft Excel

Pin
Send
Share
Send

Arc tangent imaphatikizidwa ndi mndandanda wa mitundu yosiyanasiyana ya trigonometric. Ndilo mbali yakumanzere. Monga kuchuluka konseku, amawerengedwa mu radians. Excel ili ndi ntchito yapadera yomwe imakulolani kuwerengera arc tangent ya nambala yomwe mwapatsidwa. Tiyeni tiwone momwe angagwiritsire ntchito opareta iyi.

Kuwerengera kwa kufunika kwa arctangent

Arc tangent ndi mawu oyambira. Amawerengeredwa ngati ngodya yama radians omwe tangent yake imakhala yolingana ndi chiwerengero cha kutsutsana kwa arc tangent.

Kuwerengera mtengo wake, Excel imagwiritsa ntchito wolandira ATANyomwe ndi gawo la gulu la ntchito zamasamu. Nkhani yake yokhayo ndi nambala kapena cholozera cha foni chomwe chili ndi mawu owerengera. Syntax amatenga mawonekedwe otsatirawa:

= ATAN (chiwerengero)

Njira 1: Kulowera Mwantchito

Kwa wogwiritsa ntchito waluso, chifukwa cha kuphweka kwa kaphatikizidwe kameneka, nkosavuta komanso mwachangu kuyilowetsa.

  1. Sankhani selo yomwe mawerengeredwe amayenera kupezeka, ndipo lembani mtundu wa mtunduwo:

    = ATAN (chiwerengero)

    M'malo mokangana "Chiwerengero", pamenepo, timasinthira kuchuluka kwa manambala. Chifukwa chake arctangent anayi adzawerengeredwa ndi njira zotsatirazi:

    = ATAN (4)

    Ngati mtengo wamanambala uli mu khungu linalake, ndiye kuti adilesiyo ikhoza kukhala mfundo yotsimikizira ntchitoyo.

  2. Kuti muwonetse zowerengera pazenera, dinani batani Lowani.

Njira yachiwiri: Werengani Kugwiritsa Ntchito Wizard Yogwira Ntchito

Koma kwa ogwiritsa ntchito omwe sanazindikire bwino momwe mungagwiritsire ntchito mafomula kapena omwe amakonda; Ogwira Ntchito.

  1. Sankhani khungu kuti muwonetse zotsatira zakusintha kwa deta. Dinani batani "Ikani ntchito"atayikidwa kumanzere kwa barula yamu formula.
  2. Kutseguka kumachitika Ogwira Ntchito. Gulu "Masamu" kapena "Mndandanda wathunthu wa zilembo" dzina liyenera kupezeka ATAN. Kuti mutsegule zenera zotsutsana, sankhani ndikudina batani "Zabwino".
  3. Pambuyo pochita izi, wothandizira wotsutsana ndi zenera amatsegula. Ili ndi gawo limodzi lokha - "Chiwerengero". Mmenemo, muyenera kuyika nambala yomwe arc yake imayenera kuwerengera. Pambuyo pake, dinani batani "Zabwino".

    Komanso, monga mkangano, mutha kugwiritsa ntchito ulalo wa foni yomwe nambala iyi ilipo. Pankhaniyi, ndikosavuta kuti musalumikizane pamanja, koma kuyika chikhazikitso mdera ndikungosankha pa pepala lomwe pali kufunika komwe kuli. Pambuyo pa izi, adilesi ya foni iyi iwonetsedwa pazenera la zotsutsana. Kenako, monga momwe adasinthira mtundu wangayo, dinani batani "Zabwino".

  4. Mukamaliza masitepewo molingana ndi algorithm yomwe ili pamwambapa, mtengo wa arc tangent mumawonekedwe a nambala omwe adayikidwa mu ntchito awonetsedwa mu foni yomwe idasankhidwa kale.

Phunziro: Ntchito Wizard ku Excel

Monga mukuwonera, kupeza kuchokera pa chiwerengero cha arctangent ku Excel si vuto. Izi zitha kuchitika pogwiritsa ntchito katswiri. ATAN ndi syntax yosavuta. Mutha kugwiritsa ntchito fomuloli mwina mwa kuwongolera pamanja kapena kudzera pa mawonekedwe Ogwira Ntchito.

Pin
Send
Share
Send