Hanyar matsakaiciyar hanya ita ce kayan aiki na ƙididdiga wanda zaka iya magance nau'o'in matsalolin daban. Musamman ma, ana amfani dashi sosai a cikin tsinkaya. A cikin Excel, wannan kayan aiki za a iya amfani dashi don warware ɗayan ayyuka. Bari mu ga yadda ake amfani da matsakaicin motsi a Excel.
Aikace-aikace na motsi matsakaita
Ma'anar wannan hanya ita ce tare da taimakonsa akwai canji na cikakkiyar ma'auni na jerin zaɓuɓɓukan zuwa jerin ƙididdigar ƙididdiga don wani lokaci ta hanyar ragewa bayanai. Ana amfani da wannan kayan aiki don lissafin tattalin arziki, tsinkaya, a cikin tsarin kasuwanci akan musayar jari, da dai sauransu. Zai fi kyau a yi amfani da hanyar ƙaddamar da ƙaura a Excel tare da taimakon kayan aiki mai mahimmanci don sarrafa bayanai, wanda aka kira Taswirar bincike. Bugu da ƙari, saboda waɗannan dalilai, zaka iya amfani da aikin Excel na ciki. GABAWA.
Hanyar 1: Analysis Package
Taswirar bincike Adireshin Excel ne wanda aka lalace ta tsoho. Saboda haka, da farko, an buƙaci don taimakawa.
- Matsa zuwa shafin "Fayil". Danna abu. "Zabuka".
- A cikin matakan sigogi da ke fara, je zuwa sashen Ƙara-kan. A kasan taga a filin "Gudanarwa" Dole ne a saita saitin Ƙara Add-ins. Danna maballin "Ku tafi".
- Mun shiga cikin duniyar add-ons. Saita alamar kusa da abu "Shirye-shiryen Bincike" kuma danna maballin "Ok".
Bayan wannan aikin kunshin "Tasirin Bayanan Bayanai" an kunna, da maɓallin daidai ya bayyana akan rubutun a cikin shafin "Bayanan".
Yanzu bari mu dubi yadda za ka iya amfani da damar da ke cikin kunshin kai tsaye. Bayanin bayanai don yin aiki a kan hanyoyi masu yawa. Bari mu, bisa bayanin da aka samu game da kudin da kamfanin ya samu a cikin shekaru 11 da suka gabata, ya yi bayanin watanni na goma sha biyu. Don yin wannan, muna amfani da tebur cike da bayanai da kayan aiki. Taswirar bincike.
- Jeka shafin "Bayanan" kuma danna maballin "Tasirin Bayanan Bayanai"wanda aka sanya a kan kayan aikin kayan aiki a cikin toshe "Analysis".
- Jerin kayan aikin da suke samuwa a cikin Taswirar bincike. Mun zabi daga gare su sunan "Matsayin Juyawa" kuma danna maballin "Ok".
- An kaddamar da shigarwar shigar da bayanai don ƙaddamar da hasashen da ya dace.
A cikin filin "Lokacin shiga" saka adreshin kewayon, inda yawan kudin shiga na kowane wata ba tare da tantanin tantanin halitta ba, bayanan da ya kamata a lasafta shi.
A cikin filin "Interval" saka da lokaci na aiki dabi'u ta yin amfani da hanyar smoothing. Da farko, bari mu sanya adadin smoothing zuwa watanni uku, sabili da haka shigar da adadi "3".
A cikin filin "Tsarin Sanya" kana buƙatar saka wani nau'i marar kuskure a kan takardar, inda za a nuna bayanan bayan aiki, wanda ya zama salula guda ɗaya fiye da lokacin shigarwa.
Har ila yau duba akwatin kusa da "Kuskuren kurakurai".
Idan ya cancanta, zaka iya duba akwatin kusa da "Sanya" don nuna zanga-zanga, ko da yake a cikin yanayinmu ba lallai ba ne.
Bayan duk saitunan da aka yi, danna kan maballin. "Ok".
- Wannan shirin yana nuna sakamakon aiki.
- Yanzu za mu kashe shinge don tsawon watanni biyu don bayyana abin da sakamakon ya fi daidai. A saboda wannan dalili, muna sake sa kayan aiki. "Matsayin Juyawa" Taswirar bincike.
A cikin filin "Lokacin shiga" Ka bar irin waɗannan lambobi kamar yadda ya faru a baya.
A cikin filin "Interval" sanya lambar "2".
A cikin filin "Tsarin Sanya" mun saka adireshin sabon layi maras kyau, wanda, sake, dole ne guda daya ya fi girma fiye da lokacin shigarwa.
Sauran sauran saituna suna bar canzawa. Bayan haka, danna maballin "Ok".
- Bayan haka, shirin ya lissafta kuma ya nuna sakamakon akan allon. Domin sanin ko wane ɗayan samfurori biyu ya fi daidai, muna buƙatar kwatanta kurakurai da dama. Ƙananan alamar wannan alama, mafi girma shine yiwuwar daidaito na sakamakon. Kamar yadda kake gani, saboda duk dabi'u na kuskuren kuskure a cikin lissafin watanni biyu na zakulo shi ne kasa da adadi ɗaya na watanni 3. Ta haka ne, za a iya la'akari da adadi na watan Disamba ga darajar da aka ƙididdige ta hanyar slip hanya na ƙarshe. A cikin yanayinmu, wannan darajar tana da 990.4 dubu rubles.
Hanyar 2: Yi amfani da aikin AVERAGE
A cikin Excel akwai wata hanyar da za ta yi amfani da hanyar ƙaura. Don yin amfani da shi, kana buƙatar amfani da wasu ayyuka na shirye-shirye na musamman, ainihin abin da don manufar mu GABAWA. Alal misali, zamu yi amfani da wannan tebur na kudin shiga na kasuwancin kamar yadda ya kasance a cikin akwati na farko.
Kamar lokaci na ƙarshe, zamu buƙatar ƙirƙirar jerin lokuta mai tsabta. Amma a wannan lokacin ba za a yi amfani da ayyukan ba. Yi la'akari da darajar kuɗin kowane kowane wata biyu kuma bayan watanni uku domin ya iya kwatanta sakamakon.
Da farko, muna ƙididdige ƙimar da aka ƙayyade a cikin lokuta biyu da suka gabata ta amfani da aikin GABAWA. Za mu iya yin wannan kawai farawa ne a watan Maris, tun lokacin da kwanakin baya suka sami hutu a dabi'u.
- Zaɓi tantanin halitta a cikin jaka a jere don Maris. Kusa, danna kan gunkin "Saka aiki"wanda yake kusa da wannan tsari.
- Window aiki Ma'aikata masu aiki. A cikin rukunin "Labarin lissafi" neman darajar "SRZNACH"zaɓi shi kuma danna maballin "Ok".
- Maƙallin bayanin mai aiki ya fara. GABAWA. Harshensa kamar haka:
= BINCIKE (lamba1; number2; ...)Ana buƙatar guda ɗaya ne kawai.
A yanayinmu, a filin "Number1" Dole ne mu samar da hanyar haɗi zuwa kewayon inda aka sami kudin shiga na kwanakin baya biyu (Janairu da Fabrairu). Saita siginan kwamfuta a cikin filin sannan ka zaɓi sel masu dacewa akan takardar a shafi "Asusun". Bayan haka, danna maballin "Ok".
- Kamar yadda kake gani, sakamakon nuna ƙayyadadden matsakaicin lokaci biyu da aka nuna a cikin tantanin halitta. Domin yin irin wannan lissafi don dukan sauran watanni na wannan lokaci, muna buƙatar kwafin wannan tsari zuwa wasu kwayoyin. Don yin wannan, mun zama siginan kwamfuta a cikin kusurwar dama na cell dauke da aikin. Mai siginan kwamfuta ya canza zuwa alama mai cika, wanda yayi kama da gicciye. Riƙe maballin hagu na hagu kuma ja shi zuwa ƙarshen shafin.
- Mun sami lissafi na sakamakon da aka samu don watanni biyu da suka gabata kafin ƙarshen shekara.
- Yanzu zaɓin tantanin halitta a cikin layi na gaba mai zuwa a jere don Afrilu. Kira maɓallin gwajin aiki GABAWA kamar yadda aka bayyana a baya. A cikin filin "Number1" shigar da ƙayyadaddun layin sel a cikin shafi "Asusun" daga Janairu zuwa Maris. Sa'an nan kuma danna maballin "Ok".
- Yin amfani da alamar cika, kwafa da wannan tsari zuwa teburin tebur a ƙasa.
- Saboda haka, mun ƙididdige dabi'u. A halin yanzu, kamar yadda a baya, muna bukatar mu gano irin nau'in bincike ya fi kyau: tare da alƙawari a cikin 2 ko 3 watanni. Don yin wannan, ƙididdige daidaitattun daidaituwa da wasu alamomi. Na farko, muna lissafin cikakken kuskure ta amfani da daidaitattun aikin Excel. ABS, wanda a maimakon lambobi masu mahimmanci ko korau sun sake dawo da tsarin su. Wannan darajar za ta kasance daidai da bambancin tsakanin kudaden shiga na watanni da aka zaba da kuma fitowar. Saita siginan kwamfuta a cikin jere na gaba mai zuwa a jere don Mayu. Kira Wizard aikin.
- A cikin rukunin "Ilmin lissafi" zaɓi sunan aikin "Abs". Muna danna maɓallin "Ok".
- Gidan gwajin aikin ya fara. ABS. A cikin filin guda "Lambar" saka bambanci tsakanin abinda ke cikin sel a cikin ginshiƙai "Asusun" kuma "Watanni 2" don Mayu. Sa'an nan kuma danna maballin "Ok".
- Amfani da alamar cika, zamu kwafi wannan mahimmanci ga duk layuka a cikin tebur ta cikin watan Nuwamba.
- Ƙididdige ƙimar adadin cikakken daidaituwa ga dukan tsawon lokacin ta amfani da aikin da ya saba da mu GABAWA.
- Muna yin wannan hanya don yin lissafin cikakken bambanci don zakulo don watanni 3. Mun fara amfani da aikin ABS. Sai kawai wannan lokaci, munyi la'akari da bambancin tsakanin abinda ke cikin sel tare da ainihin kudin da aka shirya, ƙidayar ta yin amfani da hanya matsakaici don 3 watanni.
- Na gaba, muna ƙididdige ƙimar dukan cikakkiyar bayanai ta ɓatawa ta amfani da aikin GABAWA.
- Mataki na gaba shine lissafta ƙayyadaddun zumunta. Ya daidaita da rabo daga cikakkiyar ɓatawa ga ainihin maƙalli. Don guje wa dabi'u mara kyau, zamu sake yin amfani da damar da mai ba da sabis ya ba shi ABS. Wannan lokaci ta amfani da wannan aikin, muna raba cikakkiyar darajar darajar lokacin yin amfani da hanya matsakaicin hanya don watanni 2 ta ainihin kudin shiga ga watan da aka zaɓa.
- Amma bambancin zumunta yawanci ana nuna a matsayin kashi. Sabili da haka, zaɓi hanyar da aka dace akan takardar, je zuwa shafin "Gida"inda a cikin kayan aikin inganci "Lambar" A cikin yanayin tsarawa na musamman, saita tsarin ƙimar. Bayan haka, sakamakon nuna lissafin ƙayyadaddun zumunci ya nuna a kashi.
- Muna yin irin wannan aiki don ƙididdige bambancin zumunci tare da bayanan ta amfani da smoothing don watanni 3. Sai kawai a wannan yanayin, don lissafta a matsayin rabon, muna amfani da wani shafi na teburin, wanda muke da suna "Ba a kashe ba (3m)". Sa'an nan kuma mu fassara yawan lambobi zuwa kashi.
- Bayan haka, muna lissafin matsakaicin matsayi na duka ginshiƙai tare da bambancin zumunta, kamar yadda muka yi amfani da aikin don wannan manufa GABAWA. Tun da mun ɗauki dabi'u mai yawa don aiki a matsayin muhawarar aikin, ba mu buƙatar ƙarin musanya. Mai aiki a cikin fitarwa ya ba da sakamakon riga a cikin ƙimar girma.
- Yanzu mun zo lissafin daidaitattun daidaituwa. Wannan alamar za ta ƙyale mu mu kwatanta ƙimar lissafi idan muka yi amfani da alaƙa ga watanni biyu da uku. A halinmu, daidaitattun daidaitattun za su kasance daidai da tushen wuri na adadin ƙididdigar bambance-bambance a cikin kudaden kudaden kudaden shiga kuma yawan ƙimar da aka raba ta yawan watanni. Don yin lissafi a cikin shirin, dole mu yi amfani da wasu ayyuka, musamman ROOT, SUMMKRAVN kuma Asusu. Alal misali, don ƙididdige daidaitattun daidaitattun lokacin yin amfani da launi mai laushi na watanni biyu a watan Mayu, a yanayinmu, ana amfani da wannan maƙirarin:
= ROOT (SUMKVRAZN (B6: B12; C6: C12) / LITTAFI (B6: B12))Muna kwafin shi zuwa wasu sassan na shafi tare da lissafin daidaitattun daidaituwa ta hanyar alamar cikawa.
- Muna yin irin wannan aiki don ƙididdige daidaitattun daidaituwa don matsakaicin matsakaici don watanni 3.
- Bayan wannan, muna lissafin adadin yawancin lokaci na waɗannan duka alamomi, yin amfani da aikin GABAWA.
- Bayan yin kwatanta lissafi ta hanyar amfani da hanyoyi masu ma'ana tare da smoothing a cikin 2 da 3 watanni ta yin amfani da alamomi kamar rarrabewa, rarrabawar zumunci da daidaitattun daidaituwa, zamu iya ɗauka cewa ƙaƙaɗɗun watanni biyu yana bada ƙarin abin dogara fiye da watanni uku. Wannan ya nuna ta gaskiyar cewa alamun da ke sama a cikin watanni biyu suna wucewa fiye da watanni uku.
- Sabili da haka, asusun ajiyar kuɗi na kamfanin a watan Disamba zai kasance 990.4 dubu rubles. Kamar yadda kake gani, wannan darajan daidai yake da abin da muka karɓa, yin lissafi ta amfani da kayan aiki Taswirar bincike.
Darasi: Maɓallin aiki na Excel
Mun lissafta hangen nesa ta hanyar yin amfani da hanya matsakaici a hanyoyi biyu. Kamar yadda kake gani, wannan tsari yana da sauƙin yin amfani da kayan aiki. Taswirar bincike. Duk da haka, wasu masu amfani ba su yarda da lissafi na atomatik ba kuma sun fi so su yi amfani da aikin don lissafi. GABAWA da kuma masu amfani da su don tabbatar da abin da ya fi dacewa. Ko da yake, idan an yi duk abin da yake daidai, a cikin fitarwa sakamakon sakamakon lissafi ya kamata ya zama daidai ɗaya.
