Trust zvikamu muna Excel

Mumwe nzira kuti matambudziko Statistical ndiye kukarukureta kwokuvimba penguva. Rinoshandiswa senzira zvakawanda vaida nzira yacho kufungidzira duku zvakabudiswa. Zvinofanira kucherechedzwa kuti muitiro pakuverenga nechivimbo penguva iri nani kuoma. Asi zvishandiso Excel purogiramu vachikubvumira nyore nyore nayo. Ngationei kuti sei zvinoitwa uchidzidzira.

Method 2: Shandisai kuvimbana.

Uyezve, pane chimwe chinhu kuti chokuita kukarukureta kwokuvimba penguva - kuvimbana. Chaioneka, chete kutangira Excel 2010. opareta iyi anoita kukarukureta ari vakawanda vanogara chivimbo penguva kushandisa kuparadzirwa Wemudzidzi. Zviri nyore chaizvo kushandisa kana vakapararira uye, naizvozvovo, mureza kutsauka harizivikanwi. The nemarongerwo ari opareta ndiko:

= Nechivimbo .styudient (Alpha; standard_otchal; saizi)

Sezvatinoona, mazita dzaishandisa uye iyi kumbochinja.

Ngationei kuti kuverenga miganhu nechivimbo penguva pamwe isingazivikanwi mureza kutsauka muenzaniso iwoyo raora kuti zvatakurukura yapfuura nzira. Padanho chivimbo, sezvo yokupedzisira, tora 97%.

1. Tinotaura sero iyo kukarukureta vachaitwa. Dope "Insert basa" bhatani.



2. Mune uchishandisa muuki pakati mashandiro, enda category "Statistical". Sarudzai zita "ruvimbo. Student". Ivhu pane "ok" bhatani.



3. Mibvunzo yacho chaiyo worunhare wacho nenharo dziri kwakatangwa.

   In Arifa munda, vakapiwa kuti padanho chivimbo ndiyo 97%, kunyora nhamba 0,03. The kechipiri iri zviga kukarukureta pamusoro parameter ino kwete kurega.

   Pashure paizvozvo, akaisa cursor mu "Standard kutsauka" munda. nguva ino chakarurama izvi asingazivikanwe uye kunodiwa kuverenga nayo. Izvi zvinoitwa kushandisa chaiyo basa - Standotclone. Kudana pawindo opareta ichi, tinya Triangle kuruboshwe yacho fomura tambo. Kana musingadi kuwana aida zita iri pasi kuti anovhura, ipapo uende kuburikidza "Mamwe mabasa ...".



4. The mabasa mukudzidzire kunotangira. We kutamira category "Statistical" uye katsamba mairi zita "Standotclona.B". Zvadaro dope "OK" bhatani.



5. Iyo hwindo rekupokana rinovhura. Basa vomureza Standotclone opareta. Ndiyo tsanangudzo mureza kutsauka panguva mharidzo. nemarongerwo Its anotarisa seizvi:

   = Kumiraclonal.v (nhamba1; nhamba2; ...)

   Zviri nyore kuti zvokufungidzira kuti "nhamba" nharo ndiye kero dzokuenzanisira maatomu akafanana. Kana mharidzo anoiswa chimwe chete siyana, zvino iwe unogona, uchishandisa imwe chete nharo, kupa link ku siyana ichi.

   Kuisa cursor mu "Number1" munda uye, sezvo nguva dzose, vachibatirira kuruboshwe mbeva bhatani, isu govera akatara. Mushure Coordinates yarova munda, regai kumhanyira kuti achizviendesa "OK" bhatani, sezvo tichava kururama. Vaimbove, tinofanira kudzokera worunhare wacho nenharo hwindo kuvimba. Student kuti rokupedzisira nharo. Nokuti ichi, tinya zita rakakodzera iri nzira mutsara.



6. The nharo hwindo anotsiviwa zvakare. Kuisa cursor mu "Size" munda. Zvakare, tinya Triangle kare zvaizivikanwa kwatiri kuenda kusarudzwa dzaishandisa. Sezvaunoramba kunzwisisa, tinoda zita "Account". Sezvo taishandisa chikamu ichi apo pakuverenga muzvirevo nzira, hazvina chipo pazvinhu izvi, saka chete tinya pamusoro payo. Kana musingadi kuona izvozvo, ipapo kuita maererano algorithm anorondedzerwa nzira yokutanga.



7. Mushure anorova nharo hwindo, tinoisa cursor mu "Number1" munda uye ane clamping mbeva bhatani, tinotaura akatara. Zvadaro dope "OK" bhatani.



8. Pashure paizvozvo, chirongwa kunoita kuverenga uye anoratidza kukosha chivimbo penguva.



9. Kuti uone miganhu, tichada zvakare kuverenga avhareji mharidzo ukoshi. Asi, apa ndechokuti kuverenga algorithm tichibatsirwa kuti nzira kwakafanana muzvirevo nzira, uye kunyange ane mugumisiro handishanduki, isu hatingazvirumbidzi kurega zvakadzama rwechipiri.



10. Apedza kusika migumisiro dzemaitirwe pamusoro SRVNAH uye kuvimbana. The detector, isu tiwane pamuganhu rworudyi chivimbo penguva.



11. Related kubva pamigumisiro dzemaitirwe ari opareta, mugumisiro dzemaitirwe ari kuverenga iri kuvimbwa. The detector, tine muganhu chivimbo penguva rworuboshwe.



12. Kana kuverenga ndiko kunyora pasi pamwe chete wevacheche, ipapo kukarukureta muganhu zvakarurama kwatiri vachatarira seizvi:

    = SRNAVOV (B2: B13) + chivimbo .styudient (0.03; Standotclonal.V (B2: B13); mamakisi (B2: B13))



13. Nokudaro, nzira kuti pakuverenga muganhu kuruboshwe achatarira seizvi:

    = SRNAVOV (B2: B13) - Essential.styudent (0.03; Standotclonal.V (B2: B13); nhoroondo (B2: B13))

Sezvauri kuona, maturusi aExcel anogonesa kuganhurisa kuverenga kwechivimbiso uye miganhu yayo. Kune izvi zvinangwa, vashandisi vega vanoshandiswa kune samples, umo kupararira kunozivikanwa uye kusingazivikanwe.