Ntchito ya LOG mu Microsoft Excel

Imodzi mwa masamu odziwika kwambiri a masamu pothetsa mavuto ndi maphunziro ndi kupeza logarithm ya nambala yopatsidwa ndi maziko. Mu Excel, kuti mugwire ntchitoyi, pali ntchito yapadera yotchedwa LOG. Tiyeni tiphunzire mwatsatanetsatane momwe zingagwiritsidwe ntchito pakuchita.

Kugwiritsa ntchito mawu a LOG

Woyendetsa LOG Ndilo gawo la ntchito za masamu. Ntchito yake ndi kuwerengera logarithm ya chiwerengero choyikidwa pa maziko opatsidwa. Mphatikiti wa wotchulidwayo ndi wophweka kwambiri:

= LOG (nambala; [m'munsi])

Monga mukuonera, ntchitoyi ili ndi zifukwa ziwiri zokha.

Kutsutsana "Nambala" ndi chiwerengero chowerengera logarithm. Ikhoza kutenga mawonekedwe a nambala ya chiwerengero ndipo imatanthawuza za selo yomwe ili nayo.

Kutsutsana "Foundation" imaimira maziko omwe logarithm idzawerengedwa. Ikhozanso kukhala, monga mawonekedwe a chiwerengero, ndi kumachita monga selo yeniyeni. Mtsutso uwu ndi wosankha. Ngati izo zasiya, ndiye mazikowo amadziwika kukhala zero.

Komanso, mu Excel palinso ntchito ina yomwe imakulolani kuti muwerenge ma logarithms - LOG10. Kusiyana kwake kwakukulu kuchokera kumbuyoko ndiko kuti kungathe kuwerengera ma logarithms pokhapokha pa maziko a 10, ndiko kuti, logarithms yokha basi. Msonkhano wake ndi wophweka kusiyana ndi mawu omwe atchulidwa kale:

= LOG10 (nambala)

Monga mukuonera, mtsutso wokha wa ntchitoyi ndi "Nambala", ndiko kuti, mtengo wamtengo kapena kutanthauza selo yomwe ilipo. Mosiyana ndi woyendetsa LOG ntchitoyi ili ndi kutsutsana "Foundation" palibe konse, chifukwa akuganiza kuti maziko a chikhalidwecho amachitira 10.

Njira 1: gwiritsani ntchito ntchito ya LOG

Tsopano tiyeni tione kugwiritsa ntchito kwa woyendetsa LOG pachitsanzo chapadera. Tili ndi ndondomeko yamtengo wapatali. Tiyenera kuwerengera logarithm m'munsi mwa iwo. 5.

1. Timasankha selo loyamba lopanda kanthu pa pepalalo mu gawo limene tikukonzekera kusonyeza zotsatira zomaliza. Kenako, dinani pazithunzi "Ikani ntchito"yomwe ili pafupi ndi bar.



2. Zenera likuyamba. Oyang'anira ntchito. Pitani ku gawo "Masamu". Sankhani kusankha dzina "LOG" pa mndandanda wa ogwira ntchito, ndiye dinani pa batani "Chabwino".



3. Ntchitoyi zenera zowonekera. LOG. Monga mukuonera, ili ndi minda iwiri yomwe ikugwirizana ndi mfundo za woyendetsa.

   Kumunda "Nambala" kwa ife, lowetsani adiresi ya selo yoyamba ya chigawo chimene deta yachinsinsi imapezeka. Izi zingatheke pozilemba pamunda pamanja. Koma pali njira yowonjezera. Ikani cholozera m'munda wotchulidwa, ndiyeno dinani batani lamanzere pa selo ya tebulo yomwe ili ndi mtengo wamtengo wapatali umene tikufunikira. Makonzedwe a selo ili adzawonekera nthawi yomweyo kumunda "Nambala".

   Kumunda "Foundation" ingolowani mtengo "5", chifukwa izo zidzakhala zofanana ndi mndandanda wa nambala yonse ukutsatiridwa.

   Pambuyo pochita zinthu izi, dinani pa batani. "Chabwino".



4. Zotsatira za ntchito yokonza LOG mwamsanga mwawonetsedwa mu selo yomwe tanena mu sitepe yoyamba ya malangizo awa.



5. Koma tidazaza selo yoyamba yokha. Kuti mudzaze zonsezo, mukuyenera kufotokoza machitidwewo. Ikani cholozera kumbali ya kumanja kwa selo yomwe ili nayo. Chizindikiro chodzaza chikuwonekera, choperekedwa ngati mtanda. Lembani batani lamanzere la batani ndikukoka mtanda mpaka kumapeto kwa chigawocho.



6. Ndondomeko yapamwambayi inachititsa maselo onse kukhala m'mbali "Logarithm" wodzazidwa ndi zotsatira za mawerengedwe. Chowonadi ndi chakuti chiyanjano chofotokozedwa mmunda "Nambala"ndi wachibale. Mukamayenda mumaselo ndipo amasintha.

Phunziro: Excel ntchito wizara

Njira 2: gwiritsani ntchito LOG10 ntchito

Tsopano tiyeni tiwone chitsanzo cha kugwiritsa ntchito woyendetsa LOG10. Mwachitsanzo, tenga tebulo ndi deta yomweyo. Koma tsopano, ndithudi, ntchitoyi ilipobe kuti awerengere logarithm ya manambala omwe ali m'ndandanda "Baseline" pa maziko 10 (logarithm ya decimal).

1. Sankhani selo yoyamba yopanda kanthu mndandanda. "Logarithm" ndipo dinani pazithunzi "Ikani ntchito".



2. Pawindo lomwe limatsegula Oyang'anira ntchito Onetsani kusintha kwa gawolo "Masamu"koma nthawi ino timayima pa dzina "LOG10". Dinani pansi pawindo pa batani. "Chabwino".



3. Kugwiritsa ntchito ndondomeko yotsutsana ndiwindo LOG10. Monga mukuonera, ili ndi munda umodzi - "Nambala". Ife timalowa mmenemo adiresi ya selo yoyamba ya chigawocho "Baseline", mofanana ndi momwe tinagwiritsira ntchito mu chitsanzo choyambirira. Kenaka dinani pa batani. "Chabwino" pansi pazenera.



4. Zotsatira za kusinthidwa kwa deta, zomwe ndilo decimal logarithm ya nambala yopatsidwa, imasonyezedwa mu selo lomwe latchulidwa kale.



5. Pofuna kupanga chiwerengero cha nambala zina zonse zomwe zikupezeka patebulo, timapanga fomuyi pogwiritsa ntchito chikhomo chodzaza, mofanana ndi nthawi yoyamba. Monga mukuonera, zotsatira za ziwerengero za logarithms za nambala zikuwonetsedwa m'maselo, zomwe zikutanthauza kuti ntchitoyo yatha.

Phunziro: Masamu ena amagwira ntchito ku Excel

Ntchito yogwira ntchito LOG amalola mu Excel mosavuta ndi mofulumira kuwerengera logarithm ya chiwerengero choyikidwa pa maziko opatsidwa. Wofananayo akhoza kuwerenganso logarithm, koma pazinthu izi ndizovuta kugwiritsa ntchito ntchitoyi LOG10.