Ofaya daga cikin shahararrun aikin bayanan ilimin lissafi shi ne mahaɗan. Yana da lambar Euler da aka haɓaka har zuwa alamar da aka nuna. A cikin Excel akwai wani ma'aikacin daban wanda yake ba ku damar lissafa shi. Bari mu ga yadda za a iya amfani dashi a aikace.
Lissafin mai nunawa a cikin Excel
Onentasashen waje shine lambar Euler wanda aka ɗaga zuwa digiri da aka bayar. Lambar Euler da kanta tayi kusan 2.718281828. Wani lokacin ana kiranta da lambar Napier. Aikin fitar kamar haka:
f (x) = e ^ n,
inda e shine lambar Euler kuma n digiri ne na tsafta.
Yin lissafin wannan alamar a cikin Excel, ana amfani da wani ma'aikaci daban - EXP. Bugu da kari, wannan aikin za'a iya nuna shi ta hanyar jadawali. Za mu yi magana game da aiki tare da waɗannan kayan aikin daga baya.
Hanyar 1: lissafta mai kuɗin ta hanyar shigar da aiki da hannu
Domin kirga darajar mai kaya a cikin Excel e har zuwa wannan, kuna buƙatar amfani da sabis na musamman EXP. Syntax kamar haka:
= EXP (lamba)
Wannan shine, wannan tsari ya ƙunshi hujja ɗaya kawai. Yana kawai wakiltar digiri wanda kuke buƙatar ƙara lambar Euler. Wannan gardamar na iya zama ko ta hanyar ƙimar lamuni, ko ɗaukar hanyar haɗi zuwa tantanin da ke ɗauke da ma'aunin digiri.
- Don haka, don yin lissafin mahaɗan don digiri na uku, ya ishe mu shigar da magana mai zuwa cikin masarar dabara ko cikin kowane ɓoyayyen sel akan takardar:
= EXP (3) - Don aiwatar da lissafin, danna maɓallin Shigar. Jimlar ta bayyana a cikin sel da aka riga aka ayyana.
Darasi: Sauran ayyuka na lissafi a cikin Excel
Hanyar 2: yi amfani da Mayen aikin
Kodayake tsarin magana don ƙididdige ƙarar yana da sauƙin gaske, wasu masu amfani sun fi son amfani da su Mayan fasalin. Yi la'akari da yadda ake yin wannan ta misali.
- Mun sanya siginan kwamfuta akan tantanin halitta inda za'a nuna sakamakon lissafin karshe. Danna kan gunkin a wani gunki. "Saka aikin" a hagu na dabarar dabara.
- Window yana buɗewa Wizards na Aiki. A cikin rukuni "Ilmin lissafi" ko "Cikakken jerin haruffa" muna neman sunan "EXP". Zaɓi wannan sunan kuma danna maballin. "Ok".
- Tattaunawa ta buɗe tana buɗewa. Tana da filin guda ɗaya kawai - "Lambar". Muna fitar da adadi a ciki, wanda hakan yana nufin girman darajar lambar Euler. Latsa maballin "Ok".
- Bayan ayyukan da ke sama, za a nuna sakamakon lissafi a cikin tantanin da aka fifita a sakin farko na wannan hanyar.
Idan hujja magana ce ta tantanin halitta wanda ya ƙunshi kari, to kuna buƙatar sanya siginan kwamfuta a cikin filin "Lambar" kuma kawai zaɓi waccan wayar a takardar. Abubuwan daidaitawarsa suna nunawa nan da nan a cikin filin. Bayan haka, don ƙididdige sakamakon, danna maɓallin Yayi kyau.
Darasi: Wiziyan fasalin a Microsoft Excel
Hanyar 3: makirci
Bugu da ƙari, a cikin Excel akwai damar da za a gina jadawali, ɗauka azaman tushen sakamakon da aka samu sakamakon ƙididdigar mahaɗan. Don ƙirƙirar jadawali, ya kamata takarda ya riga ya ƙididdige abubuwan ƙididdigar abubuwan digiri daban-daban. Kuna iya lissafta su ta amfani da ɗayan hanyoyin da aka bayyana a sama.
- Mun zaɓi kewayon wanda wakilcin mai gabatarwa. Je zuwa shafin Saka bayanai. A kan kintinkiri a cikin rukunin saiti Charts danna maballin Chart. Lissafin zane-zane yana buɗewa. Zaɓi nau'in da kuke ganin ya fi dacewa da takamaiman ayyuka.
- Bayan da aka zaɓi nau'in jadawalin, shirin zai gina da kuma nuna shi a kan takarda iri ɗaya, gwargwadon masu nuna kwatancen. Gabaɗaya zai yuwu a gyara, kamar kowane zane mai kyau na Excel.
Darasi: Yadda ake yin ginshiƙi a Excel
Kamar yadda kake gani, ƙididdige ma'anar a cikin Excel ta amfani da aikin EXP na farko sauki. Wannan hanya mai sauƙin aiwatar duka a cikin jagora kuma ta Wizards na Aiki. Bugu da kari, shirin ya samar da kayan aikin kirkirar makirci bisa wadannan lissafin.
