Intembelo yamathuba kwi-Excel

Enye yeendlela zokucombulula iingxaki zeenkcukacha-manani kukubala okwethutyana lokuzithemba. Isetyenziswa njengenye indlela eyithandayo ukuya kwinqaku eliqikelela ngesampulu encinci. Kufuneka kuqatshelwe ukuba inkqubo yokubala internatud inzima. Kodwa izixhobo zenkqubo ye-Excel zikuvumela ukuba wenze lula ngokulula. Masifumanise ukuba senziwe njani xa senziwa.

Indlela 2: Inqaku lokuthembana.

Ukongeza, kukho enye into enxulumene nokubalwa kwexesha lokuzithemba-ukuthembana. Kuvele, ukuqala kuphela nge-Excel ka-2010. Lo msebenzi wenza ukubalwa kwethuba lemisebenzi ngokubanzi yokuzithemba usebenzisa usasazo lomfundi. Kulungele ukusetyenziswa xa ukusasazeka kwaye, ngokufanelekileyo, ukuphambuka komgangatho awaziwa. I-syntax yomqhubi yile:

= Ukuzithemba .stcular (i-alpha; ye-ratechal; ubungakanani)

Njengoko sibona, amagama abaqhubi kwaye kule meko bahlala bengaguqukanga.

Makhe sibone ukubala imida yentengo yokuzithemba kunye nokuphambuka komgangatho ongaziwayo kumzekelo wenani elifanayo esithe sazithetha ngendlela yangaphambili. Inqanaba lokuzithemba, okokugqibela, thatha i-97%.

1. Sibonisa iseli apho ubalo luya kwenziwa khona. Udongwe kwiqhosha "lokufaka umsebenzi".



2. Kwiwizadi yokusebenza yemisebenzi, yiya kudidi "lweenkcukacha-manani". Khetha igama "Trust. Umfundi". Iqhosha le "Kulungile".



3. Impikiswano yeempikiswano zomqhubi ezichaziweyo ziyasungulwa.

   Kwintsimi ye-alpha, enikwa ukuba inqanaba lokuzithemba lingama-97%, irekhode inani 0.03. Okwesibini kwimigaqo yokubala kule parameter ayiyi kuyeka.

   Emva koko, setha isikhombisi kwindawo "yokuphambuka". Ngeli xesha esi salathisi sinokwazi kwaye siyafuneka ukubala. Oku kwenziwa kusetyenziswa umsebenzi okhethekileyo -bonayo. Ukufowunela iwindow yalo msebenzi, cofa kwi-triangle ukuya ngasekhohlo kwe-formula yomtya. Ukuba awufumani igama elifunwa kuluhlu oluvula, emva koko uye kwi "eminye imisebenzi ...".



4. Imisebenzi Master iqala. Sifudukela kudidi "Iinkcukacha-manani" kunye nenqaku "kuyo igama elithi" iLoyotclona.b ". Ke udongwe kwiqhosha "Kulungile".



5. Iwindow yempikiswano ivula. Umsebenzi we-operator yendawo yokuma. Yinkcazo yokuphambuka komgangatho ngexesha lesampulu. I-syntax yayo ijongeka ngolu hlobo:

   = I-ITMOOTCNN.V (inombolo1; inombolo2; ...)

   Kulula ukuqikelela ukuba impikiswano "yenombolo yidilesi yento yesampula. Ukuba isampulu ibekwe kwindawo enye, uya kuthi, usebenzisa impikiswano enye kuphela, nikezela ikhonkco kolu luhlu.

   Faka isikhombisi kwintsimi "yenombolo1 Emva kokuba i-contridates yabetha intsimi, musa ukungxama ukucinezela iqhosha u "Kulungile", njengoko iziphumo ziya kubachanekanga. Okwangaphambili, kufuneka sibuyele kwimpikiswano yomqhubi wefestile. Umfundi ukwenza ingxoxo yokugqibela. Kule nto, cofa kwigama elifanelekileyo kwifomula.



6. Iwindow yempikiswano iphinde yathathelwa indawo kwakhona. Faka isikhombisi kwintsimi "ubungakanani". Kwakhona, cofa kwi-triangle esele iqhelekile kuthi ukuya ekukhetheni abaqhubi. Njengoko uqonda, sifuna igama "akhawunti". Kuba sasisebenzisa eli nqaku xa kubalwa ngendlela yangaphambili, ikho kolu luhlu, ke nqakraza kuyo. Ukuba awuyifumani, emva koko uthathe ngokwe-algorithm echazwe kwiNdlela yokuqala.



7. Emva kokubetha iwindow yempikiswano, sibeka isikhombisi kwintsimi "yeNombolo1 Ke udongwe kwiqhosha "Kulungile".



8. Emva koko, le nkqubo yenza ukubala kwaye ibonise ixabiso lokufumana intelekelelo.



9. Ukuchonga imida, siya kuphinda sikwazi ukubala ixabiso lesampulu eliphakathi. Kodwa, ngenxa yokuba ubalo lwe-algorithm ngoncedo lwefomula luyafana nakwindlela yangaphambili, kwaye kwanesiphumo asitshintshanga, asiyi kuyeka ngokweenkcukacha okwesibini.



10. Emva kokudala iziphumo zobalo lwe-srvnah kunye nentembeko, sifumana umda welungelo elifanelekileyo lokufumana intelekelelo.



11. Inxulumene neziphumo zobalo lomsebenzi, iziphumo zokubalo zithembekile. Umcwangcisi, sinomda oshiyekileyo kwithuba lokuzithemba.



12. Ukuba ubalo luza kubhala phantsi ngefomula enye, emva koko ubalo lomda ofanelekileyo kwimeko yethu kuya kujongeka ngolu hlobo:

    = I-srnavov (B2: B13) + ithemba. I-0.03;



13. Ngokuhambelana, ifomula yokubala umda wasekhohlo uya kujongeka ngolu hlobo:

    = I-srnavov (B2: B13) -Uyinto ebalulekileyo.stculident (i-0.03;

Njengoko ubona, izixhobo ze-Excel ziya kuququzelela ukubalwa kwexesha lokuthintela kunye nemida yalo. Ngezi njongo, abaqhubi abathile basetyenziselwa iisampulu, apho ukusasazeka okwaziwayo kwaye ayaziwa.