Mahi ATAN (arctangent) i Excel

Ko te Arctangent he mahi pākoki ka huri ki te pātapa, e whakamahia ana i roto i nga mahi pūtaiao tika. E mohio ana tatou, i roto i te Excel e kore e taea e tatou anake te mahi me nga ripanga, engari ano hoki te mahi tatau - mai i te mea ngawari ki te tino uaua. Kia kite tatou me pehea e taea ai e te hotaka te tatau te paatata pewa mai i tetahi uara.

ihirangi

Ka tātaihia e mātou te pātapa pewa

He mahi motuhake a Excel (kaiwhakahaere) e kiia ana “ATAN”, ka taea e koe te panui i te paatata arc i roto i nga radians. He penei te ahua o tana wetereo whanui:

=ATAN(tau)

Ka kite tatou, kotahi noa te tautohetohe o te mahi. Ka taea e koe te whakamahi i nga huarahi rereke.

Tikanga 1: Whakauruhia te tātai ā-ringa

He maha nga kaiwhakamahi e mahi tonu ana i nga tatauranga pangarau, tae atu ki nga mea trigonometric, i te mutunga ka maumahara i te tauira mahi me te whakauru a-ringa. Anei te mahi:

  1. Ka piki ake ki roto i te pūtau e hiahia ana matou ki te mahi tatau. Na ka tomo tatou i te tātai mai i te papapātuhi, hei utu mo te tautohe ka tohua he uara motuhake. Kaua e wareware ki te whakatakoto tohu "rite" ki mua i te korero. Hei tauira, i roto i to maatau, waiho “ATAN(4,5)”.Mahi ATAN (arctangent) i Excel
  2. Kia rite te tātai, pāwhiritia E tomoki te tiki i te hua.Mahi ATAN (arctangent) i Excel

Notes

1. Engari i te tau, ka taea e tatou te tautuhi i tetahi hono ki tetahi atu pūtau kei roto he uara tau. I tua atu, ka taea te whakauru i te wahitau ma te ringaringa, ka paato noa ranei i te pūtau e hiahiatia ana i roto i te ripanga ake.

Mahi ATAN (arctangent) i Excel

He watea ake tenei whiringa na te mea ka taea te tono ki tetahi pou tau. Hei tauira, whakauruhia te tauira mo te uara tuatahi ki te raina e rite ana, ka pehi E tomoki te tiki i te hua. Whai muri i tera, nukuhia te pehu ki te kokonga matau o raro o te pūtau me te hua, ka puta mai he ripeka pango, purihia te paatene kiore maui ka toia ki raro ki te pūtau kua whakakiia.

Mahi ATAN (arctangent) i Excel

Ma te tuku i te paatene kiore, ka whiwhi tatou i te tatauranga aunoa o te arc tangent mo nga raraunga tuatahi katoa.

Mahi ATAN (arctangent) i Excel

2. Ano, hei utu mo te whakauru i te mahi i roto i te pūtau ake, ka taea e koe te mahi tika i roto i te pae tauira - paato noa ki roto ki te timata i te aratau whakatika, muri iho ka uru tatou ki te korero e hiahiatia ana. Ka rite, pera i mua, pehia E tomo.

Mahi ATAN (arctangent) i Excel

Tikanga 2: Whakamahia te Ruānuku Mahi

He pai tenei tikanga na te mea kaore koe e mahara ki tetahi mea. Ko te mea nui ko te kaha ki te whakamahi i tetahi kaiawhina motuhake i hangaia ki te kaupapa.

  1. Ka whakatika matou i roto i te pūtau e hiahia ana koe ki te tiki i te hua. Na ka paato i te ata “Fx” (Kōkuhu Taumahi) ki te taha mauī o te pae tātai.Mahi ATAN (arctangent) i Excel
  2. Ka puta he matapihi ki te mata. Ruānuku Mahi. I konei ka tohua e matou he waahanga “Rārangi piapa katoa” (ranei “Pangarau”), panuku i roto i te rarangi o nga kaiwhakahaere, tohu “ATAN”, ka patai OK.Mahi ATAN (arctangent) i Excel
  3. Ka puta he matapihi hei whakaki i te tautohe mahi. I konei ka tohua he uara tau ka pehi OK.Mahi ATAN (arctangent) i ExcelPērā ki te whakauru ā-ringa i te tātai, hei utu mo te tau motuhake, ka taea e taatau te tohu hononga ki tetahi pūtau (ka uru atu ma te ringaringa, ka paato ranei i runga i te ripanga ake).Mahi ATAN (arctangent) i Excel
  4. Ka whiwhi tatou i te hua i roto i te pūtau me te mahi.Mahi ATAN (arctangent) i Excel

Tuhipoka:

Hei huri i te hua i puta mai i roto i nga radians ki nga nekehanga, ka taea e koe te whakamahi i te mahi “DEGREES”. He rite tonu tana whakamahinga ki te whakamahi “ATAN”.

Opaniraa

No reira, ka kitea e koe te arc tangent o tetahi tau i roto i te Excel ma te whakamahi i te mahi ATAN motuhake, ko te tauira ka taea te whakauru i a ringa ki roto i te pūtau e hiahiatia ana. Ko tetahi atu huarahi ko te whakamahi i tetahi Ruānuku Mahi motuhake, ina koa karekau e mahara ki te tauira.

Waiho i te Reply