Isilinganiso esisezingeni eliphakeme ku-Excel

Indlela evamile eshukumisayo iyithuluzi lezibalo ongaxazulula ngalo uhlobo oluhlukile lomsebenzi. Ikakhulu, imvamisa isetshenziswa ekubikezelweni. Ku-Excel, leli thuluzi lingasetshenziswa futhi ukuxazulula imisebenzi eminingana. Ake sibhekane nokuthi isilinganiso esishukumisayo sisetshenziswa kanjani ku-Efpelle.

Ukusetshenziswa kwesilinganiso se-sliding

Okushiwo le ndlela ukuthi ngosizo lwayo, amanani ashukumisayo ashukumisayo wobubanzi obukhethiwe ku-average average average okwesikhashana ngokubusheleleka idatha kwenzeka. Leli thuluzi lisetshenziselwa ukubalwa kwezomnotho, ukubikezela, kwinqubo yokuhweba ekushintshanisweni kwesitoko, njll. Faka indlela evamile eshukumisayo ku-Easele engcono kakhulu usebenzisa ithuluzi elinamandla kakhulu ledatha, elibizwa ngephakethe lokuhlaziywa. Ngaphezu kwalokho, ngenhloso efanayo ungasebenzisa isici esakhelwe ngaphakathi se-Excel SrvNav.

Indlela 1: Iphakethe lokuhlaziya

Iphakethe lokuhlaziya yingezo le-Excel-In, elikhutshazwe ngokuzenzakalelayo. Ngakho-ke, okokuqala, kuyadingeka ukuyifaka.

1. Hambisa kuthebhu "yefayela". Sichofoza okuchofoza entweni ethi "paranteters".



2. Ku-Izilungiselelo ezisebenzayo iwindi, kufanele uye esigabeni "se-Engezethi" ". Ngezansi kwewindi kwinkambu ye- "Management", kufanele kusethwe ipharamitha ye-Excel. Chofoza inkinobho ethi "Go".



3. Singena efasiteleni lezengezo. Faka umkhaza eduze kwe- "Ukuhlaziya iphakethe" bese uqhafaza inkinobho ethi OK.

Emva kwalokho, iphakethe lokuhlaziywa kwedatha liyasebenza, futhi inkinobho ehambisanayo yavela ethepheni kuthebhu yedatha.

Futhi manje ake sibheke ukuthi ungazisebenzisa kanjani ngqo izinketho zokuhlaziywa kwedatha yedatha ukuze usebenze ngendlela eshukumisayo esezingeni eliphakeme. Ake, ngokususelwa kulwazi mayelana nemali engenayo yenkampani ngezikhathi eziyi-11 ezedlule, izokwenza isibikezelo senyanga yeshumi nambili. Ukuze wenze lokhu, sebenzisa itafula eligcwele idatha, kanye namathuluzi wephakeji yokuhlaziya.

1. Iya kuthebhu ethi "Idatha" bese uqhafaza inkinobho yokuhlaziywa kwedatha, etholakala kwiribbon yamathuluzi esigabeni sokuhlaziya.



2. Uhlu lwamathuluzi atholakala kwiphakheji lokuhlaziya avuleka. Khetha kubo igama elithi "isilinganiso esinyakazayo" bese ucindezela inkinobho ethi "KULUNGILE".



3. Iwindi lokungena idatha lokubikezela indlela eshukumisayo yezwe yethulwe.

   In the "Isikhashana Sokufaka Isikhashana", chaza uhla lwebanga lapho inani lemali engenayo ngaphandle kweseli litholakala, imininingwane lapho kufanele ibalwe.

   Ensimini "yokuphumula", kufanele uchaze isikhathi sokusebenza kwendlela yokushelela. Okokuqala, ake sihlele okushiwo yi-bushed ezinyangeni ezintathu, ngakho-ke faka inombolo "3".

   Ensimini "yokuphuma yesikhashana", udinga ukucacisa ububanzi obungenalutho eshidi lapho idatha izokhonjiswa ngemuva kokusebenza kwabo, okufanele kube yisikhashana esisodwa sokufaka.

   Kufanele futhi ufake umkhaza eduze kwepharamitha "ejwayelekile".

   Uma kunesidingo, ungafaka futhi umkhaza ngesivumelwano se- "Isiphetho se-Graph" yento yokuboniswa okubukwayo, yize kuthi akudingekile.

   Ngemuva kokuba konke kuzilungiselelo kwenziwa, chofoza inkinobho ethi "Kulungile".



4. Uhlelo lubonisa umphumela wokucutshungulwa.



5. Manje yenza bushelelezi isikhathi esiyizinyanga ezimbili ukwembula ukuthi imiphi umphumela ulungile ngokwengeziwe. Ngalezi zinhloso, futhi, qala ithuluzi elithi "Isilinganiso esishukumisayo esijwayelekile sokuhlaziya iphakheji.

   Ensimini "isikhawu sokufaka", sishiya izincazelo ezifanayo nakwicala eledlule.

   Ensimini yokuphumula, sibeka inombolo "2".

   Ensimini "yokuphuma yesikhashana", chaza ikheli lebanga elisha elingenalutho, elithi, futhi, okufanele libe isikhawu esisodwa sokufaka ngaphezulu.

   Izilungiselelo ezisele zisele ngokufanayo. Ngemuva kwalokho, chofoza inkinobho ethi "Kulungile".



6. Ukulandela lokhu, uhlelo lwenza ukubalwa futhi kuboniswe umphumela esikrinini. Ukuze sinqume ukuthi imaphi amamodeli amabili anembe kakhudlwana, kudingeka siqhathanise amaphutha ajwayelekile. Okuncane le nkomba, okuphezulu kakhulu kokunemba komphumela okutholakele. Njengoba sibona, kuzo zonke izindinganiso, iphutha elijwayelekile lapho libala izinyanga ezimbili ezihamba lincane kunenkomba efanayo ezinyangeni ezi-3. Ngakho-ke, inani elibikezelwe ngoDisemba lingabhekwa njengenani elibalwe yindlela yokushelela yesikhathi sokugcina. Kuthu, leli nani linama-ruble ayizinkulungwane ezingama-990,4.

Indlela 2: Kusetshenziswa umsebenzi we-SR

Ku-Excel, kunenye indlela yokusebenzisa indlela eshukumisayo evamile. Ukuze uyisebenzise idinga ukusebenzisa inqwaba yemisebenzi ejwayelekile yohlelo, isisekelo sawo senzelwe umgomo wethu. Isibonelo, sizosebenzisa lonke ithebula elifanayo lemali engenayo endabeni yokuqala.

Njengesikhathi sokugcina, sizodinga ukudala imigqa yesikhashana ebekiwe. Kepha lesi senzo sesikhathi ngeke sisebenze. Kuyadingeka ukubala inani eliphakathi kwazo zonke izinyanga ezimbili, bese izinyanga ezintathu zikwazi ukuqhathanisa imiphumela.

Okokuqala, sibala amanani ajwayelekile ezikhathini ezimbili ezedlule zisebenzisa umsebenzi we-SRVNAF. Kwenze sikwazi, ukuqala ngoMashi, ngoba ngezinsuku ezizayo kukhona ukuqhekeka kwamanani.

1. Sigqamisa iseli kwikholomu engenalutho kulayini ngoMashi. Okulandelayo, chofoza isithonjana esithi "Insert Funct", esibekwa eduze komugqa wefomula.



2. Iwindows wizard wizard icushiwe. Esigabeni se- "Statistical", sifuna inani le- "Srnval", siluba bese uqhafaza inkinobho ethi "KULUNGILE".



3. Iwindi lezimpikiswano ze-opharetha i-opharetha iqala. I-syntax ilandelayo:

   = Srnvov (inombolo1; inombolo2; ...)

   Ingxabano eyodwa kuphela ebophekile.

   Kuthu, enkombeni ye- "Number1", kufanele sichaze isixhumanisi sobubanzi, lapho imali engenayo ikhonjiswa khona kulezi zikhathi ezimbili ezedlule (ngoJanuwari nangoFebhuwari). Sisungula isikhombisi enkundleni bese ukhetha amaseli ahambisanayo eshidini kwikholomu "engenayo". Ngemuva kwalokho, chofoza inkinobho ethi "Kulungile".



4. Njengoba sikwazi ukubona, umphumela wokubalwa kwenani eliphakathi kulezi zikhathi ezimbili ezedlule kuboniswa esitokisini. Ukuze wenze ukubala okufanayo kuzo zonke ezinye izinyanga zesikhathi, sidinga ukukopisha le formula kwamanye amaseli. Ukuze senze lokhu, siba isikhombisi ebhokisini elingezansi kwesokudla selili eliqukethe umsebenzi. Isikhombisi siguqulwa sibe ngumaka wokugcwalisa, onesiqeshana. Chofoza inkinobho yegundane kwesobunxele bese welula kuze kube sekupheleni kwekholomu.



5. Sithola ukubalwa kwemiphumela yenani eliphakathi ezinyangeni ezimbili ezedlule ngaphambi kokuphela konyaka.



6. Manje siqokomisa iseli kukholomu elandelayo engenalutho kulayini ngo-Ephreli. Shayela iwindi lezimpisi lomsebenzi womsebenzi we-SRVNOW ngendlela efanayo eyayichazwe ngaphambilini. Ensimini "Inombolo1" Faka izixhumanisi zamaseli kwikholomu "engenayo" kusuka ngoJanuwari kuya kuMashi. Bese uchofoza inkinobho ethi "KULUNGILE".



7. Kusetshenziswa umaki wokugcwalisa, kopisha ifomula kumaseli etafuleni elingezansi.



8. Ngakho-ke, sabala izincazelo. Manje, njengasesikhathini esedlule, sizodinga ukuthola ukuthi hlobo luni lokuhlaziya olungcono: ngokubushelelezi ezinyangeni ezi-2 noma ezi-3. Ukuze wenze lokhu, ukubala ukuphambuka okuphakathi nendawo nezinye izinkomba. Okokuqala, sibala ukuphambuka okuphelele kusetshenziswa umsebenzi we-Standard Excel Abs, okuthi, esikhundleni sezinombolo ezinhle noma ezingezinhle, zibuyisa imodyuli yazo. Leli nani lizolingana nomehluko phakathi kwemali engenayo yangempela yenyanga ekhethiwe kanye nalokho okucatshangelwe. Faka isikhombisi kwikholamu elandelayo engenalutho kulayini ngoMeyi. Shayela imisebenzi yemisebenzi.



9. Esigabeni esithi "Mathematical" sabela igama lomsebenzi we- "Abs". Chofoza inkinobho ethi "KULUNGILE".



10. Iwindi le-ABS function argation liqala. Ensimini kuphela ethi "Inombolo" Khombisa umehluko phakathi kokuqukethwe kwamaseli kumakholomu "Imali" kanye "2 izinyanga" ngoMeyi. Bese uchofoza inkinobho ethi "KULUNGILE".



11. Usebenzisa umaki wokugcwaliswa, kopisha le formula kuyo yonke imigqa yethebula ngoNovemba kufaka phakathi.



12. Sibala inani elijwayelekile lokuphambuka ngokuphelele kwaso sonke isikhathi sisebenzisa imisebenzi ejwayelekile ye-SRVNOV.



13. Inqubo efanayo yenziwa ukuze ibale ukuphambuka ngokuphelele kokuhamba izinyanga ezi-3. Okokuqala, faka isici se-ABS. Kulesi sikhathi kuphela lapho sibheka umehluko phakathi kokuqukethwe kwamangqamuzana anemali yangempela kanye nabahleliwe, abaliwe besebenzisa indlela yokuhambisa isilinganiso sezinyanga ezi-3.



14. Okulandelayo, sibala inani elijwayelekile lemininingwane yokuphambuka ngokuphelele usebenzisa umsebenzi we-SRVNOW.



15. Isinyathelo esilandelayo ukubala ukuphambuka kwesihlobo. Ilingana nesilinganiso sokuphambuka ngokuphelele kwinkomba yangempela. Ukuze sigweme amanani amabi, sizophinde sisebenzise amathuba anikezwa ngu-ABS. Kulokhu, usebenzisa lo msebenzi, sihlukanisa inani lokuphambuka ngokuphelele lapho sisebenzisa indlela eshukumisayo evamile yezinyanga ezi-2 kwiholo langempela lenyanga ekhethiwe.



16. Kepha ukuphambuka kwesihlobo senziwa ukuboniswa ngamaphesenti. Ngakho-ke, sigqamisa uhla oluhambisanayo eshidini, liye kuthebhu "Yasekhaya", lapho ku-Ithuluzi "Inombolo" nge-Ithuluzi elikhethekile setha ifomethi yamaphesenti. Emva kwalokho, umphumela wokubalwa kokuphambuka kwesihlobo kuboniswa njengephesenti.



17. Umsebenzi wokubala wokuhlinzwa ofanayo wenziwa ngedatha esetshenziswa ngokushelela izinyanga ezi-3. Kulesi simo kuphela, ukubala njengokuhlukaniswa, sisebenzisa enye ikholomu yetafula, esinalo igama elithi "Abs. Off (3m). " Ngemuva kwalokho sihumushela amanani ezinombolo ngamaphesenti.



18. Emva kwalokho, bala amanani aphakathi kuwo wonke amakholomu wokuphambuka okuhlobene, njengakuqala ukusebenzisa umsebenzi we-SRVNAF kulokhu. Kusukela ukubala njengezimpikiswano zomsebenzi, sithatha amaphesenti, khona-ke akukho ukuguqulwa okwengeziwe okudingekayo. Opharetha abathengi bakhipha umphumela njengephesenti lefomethi.



19. Manje sasondela ekubalweni kokuphambuka okuphakathi nendawo. Le nkomba izosivumela ukuthi siqhathanise ngokuqondile ikhwalithi yesibalo lapho sisebenzisa ukushelela izinyanga ezimbili nezinyanga ezintathu. Kuthu, ukuphambuka okuphakathi kwe-quadratic kuzolingana nesikwele sezimpande zesamba sezikwele zemihluko phakathi kwemali yangempela kanye nesilinganiso esishukumisayo esihlukaniswe ngenani lezinyanga. Ukuze wenze ukubalwa kuhlelo, kufanele sisebenzise inzuzo yemisebenzi ethile, ikakhulukazi impande, ukusatshalaliswa kanye nesikolo. Isibonelo, ukubala ukuphambuka okumaphakathi okuphakathi nendawo lapho usebenzisa umugqa oshelelayo izinyanga ezimbili ngoMeyi, kithi, ifomula yohlobo olulandelayo izosetshenziswa:

    = Izimpande (B6: B12; C6: C12) / Akhawunti (B6: B12))

    Kopisha kwamanye amaseli wekholomu nokubalwa kokuphambuka okumaphakathi okuphakathi nendawo ngokumaka.



20. Ukusebenza okufanayo kokubala ukuphambuka okujwayelekile kwe-quadratic kwenziwa ngesilinganiso esishukumisayo izinyanga ezi-3.



21. Ngemuva kwalokho, sibala inani eliphakathi lesikhathi sonke salezi zinkomba ngokusebenzisa umsebenzi we-SRVNA.



22. Ngokuqhathanisa ukubalwa ngendlela yokuhamba ngesilinganiso esinezinyanga ezi-2 kuya kwezi-3 ngokuya ngezinkomba ezinjalo, njengokuphambuka okujwayelekile, ukuphambuka okujwayelekile, kuphephile ukusho ukuthi ukushelela izinyanga ezimbili kunikeza imiphumela ethembekile ukwedlula i Ukusetshenziswa kokushelela izinyanga ezintathu. Lokhu kufakazelwa yiqiniso lokuthi izinkomba ezingenhla ezinyangeni ezihamba ngezinyanga ezimbili ezihamba ngezinyawo, ezingaphansi kwezinyanga ezintathu.



23. Ngakho-ke, inkomba ebonakalayo yemali engenayo yebhizinisi ngoDisemba izoba ngama-ruble ayizinkulungwane ezingama-990,4. Njengoba ukwazi ukubona, leli nani lihlangana ngokuphelele nalena esikutholile ngokukhiqiza ukubala sisebenzisa amathuluzi wephakeji yokuhlaziya.

Isifundo: I-Master of Imisebenzi ku-Asuka

Sibala isibikezelo sisebenzisa indlela eshukumisayo esezingeni eliphakeme ngezindlela ezimbili. Njengoba ukwazi ukubona, le nqubo ilula ukwenza ukusebenzisa amathuluzi wephakeji yokuhlaziya. Noma kunjalo, abanye abasebenzisi abahlali bethemba ukubalwa okuzenzakalelayo futhi bakhetha ukubala ukusebenzisa umsebenzi we-SRVNA kanye nabaqhubi abahlobene ukuhlola inketho ethembekile kakhulu. Noma, uma konke kwenziwa kahle, umphumela wokubala kufanele ufane ngokugcwele lapho uphuma khona.