Ukuvavanya inqanaba lokungalingani phakathi kweengqengqelo ezahlukeneyo zabantu, i-curve ye-loresz kunye nokukhutshwa kwisalathiso sakhe-i-gineny isetyenziswa rhoqo. Ngoncedo lwazo, kunokwenzeka ukuba uqaphele ukuba lukhulu kangakanani umqolo oluntu phakathi kwendawo enobunzima kunye ne-poored yabemi. Sebenzisa izixhobo zokwenza isicelo ze-Excel, unokulungiselela inkqubo yokwakha ijika le-lorerez. Makhe sibone, njengakwimeko ye-Excel enokwenziwa ekusebenzeni.
Sebenzisa i-curve ye-lorentz
I-loresrey ijika ngumsebenzi oqhelekileyo wokusasaza oboniswe ngemifanekiso. Ngokwe-X Axis yalo msebenzi, inani labemi kwinqanaba lepesenti yokwanda, kwaye ecaleni kwe-Axis ye-Y linani lilonke lengeniso yelizwe. Ngokwenyani, ijikajika le-loresz ngokwayo inamanqaku, nganye nganye ihambelana nepesenti yenqanaba lengeniso yenxalenye ethile yoluntu. Umgca omkhulu we-lorentz, kokukhona uluntu inqanaba lokungalingani.Kwimeko efanelekileyo apho akukho ukungalingani kukawonke-wonke, iqela ngalinye labemi linenqanaba lengeniso lilungelelaniswe ngokuthe ngqo kwinani layo. Umgca obonakalisa imeko enjalo ibizwa ngokuba yijika lokulingana, nangona lingumgca othe ngqo. Inqanaba elikhulu le-10, i-Limited I-Loreentz ijika kwaye ijika ijika, iphakamile kwinqanaba lokungalingani eluntwini.
I-Lorereyz ijika ingasetyenziselwa kungekuphela nje ukumisela imeko yokwahlula ipropathi ehlabathini, kwilizwe elithile okanye eluntwini, kodwa nokuthelekisa kule nkalo yamakhaya abo.
Umgca othe nkqo, odibanisa umgca wokulingana kunye neyona ndawo ininzi ye-ilresrez ijika i-hoover isalathiso se-hoover yesalathiso okanye irobhothi. Eli candelo libonisa ukuba loluphi uphawu lwengeniso kwi-Refloubxwe kuluntu ekufezekiseni ukulingana ngokupheleleyo.
Inqanaba lokungalingani eluntwini lithathiwe kusetyenziswa i-ginny isalathiso, esinokwahluka ukusuka kwi-0 ukuya kwi-1 ikwabizwa ngokuba kukungoneliseki kwengeniso.
Umgca wokulingana
Ngoku makhe sijonge umzekelo, indlela yokwenza umgca wokulingana kunye ne-Loreerez ijika kwi-Excel. Ukwenza oku, sebenzisa itafile yenani labemi elaphukileyo lamaqela amahlanu alinganayo (i-20%), eshwankathelwe etafileni ngokwanda. Kwikholam yesibini yale theyibhile, ubungakanani bengeniso yesizwe kwipesenti, ehambelana neqela elithile labemi liboniswayo.
Ukuqala, sakha umgca wokulingana ngokupheleleyo. Iya kuba namachaphaza amabini-zero kunye nenqaku lengeniso yelizwe liphela nge-100% yabemi.
- Yiya kwi "Faka" ithebhu. Kwilayini kwi-"aram "ibloko ibhloko, cofa kwiqhosha" spot ". Luhlobo lohlobo lwemizobo elungele umsebenzi wethu. Oku kulandelayo kuvula uluhlu lwezinto eziphambili zeetshathi. Khetha "Ibike i-curves egudileyo kunye nababukeli."
- Emva kokuba le nto yenziwe indawo engenanto yetshathi. Yenzekile kuba asiyikhethanga idatha. Ukwenzela ukuba wenze idatha kwaye wakhe itshathi, cofa kwiqhosha lasekunene lemouse kwindawo engenanto. Kwimenyu yokusebenza esebenzayo, khetha i "Khetha idatha ..." into.
- Ifestile yokhetho yedatha ivulwa. Ngasekhohlo kwalo, ebizwa ngokuba "yimiba yeentsomi (i-RAPKS)" ngokucofa iqhosha "Yongeza".
- Ifestile yefestile isungulwe. Kwi "rog igama", ubhala igama lomzobo esifuna ukulunikezela. Inokuba ibekwe kwiphepha kwaye kule meko kufuneka ikhankanya idilesi yeseli yawo. Kodwa kwimeko yethu kulula ukungena nje igama ngesandla. Sinika umzobo igama "umgca wokulingana".
Kwintsimi ye-X, kufuneka uchaze ukulungelelaniswa kwamanqaku emzobo kwi-Axis X Axis. Kule ndawo.
Kwintsimi ye "V Ixabiso", ukulungelelaniswa kwamanqaku ecaleni kwe-Axis ye-Y kufuneka kubhalwe. Kuya kuba bobabini: 0 kunye ne-35.9. Inqaku lokugqibela, njengoko sinokubona ngokweshedyuli, sihlangabezana nengeniso yelizwe liphela ye-100% yabemi. Ke, bhala amaxabiso "0; 35.9" ngaphandle kweekowuti.
Emva kwayo yonke idatha ebonisiweyo yenziwa, cofa kwiqhosha "Kulungile".
- Emva koko, sibuyela kwifestile yokukhetha yedatha. Kuyo, kananjalo, cofa iqhosha "Kulungile".
- Njengoko sibona, emva kokuba le nto ingentla, umgca wokulingana uya kwakhiwa kwaye uya kubonakala ephepheni.
Isifundo: Ungayenza njani itshathi ekuthinjweni
Ukwenza i-curve ye-loreentz
Ngoku kufuneka sakhile ngokuthe ngqo ijika le-loreretz, ixhomekeke kwidatha ye-tabuster.
- Cofa ekunene kwingingqi yomzobo, apho umgca wokulingana sele ukho. Kwimenyu yokusebenza, yeka ukhetho kwi "Khetha idatha ...".
- Ifestile yokukhetha idatha ivula kwakhona. Njengoko sibona, phakathi kwezinto, igama elithi "igama lokulingana" sele libonisiwe, kodwa kufuneka senze enye itshathi. Ke ngoko, sicofa iqhosha "Yongeza".
- Ifestile yefestile ivula kwakhona. "Igama lomqolo", gqibela ixesha lokugqibela, gcwalisa ngesandla. Apha ungafaka igama "lorentz curve".
Kwintsimi ye "X", yonke idatha yekholamu "% yabemi" yetafile yethu kufuneka isetyenziswe. Ukwenza oku, setha isikhombisi kwindawo yentsimi. Okulandelayo, kuqhuma iqhosha lemouse lasekhohlo kwaye ukhethe ikholam ehambelana nephepha. Ukulungelelaniswa kuya kuboniswa ngoko nangoko kumqolo wokutshintsha ifestile.
Kwintsimi ye "V Ixabiso", sangena ekuhlanganiselweni kweeseli zekholamu "umvuzo wesizwe". Senza le nto ngokwendlela efanayo apho idatha yenziwe kwicandelo langaphambili.
Emva kwayo yonke le datha ingentla yenziwa, cinezela iqhosha u "Kulungile".
- Emva kokubuyela kwi-windows yokhetho, cofa iqhosha u "Kulungile".
- Njengoko sibona, emva kokwenza le nto ingentla, i-loresz curve iya kuboniswa kwiphepha le-Excel.
Ukwakhiwa kwejikajika le-loreretz kunye nomgca wokulingana kwi-Excel kuveliswa kwimigaqo efanayo njengolwakhiwo naluphi na olunye uhlobo lweetshathi kule nkqubo. Ke ngoko, kubasebenzisi abathi babamba amandla okwakha imizobo kunye neegrafu kwi-Excel, lo msebenzi awufanelanga ukubangela iingxaki ezinkulu.