Nthawi yachidaliro mu Excel. Njira za 2 Zowerengera Nthawi Yachidaliro mu Excel

Nthawi yachidaliro imawerengedwa kuti ithetse mafunso owerengera. Kupeza nambalayi popanda kuthandizidwa ndi kompyuta ndikovuta, chifukwa chake muyenera kugwiritsa ntchito zida za Excel ngati mukufuna kudziwa mitundu yovomerezeka yopatuka kuchokera ku tanthauzo lachitsanzo.

Kupanga Nthawi Yachidaliro ndi CONFID.NORM Operator

Wogwiritsa ntchito ali m'gulu la "Statistical". M'matembenuzidwe akale, amatchedwa "TRUST", ntchito yake inali ndi mfundo zomwezo.

Ntchito yonse ikuwoneka motere: =CONFIDENCE.NORM(Alpha,Standard,Size).

Ganizirani za njira ya opareshoni ndi mfundo (iliyonse iyenera kuwonekera powerengera):

1. "Alpha" imasonyeza mulingo wa kufunikira komwe kuwerengetserako kumachokera.

Pali njira ziwiri zowerengera mulingo wowonjezera:

• 1-(Alpha) - zoyenera ngati mkangano ndi coefficient. Chitsanzo: 1-0,4=0,6 (0,4=40%/100%);
• (100-(Alpha))/100 - ndondomekoyi imagwiritsidwa ntchito powerengera nthawiyo ngati peresenti. Chitsanzo: (100-40)/100=0,6.

2. Kupatuka kokhazikika ndiko kupatuka kovomerezeka muchitsanzo china.
3. Kukula - kuchuluka kwa chidziwitso chomwe chafufuzidwa

Tcherani khutu! Wothandizira TRUST atha kupezekabe ku Excel. Ngati mukufuna kugwiritsa ntchito, yang'anani mu gawo la "Kugwirizana".

Tiyeni tiwone fomula ikugwira ntchito. Muyenera kupanga tebulo lokhala ndi mawerengero angapo. Tangoganizani kuti kupatuka kokhazikika ndi 7. Cholinga ndikutanthauzira nthawi ndi chikhulupiliro cha 80%.

Sikoyenera kulowa kupatuka ndi mlingo wa chidaliro pa pepala, deta izi zikhoza kulowetsedwa pamanja. Kuwerengera kumachitika m'njira zingapo:

1. Sankhani cell yopanda kanthu ndikutsegula "Function Manager". Idzawonekera pazenera mutadina chizindikiro cha "F (x)" pafupi ndi kapamwamba. Muthanso kupita ku menyu yantchito kudzera pa tabu ya "Formulas" pazida, kumanzere kwake pali batani la "Insert function" lomwe lili ndi chizindikiro chomwecho.

2. Sankhani gawo la "Statistical" ndikupeza pakati pa zinthu zomwe wogwiritsa ntchito TRUST.NORM. Muyenera alemba pa izo ndi kumadula "Chabwino".

3. Zenera la Arguments Fill lidzatsegulidwa. Mzere woyamba uyenera kukhala ndi njira yowerengera mkangano wa "Alpha". Malinga ndi chikhalidwecho, mulingo wodalirika umawonetsedwa ngati peresenti, chifukwa chake timagwiritsa ntchito njira yachiwiri: (100-(Alpha))/100.
4. Kupatuka kokhazikika kwadziwika kale, tiyeni tilembe pamzere kapena tisankhe selo lomwe lili ndi data yomwe yayikidwa patsamba. Mzere wachitatu uli ndi chiwerengero cha zolemba patebulo - pali 10 mwa izo. Mukamaliza minda yonse, dinani "Enter" kapena "Chabwino".

Ntchitoyi ikhoza kukhala yokhayokha kotero kuti kusintha chidziwitso sikupangitsa kuti kuwerengera kulephereke. Tiyeni tione momwe tingachitire sitepe ndi sitepe.

1. Pamene gawo la "Kukula" silinadzazidwe, dinani pa izo, kuti likhale logwira ntchito. Kenaka timatsegula mndandanda wa ntchito - ili kumanzere kwa chinsalu pamzere womwewo ndi bar formula. Kuti mutsegule, dinani muvi. Muyenera kusankha gawo la "Ntchito Zina", uku ndiko kulowa komaliza pamndandanda.

2. Function Manager idzawonekeranso. Pakati pa owerengera, muyenera kupeza ntchito ya "Akaunti" ndikusankha.

Zofunika! Zotsutsana za ntchito COUNT zitha kukhala manambala, ma cell, kapena magulu a ma cell. Pankhaniyi, omaliza adzachita. Pazonse, chilinganizocho sichingakhale ndi mikangano yopitilira 255.

3. Gawo lapamwamba liyenera kukhala ndi ma values ​​omwe ali mugulu la ma cell. Dinani pa mkangano woyamba, sankhani ndime yopanda mutu, ndipo dinani OK batani.

Mtengo wapakati udzawonekera mu selo. Nambala iyi idapezedwa pogwiritsa ntchito deta yachitsanzo: 2,83683532.

Kutsimikiza kwa nthawi yodalirika kudzera mu CONFIDENCE.STUDENT

Wogwiritsa ntchitoyu akufunanso kuwerengera kuchuluka kwapatuka. M'mawerengedwe, njira yosiyana imagwiritsidwa ntchito - imagwiritsa ntchito kugawa kwa Wophunzira, pokhapokha ngati kufalikira kwa mtengo sikudziwika.

Fomula imasiyana ndi yapitayi mwa wogwiritsa ntchito. Zikuwoneka motere: =KUKHULUPIRIRA.WOPHUNZIRA(Alefa;Ctand_off; kukula).

Timagwiritsa ntchito tebulo losungidwa powerengera zatsopano. Kupatuka kokhazikika muvuto latsopano kumakhala mkangano wosadziwika.

1. Tsegulani "Function Manager" mu imodzi mwa njira zomwe tafotokozazi. Muyenera kupeza ntchito ya CONFIDENCE.STUDENT mu gawo la "Statistical", sankhani ndikudina "Chabwino".

2. Lembani mikangano yantchito. Mzere woyamba ndi wofanana: (100-(Alpha))/100.
3. Kupatuka sikudziwika, malinga ndi momwe vutolo lilili. Kuti tiwerenge, timagwiritsa ntchito fomula yowonjezera. Muyenera dinani pagawo lachiwiri pazenera la mikangano, tsegulani menyu yantchito ndikusankha chinthu cha "Ntchito Zina".

4. Imafunika STDDEV.B (mwachitsanzo) mugawo la Statistical. Sankhani ndikudina Chabwino.

5. Timadzaza mkangano woyamba wazenera lotsegulidwa ndi ma cell angapo okhala ndi mikhalidwe osaganizira zamutu. Simuyenera kudina Chabwino pambuyo pake.

6. Tiyeni tibwerere ku mikangano ya TRUST.STUDENT podina kawiri pa zolembedwazi mu kapamwamba kapamwamba. Mugawo la "Kukula", ikani COUNT wogwiritsa ntchito ngati nthawi yomaliza.

Pambuyo kukanikiza "Lowani" kapena "Chabwino" mtengo watsopano wa nthawi yodalirika udzawonekera mu selo. Malinga ndi Wophunzira, zidakhala zochepa - 0,540168684.

Kusankha malire apakati pa mbali zonse ziwiri

Kuti muwerenge malire a nthawiyi, muyenera kudziwa kuti mtengo wake ndi wotani, pogwiritsa ntchito ntchito ya AVERAGE.

1. Tsegulani "Function Manager" ndikusankha woyendetsa yemwe mukufuna mu gawo la "Statistical".

2. Onjezani gulu la ma cell omwe ali ndi zikhalidwe pagawo loyamba la mkangano ndikudina batani la OK.

3. Tsopano mutha kufotokozera malire amanja ndi akumanzere. Idzatengera masamu osavuta. Kuwerengera malire oyenera: sankhani selo lopanda kanthu, onjezani maselo mmenemo ndi nthawi yodalirika komanso mtengo wapakati.

4. Kuti mudziwe malire akumanzere, nthawi yodalirika iyenera kuchotsedwa pakutanthauza.

5. Timagwiranso ntchito zomwezo ndi nthawi yodalirika ya Wophunzirayo. Zotsatira zake, timapeza malire a nthawiyi mumitundu iwiri.

Kutsiliza

"Function Manager" ya Excel imapangitsa kuti zikhale zosavuta kupeza nthawi yodalirika. Ikhoza kutsimikiziridwa m'njira ziwiri, zomwe zimagwiritsa ntchito njira zosiyanasiyana zowerengera.