Ayyukan LOG a cikin Microsoft Excel

Ɗaya daga cikin ayyukan da aka fi sani da ilmin lissafi don magance matsalolin ilimi da kuma matsalolin shine don gano logarithm na lambar da aka ba ta tushe. A Excel, don yin wannan aiki, akwai aikin musamman da ake kira LOG. Bari mu koyi yadda za a iya amfani da shi a aikace.

Yin amfani da sanarwa na LOG

Mai sarrafawa LOG yana cikin nau'in ayyukan ayyuka na ilmin lissafi. Ayyukansa shine ƙididdige logarithm na lambar da aka ƙayyade don tushen da aka ba. Haɗin aikin mai ƙayyadadden ƙwararren yana da sauƙi:

= LOG (lamba; [tushe])

Kamar yadda kake gani, aikin yana da kawai muhawara biyu.

Magana "Lambar" shine lambar daga abin da za a lissafa logarithm. Zai iya ɗaukar nauyin ƙimar lambobi kuma ya kasance mai kula da tantanin halitta dauke da shi.

Magana "Foundation" wakiltar tushen abin da logarithm za a lasafta. Hakanan yana iya samun, a matsayin mahimmanci, kuma yayi aiki a matsayin tantancewar salula. Wannan jayayya ne na zaɓi. Idan an cire shi, to anyi la'akari da tushe ba kome.

Bugu da ƙari, a cikin Excel akwai wani aikin da zai ba ka damar lissafin logarithms - LOG10. Babban bambancin da yake da shi daga baya shi ne cewa zai iya lissafin logarithms kawai bisa ga 10, wato, ƙananan logarithms ne kawai. Hakanan ya kasance mafi sauki fiye da bayanin da aka gabatar a baya:

= LOG10 (lambar)

Kamar yadda kake gani, kawai hujjar wannan aikin shine "Lambar", wato, darajar lambobi ko ma'anar tantanin tantanin halitta wanda aka samo shi. Ba kamar mai aiki ba LOG wannan aikin yana da hujja "Foundation" ba ya nan gaba ɗaya, tun da an ɗauka cewa tushe na dabi'un da ake gudanarwa shine 10.

Hanyar 1: amfani da aikin LOG

Yanzu bari muyi la'akari da amfani da mai aiki LOG a kan wani misali. Muna da shafi na lambobi. Muna buƙatar lissafin logarithm na tushe daga cikinsu. 5.

1. Muna yin zaɓi na ɓoye na farko a cikin takardar a cikin shafi wanda muke shirya don nuna sakamakon karshe. Kusa, danna kan gunkin "Saka aiki"wanda yake kusa da wannan tsari.



2. Wurin ya fara. Ma'aikata masu aiki. Matsa zuwa category "Ilmin lissafi". Yi zaɓi na sunan "LOG" a cikin jerin masu aiki, sannan danna maballin "Ok".



3. Maganin muhawarar aiki ta fara. LOG. Kamar yadda kake gani, yana da filayen biyu wanda ya dace da muhawarar wannan afaretan.

   A cikin filin "Lambar" a cikin shari'ar mu, shigar da adreshin tantanin halitta na farko na shafi wanda aka samo bayanin asalin. Ana iya yin wannan ta hanyar buga shi a filin da hannu. Amma akwai hanya mafi dacewa. Saita siginan kwamfuta a cikin filin da aka kayyade, sannan ka danna maɓallin linzamin hagu na kan teburin da ke dauke da lambar da muke bukata. Matsakanin wannan tantanin halitta zai bayyana a fili a halin yanzu "Lambar".

   A cikin filin "Foundation" kawai shigar da darajar "5", tun da zai kasance iri ɗaya don ana aiwatar da dukkan jerin jerin lambobin.

   Bayan yin wannan magudi danna maballin. "Ok".



4. Sakamakon aiki LOG nan da nan aka nuna a cikin tantanin halitta da muka ƙayyade a mataki na farko na wannan umarni.



5. Amma mun cika kawai tantanin farko na shafi. Don cika sauran, kana buƙatar kwafin daftarin. Saita siginan kwamfuta a cikin kusurwar dama na cell dauke da shi. Alamar cikawa ta bayyana, ta gabatar da ita a matsayin gicciye. Kunna maɓallin linzamin hagu kuma ja giciye zuwa ƙarshen shafi.



6. Hanyar da ke sama ta sa dukkan sassan a cikin wani shafi "Logarithm" cike da sakamakon sakamakon lissafi. Gaskiyar ita ce, haɗin da aka ƙayyade a filin "Lambar"dangi ne. Lokacin da kake motsa ta cikin kwayoyin kuma yana canje-canje.

Darasi: Maɓallin aiki na Excel

Hanyar 2: yi amfani da aikin LOG10

Yanzu bari mu dubi misali na yin amfani da mai aiki LOG10. Alal misali, ɗauki teburin tare da bayanin asalin. Amma a yanzu, ba shakka, aikin zai kasance a lissafin logarithm na lambobin da ke cikin shafi "Baseline" a kan asali 10 (ƙaddarar adadi).

1. Zaɓi maɓalli na asali na farko a cikin shafi. "Logarithm" kuma danna gunkin "Saka aiki".



2. A cikin taga wanda ya buɗe Ma'aikata masu aiki sake sake canzawa zuwa rukunin "Ilmin lissafi"amma wannan lokaci mun dakatar da sunan "LOG10". Danna maɓallin taga a kan maɓallin. "Ok".



3. Kunna gwargwadon aikin aiki LOG10. Kamar yadda ka gani, yana da filin guda daya - "Lambar". Mun shiga cikin adireshin cellular farko na shafi "Baseline", kamar yadda muka yi amfani da su a cikin misali na baya. Sa'an nan kuma danna maballin. "Ok" a kasan taga.



4. Sakamakon aiki na bayanai, wato ƙaddamar da adadi na lambar da aka ba da shi, an nuna shi a cikin ƙwayar da aka ƙayyade a baya.



5. Don yin lissafi ga dukan sauran lambobin da aka gabatar a teburin, zamu yi kwafin wannan ma'anar ta amfani da alamar cika, kamar yadda ya gabata. Kamar yadda kake gani, ana nuna alamun lissafin logarithms na lambobi a cikin sel, wanda ke nufin cewa aikin ya kammala.

Darasi: Wasu ayyuka na math a Excel

Aikace-aikacen aiki LOG yana ba da dama a Excel kawai da sauri don lissafta logarithm na lambar da aka ƙayyade don tushen da aka ba. Kwamfutar ɗaya ɗin nan na iya ƙididdige ƙirar ƙirar ƙira, amma don waɗannan dalilai ya fi dacewa don amfani da aikin LOG10.