Ukuchezuka okujwayelekile ku-Excel

I-arithmetic mean ingenye yezindlela zezibalo ezidume kakhulu ezibalwa yonke indawo. Kodwa ngokwako akuthembeki nhlobo. Abantu abaningi bayasazi isisho esithi umuntu oyedwa udla iklabishi, omunye udla inyama, futhi ngokwesilinganiso bobabili badla amaroli eklabishi. Esibonelweni somholo ojwayelekile, kulula kakhulu ukukhombisa lokhu. Amaphesenti ambalwa abantu abahola izigidi ngeke athinte kakhulu izibalo, kodwa angonakalise ngokuphawulekayo umgomo wawo, eqise isibalo ngamaphesenti angamashumi amaningana.

Lapho ukuncipha kokusabalala phakathi kwamanani, ungathembela nakakhulu lesi sibalo. Ngakho-ke, kunconywa kakhulu ukuthi njalo ubale ukuchezuka okujwayelekile kanye nencazelo ye-arithmetic. Namuhla sizobona ukuthi singakwenza kanjani ngendlela efanele usebenzisa iMicrosoft Excel.

Ukuchezuka okujwayelekile - kuyini

Ukuchezuka okujwayelekile (noma okujwayelekile) kuyimpande eyisikwele yokuhluka. Kanti, leli gama lokugcina libhekisela ezingeni lokuhlakazwa kwamanani. Ukuthola ukuhluka, futhi, ngenxa yalokho, i-derivative yayo ngendlela yokuphambuka okujwayelekile, kukhona ifomula ekhethekile, okuyinto, noma kunjalo, engabalulekile kangako kithi. Iyinkimbinkimbi kakhulu ngesakhiwo sayo, kodwa ngesikhathi esifanayo ingenziwa ngokuzenzakalelayo kusetshenziswa i-Excel. Into esemqoka ukwazi ukuthi yiziphi imingcele okufanele zidlule emsebenzini. Ngokuvamile, kokubili ekubaleni ukuhluka kanye nokuchezuka okujwayelekile, izimpikiswano ziyafana.

1. Okokuqala sithola incazelo ye-arithmetic.
2. Ngemva kwalokho, inani lokuqala ngalinye liqhathaniswa nesilinganiso futhi umehluko phakathi kwazo uyanqunywa.
3. Ngemva kwalokho, umehluko ngamunye uphakanyiselwa emandleni esibili, ngemva kwalokho imiphumela ewumphumela yengezwa ndawonye.
4. Ekugcineni, isinyathelo sokugcina sihlukanisa inani eliwumphumela ngenani eliphelele lama-elementi kusampula esinikeziwe.

Ngemva kokuthola umehluko phakathi kwevelu eyodwa kanye nencazelo ye-arithmetic yesampula yonke, singathola ibanga ukuya kulo ukusuka endaweni ethile emugqeni wokuxhumanisa. Kosaqalayo, yonke ingqondo icacile kuze kufike esinyathelweni sesithathu. Kungani kuyisikwele senani? Iqiniso liwukuthi ngezinye izikhathi umehluko ungaba negative, futhi sidinga ukuthola inombolo ephozithivu. Futhi, njengoba wazi, ukususa izikhathi zokususa kunikeza ukuhlanganisa. Bese-ke sidinga ukunquma incazelo ye-arithmetic yamanani angumphumela. I-Dispersion inezici eziningi:

1. Uma uthola ukwehluka enombolweni eyodwa, izohlala inguziro.
2. Uma inombolo engahleliwe iphindaphindwa ngo-A ongaguquki, khona-ke umehluko uzokwanda nge-factor of A squared. Kalula nje, okungaguquki kungakhishwa kuphawu lokuhlakazeka futhi kuphakanyiswe emandleni esibili.
3. Uma u-A ongaguquki engezwa enombolweni engafanele noma esuswa kuyo, khona-ke umehluko ngeke ushintshe kulokhu.
4. Uma izinombolo ezimbili ezingahleliwe, ezichazwe, isibonelo, ngeziguquguqukayo u-X no-Y, zinganciki komunye nomunye, khona-ke kulokhu ifomula iyasebenza kubo. D(X+Y) = D(X) + D(Y)
5. Uma senza izinguquko kufomula yangaphambilini bese sizama ukunquma ukuhluka komehluko phakathi kwalawa manani, kuzoba futhi isamba salokhu kwehluka.

Ukuchezuka okujwayelekile igama lezibalo elisuselwe ekuhlakazweni. Ukuyithola kulula kakhulu: vele uthathe impande eyisikwele yokuhluka.

Umehluko phakathi kokuhluka nokuchezuka okujwayelekile usendimeni yamayunithi, ngomqondo ongokomfanekiso. Ukuchezuka okujwayelekile kulula kakhulu ukukufunda ngoba akuboniswa kuzikwele zenombolo, kodwa ngamavelu ngokuqondile. Ngamagama alula, uma ngokulandelana kwezinombolo 1,2,3,4,5 isilinganiso se-arithmetic singu-3, ​​ngakho-ke, ngokufanele, ukuchezuka okujwayelekile kuzoba inombolo engu-1,58. Lokhu kusitshela ukuthi, ngokwesilinganiso, inombolo eyodwa ichezuka enanini eliyisilinganiso (okungu-1,58 esibonelweni sethu), ngo-XNUMX.

Umehluko uzoba inombolo efanayo, isikwele kuphela. Esibonelweni sethu, ingaphansi kancane kuka-2,5. Empeleni, ungasebenzisa kokubili ukuhluka kanye nokuchezuka okujwayelekile ekubalweni kwezibalo, udinga nje ukwazi kahle ukuthi iyiphi inkomba umsebenzisi asebenza nayo.

Ibala Ukuchezuka Okujwayelekile ku-Excel

Sinezinhlobonhlobo ezimbili eziyinhloko zefomula. Eyokuqala ibalwa ngesampula labantu. Okwesibili - ngokusho kukajenene. Ukuze ubale ukuchezuka okujwayelekile kwesampula labantu, udinga ukusebenzisa umsebenzi I-STDEV.V. Uma kudingekile ukwenza ukubalwa kwabantu abaningi, ngakho-ke kuyadingeka ukusebenzisa umsebenzi I-STDEV.G.

Umehluko phakathi kwesibalo sabantu besampula kanye nenani labantu elivamile ukuthi esimweni sokuqala, idatha icutshungulwa ngokuqondile, ngesisekelo lapho kubalwa khona incazelo ye-arithmetic kanye nokuchezuka okujwayelekile. Uma sikhuluma ngenani labantu elivamile, khona-ke lena isethi yonke yedatha yobuningi ehlobene nesenzakalo esingaphansi kocwaningo. Ngokufanelekile, isampula kufanele imele ngokuphelele. Okusho ukuthi, ucwaningo kufanele lubandakanye abantu abangahlotshaniswa nomphakathi jikelele ngezilinganiso ezilinganayo. Isibonelo, uma ezweni elinemibandela u-50% wamadoda kanye no-50% wabesifazane, isampula kufanele ibe nezilinganiso ezifanayo.

Ngakho-ke, ukuchezuka okujwayelekile kwabantu abaningi kungase kuhluke kancane kusampula, njengoba esimweni sesibili izibalo zangempela zincane. Kodwa ngokuvamile, yomibili imisebenzi isebenza ngendlela efanayo. Manje sizochaza ukuthi yini okufanele yenziwe ukuze sibabize. Futhi ungakwenza ngezindlela ezintathu.

Indlela 1. Ukufaka ifomula mathupha

Ukufaka mathupha kuyindlela eyinkimbinkimbi, uma uthi nhlá. Kodwa-ke, wonke umuntu kufanele abe ngumnikazi wayo uma efuna ukuba ngumsebenzisi we-Excel ochwepheshe. Inzuzo yayo ukuthi awudingi ukubiza iwindi lokufaka ingxabano nhlobo. Uma uzijwayeza kahle, kuzoshesha kakhulu kunokusebenzisa lezi ezinye izindlela ezimbili. Into eyinhloko ukuthi iminwe iqeqeshwe. Ngokufanelekile, wonke umsebenzisi we-Excel kufanele ajwayele indlela eyimpumputhe yokufaka amafomula nemisebenzi ngokushesha.

1. Senza ukuchofoza kwegundane kwesokunxele kuseli lapho kuzobhalwa khona ifomula yokuthola ukuchezuka okujwayelekile. Ungakwazi futhi ukuyifaka njengengxabano kunoma yimiphi eminye imisebenzi. Kulesi simo, udinga ukuchofoza umugqa wokufaka wefomula, bese uqala ukungena ku-agumenti lapho umphumela kufanele uboniswe khona.
2. Ifomula evamile imi kanje: =STDEV.Y(inombolo1(cell_address1), number2(cell_address2),…). Uma sisebenzisa inketho yesibili, khona-ke yonke into yenziwa ngendlela efanayo ncamashi, uhlamvu G kuphela egameni lomsebenzi olushintshwayo lube ngu-B. Inombolo enkulu yezimpikiswano ezisekelwe ngu-255.
3. Ngemva kokufaka ifomula sekuqediwe, siqinisekisa izenzo zethu. Ukuze wenze lokhu, cindezela inkinobho yokufaka.

Ngakho, ukubala ukuchezuka okujwayelekile, sidinga ukusebenzisa izimpikiswano ezifanayo nezokuthola incazelo ye-arithmetic. Konke okunye uhlelo olungakwenza ngokwalo. Futhi, njengengxabano, ungasebenzisa lonke uhla lwamanani, ngesisekelo lapho ukubalwa kokuchezuka okujwayelekile kuzokwenziwa. Manje ake sibheke ezinye izindlela ezizoqondakala kangcono kumsebenzisi we-Excel we-novice. Kodwa ngokuhamba kwesikhathi, bazodinga ukushiywa ngoba:

1. Ukufaka ifomula mathupha kungonga isikhathi esiningi. Umsebenzisi we-Excel okhumbula ifomula kanye ne-syntax yayo unenzuzo enkulu kunomuntu osanda kuqala futhi ofuna umsebenzi awufunayo ohlwini KuWizadi Yomsebenzi noma kuribhoni. Ngaphezu kwalokho, okokufaka kwekhibhodi ngokwako kuyashesha kakhulu kunokusebenzisa igundane.
2. Amehlo akhathele kancane. Akudingekile ukuthi uhlale ushintsha ukugxila kusuka etafuleni ukuya efasiteleni, bese uye kwelinye iwindi, bese kuya kukhibhodi, bese ubuyela etafuleni. Lokhu futhi kusiza kakhulu ukonga isikhathi nomzamo, okungase kusetshenziselwe ukucubungula ulwazi lwangempela, kunokugcina amafomula.
3. Ukufaka amafomula mathupha kuvumelana nezimo kakhulu kunokusebenzisa izindlela ezimbili ezilandelayo. Umsebenzisi angacacisa ngokushesha amaseli adingekayo ebanga ngaphandle kokulikhetha ngokuqondile, noma abheke lonke ithebula ngesikhathi esisodwa, agweme ubungozi bokuthi ibhokisi lengxoxo lizolivimba.
4. Ukusebenzisa amafomula mathupha kuwuhlobo lwebhuloho lokubhala amamakhro. Yiqiniso, lokhu ngeke kukusize ufunde ulimi lwe-VBA, kodwa kwakha imikhuba efanele. Uma umuntu ejwayele ukunikeza imiyalo kukhompuyutha esebenzisa ikhibhodi, kuyoba lula kakhulu kuye ukwazi noma yiluphi olunye ulimi lokuhlela, kuhlanganise nokuthuthukisa ama-macros amaspredishithi.

Kodwa-ke yebo. Ukusebenzisa ezinye izindlela kungcono kakhulu uma umusha futhi usanda kuqala. Ngakho-ke, siphendukela ekucabangeni kwezinye izindlela zokubala ukuchezuka okujwayelekile.

Indlela 2. Ithebhu Yamafomula

Enye indlela etholakalayo kumsebenzisi ofuna ukuthola ukuchezuka okujwayelekile ebangeni ukusebenzisa ithebhu ethi “Amafomula” kumenyu enkulu. Ake sichaze kabanzi ukuthi yini okufanele yenziwe kulokhu:

1. Khetha iseli lapho sifuna ukubhala khona umphumela.
2. Ngemuva kwalokho, sithola ithebhu ethi "Amafomula" kuribhoni bese siya kuyo.
3. Masisebenzise ibhulokhi “Ilabhulali yemisebenzi”. Kukhona inkinobho ethi "Izici Eziningi". Ohlwini oluzoba khona, sizothola into ethi "Statistical". Ngemva kwalokho, sikhetha ukuthi yiluphi uhlobo lwefomula esizoyisebenzisa.
4. Ngemva kwalokho, iwindi lokufaka izimpikiswano liyavela. Kuyo, sibonisa zonke izinombolo, izixhumanisi zamaseli noma ububanzi obuzobamba iqhaza ekubalweni. Ngemuva kokuthi siqedile, chofoza inkinobho ethi "OK".

Izinzuzo zale ndlela:

1. Isivinini. Le ndlela ishesha kakhulu futhi ikuvumela ukuthi ufake ifomula oyifunayo ngokuchofoza okumbalwa nje.
2. Ukunemba. Abukho ubungozi bokubhala ngephutha iseli okungeyona noma ukubhala incwadi okungeyona bese uchitha isikhathi sokusebenza kabusha.

Singasho ukuthi lena inombolo yesibili indlela engcono kakhulu ngemva kokufaka ngesandla. KODWA indlela yesithathu nayo iyasiza kwezinye izimo.

Indlela yesi-3: Isilekeleli Somsebenzi

I-Function Wizard ingenye indlela elula yokufaka amafomula abaqalayo abangakawabambeli ngekhanda amagama ne-syntax yemisebenzi. Inkinobho yokuqalisa Iwizadi Yomsebenzi itholakala eduze komugqa wokufaka wefomula. Inzuzo yayo enkulu kumuntu oqalayo ngokumelene nesizinda sezindlela zangaphambilini ilele kumacebo wohlelo anemininingwane, imuphi umsebenzi onesibopho salokho nokuthi yiziphi izimpikiswano okufanele zifakwe ngaluphi uhlelo. Inezinhlamvu ezimbili - fx. Sichofoza kukho.

Ngemva kwalokho, kuzovela uhlu lwemisebenzi. Ungazama ukuyithola ohlwini olugcwele lwezinhlamvu, noma uvule isigaba "Sezibalo", lapho ungathola khona nalo opharetha.

Singabona ohlwini ukuthi umsebenzi I-STDEV usekhona. Lokhu kwenzelwa ukwenza amafayela amadala ahambisane nenguqulo entsha ye-Excel. Nokho, kunconywa kakhulu ukuthi usebenzise izici ezintsha ezibalwe ngenhla, ngoba ngesikhathi esithile lesi sici esihoxisiwe singase singabe sisasekelwa.

Ngemva kokuchofoza okuthi KULUNGILE, sizoba nenketho yokuvula iwindi lezimpikiswano. I-agumenti ngayinye iyinombolo eyodwa, ikheli ngeseli (uma liqukethe inani lenombolo), noma ububanzi bamanani azosetshenziselwa incazelo ye-arithmetic kanye nokuchezuka okujwayelekile. Ngemva kokufaka zonke izimpikiswano, chofoza inkinobho ethi "OK". Idatha izofakwa kuseli esifake kulo ifomula.

Isiphetho

Ngakho, akunzima ukubala ukuchezuka okujwayelekile usebenzisa i-Excel. Futhi umsebenzi ngokwawo uyisisekelo sokubala kwezibalo, okuyinto enembile. Phela, kusobala ukuthi akuyona nje inani elijwayelekile elibalulekile, kodwa futhi nokusabalala kwamanani okuvela kuwo incazelo ye-arithmetic. Phela, uma ingxenye yabantu icebile kanti ingxenye impofu, empeleni ngeke kube nesigaba esiphakathi. Kodwa ngesikhathi esifanayo, uma sithola incazelo ye-arithmetic, kuvela ukuthi isakhamuzi esivamile singummeleli wesigaba esiphakathi. Kodwa kuzwakala, okungenani, kuyinqaba. Sekukonke, sikufisela inhlanhla ngalesi sici.