- I-Google Sheets manje ikuvumela ukuthi udale ama-box kanye nama-whisk plots ngokwemvelo ngaphandle kwesidingo samafomula enziwe ngesandla.
- Leli thuluzi lenza ngokuzenzakalelayo ukubalwa kwama-quartiles, ama-median, kanye nokuhlonza ama-outliers.
- Kukhona ukuhambisana okugcwele ne-Microsoft Excel, okukuvumela ukuthi ungenise futhi uthumele lawa mashadi ngaphandle kokulahlekelwa ukufometha.
Uma uke waba nomuzwa wokuthi ukuhlaziya ukusabalala kwedatha yakho ku-Google Sheets kwakuyindaba ebuhlungu ngempela, sinezindaba ezinhle. Isikhathi eside kakhulu, labo kithi ababefuna ukudala ibhokisi kanye nesakhiwo se-whisker kwadingeka basebenzise amaqhinga angajwayelekile, njengokusebenzisa amashadi ekhandlela noma ukudala amatafula asizayo angapheli. Kwakuyibuhlungu bangempela, ikakhulukazi uma kuqhathaniswa nokuthi kwakulula kangakanani ukwenza into efanayo ku-Excel.
Ngenhlanhla, i-Google ithathe isinyathelo esibalulekile futhi yahlanganisa lokhu kuboniswa kwezibalo okuthuthukisiwe ngokwemvelo. Manje awusadingi ukuba uchwepheshe kumafomula ayinkimbinkimbi ukuze uqonde ukuthi izinombolo zakho zisatshalaliswa kanjani noma ukuhlonza amaphuzu edatha angavamile nhlobo. Kulesi sihloko, sizochaza ngokuningiliziwe ukuthi ungazuza kanjani kakhulu kuleli thuluzi nokuthi yiziphi izinketho onazo zokwenza amashadi akho ngokwezifiso.
Iyini ngempela ibhokisi kanye nesithombe se-whisker futhi sisetshenziselwani?
Kulabo abangajwayelene kakhulu nalo, lolu hlobo lweshadi luyigugu lokufingqa ukusatshalaliswa kochungechunge lwezinombolo. Empeleni, lusenza sibone, esithombeni esisodwa, ubuncane, ubukhulu, obuphakathi, kanye nama-quartiles . Kuhle kakhulu uma ufuna ukuqhathanisa izigaba ezahlukene noma ukubona ukuthi idatha yakho ihlanganiswe kahle noma isakazeke kuphi.
Ingxenye ephakathi, "ibhokisi," ifaka phakathi u- 50% wedatha (phakathi kwama-quartile okuqala nawesithathu). Umugqa owela leli bhokisi yi-median, esitshela ukuthi i-midpoint yangempela ikuphi, okuvimbela isilinganiso sezibalo ukuthi singasidukisi uma kunezindinganiso eziqine kakhulu. "Ama-whiskers" yimigqa enwebeka iye emaphethelweni ukuze iphawule ububanzi bedatha, kuyilapho ama-outliers evela njengamaphuzu ahlukanisiwe, abonisa izimo ezingavamile noma amaphutha okulinganisa angaba khona.
Indlela yokukhiqiza igrafu ngaphandle kokwenza izinto zibe nzima
Into engcono kakhulu ngesibuyekezo esisha ukuthi i-Google Sheets ikwenzela konke ukuphakamisa okunzima. Akusadingeki ukuthi ubale ama-percentile ngesandla. Inqubo ilula kakhulu: khetha nje ububanzi bedatha yezinombolo ofuna ukuyihlaziya bese ufaka ishadi kumenyu evamile. Uhlelo bese lunakekela ukukhipha amamethrikhi ezibalo adingekayo ngemuva .
Ispredishithi sinquma ngokuzenzakalelayo amanani amancane naphezulu, sibala ama-quartiles okuqala nawesithathu, sithola i-median, bese sibala isilinganiso sezibalo. Ngaphezu kwalokho, isofthiwe ikhomba ama-outliers ngaphandle kokudinga ukuthi ubhale umugqa owodwa wekhodi noma ifomula elisizayo, okuholela ekongeni isikhathi esikhulu kunoma ubani osebenza nge-data analytics noma ezezimali.
Ukwenza ngokwezifiso nezilungiselelo ezithuthukisiwe
Nakuba ukubala kuzenzakalela, i-Google ayisishiyi singakulungele nhlobo futhi isivumela ukuthi silungise amapharamitha amaningana kusuka kuphaneli yokwenza ngokwezifiso ukuqinisekisa ukuthi ishadi lihlelwe kahle. Isibonelo, ungakhetha indlela yokubala ama-quartiles , unqume ukuthi ukhetha indlela ebandakanya wonke umuntu noma ekhethekile (lokhu kushintsha kancane amanani kuye ngokuthi i-median ifakiwe yini kuma-subset).
Ungalungisa nokubonakala kwezinto. Uma ishadi libonakala ligcwele kakhulu, ungafihla amaphuzu angaphakathi amele iphuzu ngalinye ledatha noma ukhethe ukuthi uzobonisa yini izinto ezingaphandle noma cha. Ngaphezu kwalokho, ungashintsha umugqa ophakathi ukuze uwubonise noma uwufihle ukuze uqhathaniswe ngokubonakalayo ne-median.
Ukuvumelanisa okugcwele ne-Microsoft Excel
Kuze kube muva nje, ukungenisa ifayela le-Excel elinamashadi alolu hlobo kuma-Sheets kwakuyinto embi kakhulu ngoba ishadi lalizonyamalala. Manje, leyo nkinga isiyinto yesikhathi esidlule. I-Google isebenzise ukuhambisana kwe-bidirectional , okusho ukuthi uma ungenisa incwadi yokusebenzela ye-Excel eneziqephu zamabhokisi, ama-Sheets azogcina izinkomba, izibalo, kanye nokufometha kwasekuqaleni.
Okuthakazelisa nakakhulu, ungakha ishadi kuma-Sheets bese ulithumela ku-Excel ngenkathi ulondoloza ikhono lokulihlela. Lokhu kusindisa impilo yamaqembu avame ukushintsha phakathi kwamapulatifomu futhi adinga izithombe ezihambisanayo nezingochwepheshe ngaphandle kokuphinda enze umsebenzi wawo isikhathi ngasinye.
Ukuqaliswa kanye nokutholakala
Kubalulekile ukuqaphela ukuthi lesi sici sikhishwe kancane kancane kubo bonke abasebenzisi be-Google Workspace kanye nama-akhawunti omuntu siqu. Kuye ngokuthi isizinda sakho sikusiteshi sokukhishwa okusheshayo noma sokukhishwa okuhleliwe , ithuluzi lingathatha izinsuku ezimbalwa ukuthi livele. Uma ungaliboni kumenyu yakho okwamanje, ungakhathazeki; ngokuvamile kuthatha izinsuku ezifika kwezingu-15 ukuze lisebenze ngokugcwele kuwo wonke ama-akhawunti.
Kufanele kuqashelwe ukuthi, okwamanje, ukudalwa nokuhlelwa kwala mashadi kuqinisekisiwe enguqulweni yewebhu ye-Google Sheets , ngakho-ke kunconywa ukwenza ukuhlaziya okunzima kusuka kukhompyutha hhayi kusuka kuhlelo lokusebenza lweselula.
Ukuba naleli khono lendabuko kushintsha indlela idatha ehlaziywa ngayo efwini, okuvumela noma yimuphi umsebenzisi ukuthi abone ngokushesha ukuhlakazeka kwedatha futhi athole amaphutha ngokuthola izinto ezingaphandle. Ngokususa isidingo samathebula asizayo nokunikeza ukuhambisana okugcwele ne-Excel, ithuluzi lizibeka njengesixazululo esiqinile sokuhlaziywa kwezibalo okusheshayo nokubonakalayo.