Daga cikin matakan ilimin lissafi da ake buƙata don warware matsalolin ilmantarwa da aikace-aikace shine nemo logarithm daga lambar da aka bayar akan asalin. A cikin Excel, don aiwatar da wannan aikin, akwai wani aiki na musamman da ake kira LOG. Bari mu koya daki daki daki yadda za'a iya aiwatar dashi.
Amfani da bayanin LOG
Mai aiki LADA nasa ne ga rukunin ayyukan lissafi. Aikinta shine ƙididdige logarithm na adadin ƙayyadadden tushe. Sanarwar don ma'aikacin da aka ƙayyade yana da sauƙin:
= LOG (lamba; [tushe])
Kamar yadda kake gani, aikin yana da hujjoji biyu ne kawai.
Hujja "Lambar" yana wakiltar lamba daga abin da za'a lissafta logarithm. Zai iya ɗaukar nau'in ƙimar lamba kuma ya zama zance ga tantanin da ke ɗauke da shi.
Hujja "Gidauniyar" yana wakiltar tushen da za'a lissafta logarithm. Hakanan yana iya samun nau'i na lamba ko aiki azaman hanyar haɗi zuwa sel. Wannan magana ba na tilas bane. Idan an tsallake, to ana la’akari da cewa tushen ba komai bane.
Bugu da kari, a cikin Excel akwai wani aikin da zai baka damar lissafin logarithms - LOG10. Babban bambancinsa daga wanda ya gabata shine cewa yana iya yin lissafin logarithms kawai akan 10, wannan shine, kawai logarithms madaidaiciya. Syntaxinta ya fi sauki fiye da bayanin da aka gabatar a baya:
= LOG10 (lamba)
Kamar yadda kake gani, kawai hujja ga wannan aikin ita ce "Lambar", wato, adadi mai lamba ko nuni ga tantanin da yake ciki. Ba kamar mai aiki ba LADA wannan aikin yana da hujja "Gidauniyar" gabaɗaya baya nan, tunda ana ɗauka cewa tushen ɗabi'un da take aiwatarwa 10.
Hanyar 1: yi amfani da aikin LOG
Yanzu bari mu kalli aikace-aikacen mai aiki LADA a kan wani kankare misali. Muna da shafi na dabi'un lambobi. Muna buƙatar lissafta daga gare su tushe na logarithm 5.
- Mun zaɓi sel ɗin farko da aka ɓoye a kan takardar a cikin abin da muke shirin nuna sakamakon ƙarshe. Bayan haka, danna kan gunkin "Saka aikin", wanda yake kusa da layin tsari.
- Tagan taga ya fara tashi. Wizards na Aiki. Mun matsa zuwa rukuni "Ilmin lissafi". Muna yin zaɓi "LOG" a jerin masu aiki, sannan a latsa maballin "Ok".
- Farashin muhawara na aiki fara. LADA. Kamar yadda kake gani, yana da filaye guda biyu waɗanda suka dace da muhawara ta wannan mai aiki.
A fagen "Lambar" a cikin yanayinmu, shigar da adireshin farkon sashin layi a cikin abin da tushen asalin bayanan yake. Za'a iya yin wannan ta hanyar shigar da shi a cikin filin da hannu. Amma akwai hanya mafi dacewa. Saita siginan kwamfuta a cikin filin da aka ƙaddara, sannan kaɗa hagu a kan sallar teburin da ke ɗauke da ƙimar lambar da ake so. Ana nuna alamun haɗin wannan sel nan da nan a cikin filin "Lambar".
A fagen "Gidauniyar" kawai shigar da darajar "5", tunda zai zama iri ɗaya ne ga jerin lambobin da ake sarrafa su gaba ɗaya.
Bayan aiwatar da wadannan jan kafa, danna maballin "Ok".
- Sakamakon Ayyuka LADA yana nunawa nan da nan a cikin tantanin halitta wanda muka ƙayyade a matakin farko na wannan umarnin.
- Amma mun cika kawai farkon sel na shafi. Domin cike sauran, kuna buƙatar kwafa dabarar. Sanya siginan kwamfuta zuwa ƙananan kusurwar dama na tantanin da ke ɗauke da shi. Alamar cike take bayyana, wakilta azaman giciye. Matsa maɓallin linzamin kwamfuta na hagu kuma ja gicciye zuwa ƙarshen shafi.
- Tsarin da ke sama ya haifar da dukkanin sel a cikin shafi "Logarithm" cike da sakamakon lissafin. Gaskiyar ita ce mahaɗin da aka nuna a fagen "Lambar"dangi ne. Lokacin motsawa cikin sel, shi ma yana canzawa.
Darasi: Mayan Maɗaukaki
Hanyar 2: yi amfani da aikin LOG10
Yanzu bari mu kalli misali ta amfani da mai amfani LOG10. Misali zamu dauki teburin tare da bayanan farko. Amma yanzu, ba shakka, aikin shine yin lissafin logarithm na lambobin da ke cikin shafi "Tushen bayanai" a kan tushen 10 (adadi na adadi na zamani).
- Zaɓi akwatin farko na layin "Logarithm" kuma danna kan gunkin "Saka aikin".
- A cikin taga yana buɗewa Wizards na Aiki sake zuwa bangaren "Ilmin lissafi"amma wannan karon mun tsaya da sunan "LOG10". Danna maɓallin a ƙasan taga "Ok".
- Ana kunna taga aikin aiki LOG10. Kamar yadda kake gani, tana da filin guda ɗaya kawai - "Lambar". Shigar da adireshin tantanin farko a cikin shafi "Tushen bayanai", kamar yadda muke amfani da shi a cikin misalin da ya gabata. Saika danna maballin "Ok" a kasan taga.
- Sakamakon sarrafa bayanai, wato adadin logarithm na lambar da aka bayar, an nuna shi a cikin tantanin da aka ƙayyade.
- Don yin lissafin duk sauran lambobin da aka gabatar a cikin tebur, muna kwafin dabarun amfani da alamar cikawa, daidai da lokacin da ya gabata. Kamar yadda kake gani, sakamakon lissafin logarithms na lambobi an nuna shi a cikin sel, wanda ke nufin an kammala aikin.
Darasi: Sauran ayyukan lissafi a cikin Excel
Aikace-aikacen aiki LADA a cikin Excel yana ba ku damar sauri da sauƙi a lissafin logarithm na ƙayyadadden lamba akan abin da aka bayar. Hakanan wannan ma'aikaci ɗin yana iya lissafta adadin logarithm ɗin, amma don dalilan da aka nuna shi yafi dacewa da amfani da aikin LOG10.
