Ntchito ya ATAN (arctangent) mu Excel

Arctangent ndi ntchito ya trigonometric inverse to tangent, yomwe imagwiritsidwa ntchito mu sayansi yeniyeni. Monga tikudziwira, ku Excel sitingathe kugwira ntchito ndi mapepala, komanso kupanga mawerengedwe - kuchokera ku zosavuta mpaka zovuta kwambiri. Tiyeni tiwone momwe pulogalamuyi ingawerengere arc tangent kuchokera pamtengo womwe wapatsidwa.

Timawerengera arc tangent

Excel ili ndi ntchito yapadera (yoyendetsa) yotchedwa "ATAN", zomwe zimakulolani kuti muwerenge arc tangent mu ma radians. Mawu ake onse amawoneka motere:

=ATAN(nambala)

Monga tikuonera, ntchitoyi ili ndi mkangano umodzi wokha. Mutha kugwiritsa ntchito m'njira zosiyanasiyana.

Njira 1: Kulowetsa fomula pamanja

Ogwiritsa ntchito ambiri omwe nthawi zambiri amawerengera masamu, kuphatikiza ma trigonometric, pamapeto pake amaloweza fomula ndikulowetsa pamanja. Umu ndi momwe zimachitikira:

1. Timadzuka mu cell momwe tikufuna kuwerengera. Kenako timalowetsa chilinganizo kuchokera ku kiyibodi, mmalo mwa mkangano timafotokozera mtengo weniweni. Musaiwale kuyika chizindikiro "chofanana" pamaso pa mawuwo. Mwachitsanzo, kwa ife, lolani “ATAN (4,5)”.
2. Fomula ikakonzeka, dinani Lowanikuti apeze zotsatira.

zolemba

1. M'malo mwa nambala, titha kutchula ulalo kuselo lina lomwe lili ndi nambala. Komanso, adilesi ikhoza kulowetsedwa pamanja, kapena kungodinanso pa cell yomwe mukufuna patebulo lokha.

Njirayi ndiyosavuta chifukwa itha kugwiritsidwa ntchito pamndandanda wa manambala. Mwachitsanzo, lowetsani fomula ya mtengo woyamba pamzere wofananira, kenako dinani Lowanikuti apeze zotsatira. Pambuyo pake, sunthani cholozera pakona yakumanja kwa selo ndi zotsatira zake, ndipo mtanda wakuda ukawonekera, gwirani batani lakumanzere la mbewa ndikukokera pansi ku selo lodzaza kwambiri.

Potulutsa batani la mbewa, timapeza kuwerengera kwa arc tangent pa data yonse yoyamba.

2. Komanso, m'malo molowa ntchito mu selo lokha, mukhoza kuchita mwachindunji mu bar formula - ingodinani mkati mwake kuti muyambe ndondomeko yokonzekera, pambuyo pake timalowetsa mawu ofunikira. Mukakonzeka, mwachizolowezi, dinani Lowani.

Njira 2: Gwiritsani Ntchito Wizard

Njirayi ndi yabwino chifukwa simuyenera kukumbukira kalikonse. Chinthu chachikulu ndikutha kugwiritsa ntchito wothandizira wapadera womangidwa mu pulogalamuyi.

1. Timadzuka mu cell yomwe mukufuna kupeza zotsatira. Kenako dinani chizindikirocho "Fx" (Insert Function) kumanzere kwa kapamwamba kapamwamba.
2. Iwindo lidzawonekera pazenera. Ntchito Wizards. Apa timasankha gulu “Mndandanda wa zilembo zonse” (kapena "Mathematics"), kuyendayenda pamndandanda wa ogwiritsa ntchito, chongani "ATAN", kenako panikizani OK.
3. Iwindo lidzawoneka lodzaza mkangano wa ntchito. Apa tikuwonetsa mtengo ndikusindikiza OK.Monga momwe zimakhalira polemba fomula, m'malo mwa nambala yeniyeni, tikhoza kufotokoza ulalo wa selo (timalowa pamanja kapena dinani patebulo lokha).
4. Timapeza zotsatira mu selo lomwe lili ndi ntchito.

Zindikirani:

Kuti mutembenuzire zotsatira zomwe zimapezeka mu radians kukhala madigiri, mutha kugwiritsa ntchito ntchitoyi "DEGREES". Kagwiritsidwe ntchito kake ndi kofanana ndi kagwiritsidwe ntchito kake "ATAN".

Kutsiliza

Chifukwa chake, mutha kupeza arc tangent ya nambala mu Excel pogwiritsa ntchito ntchito yapadera ya ATAN, mawonekedwe ake omwe amatha kulowetsedwa mwachangu mu cell yomwe mukufuna. Njira ina ndiyo kugwiritsa ntchito Wizard yapadera ya Function, pomwe sitiyenera kukumbukira fomula.