Nazarin daidaituwa shine sananniyar hanyar ƙididdigar ƙididdiga, wanda ake amfani dashi don gano ƙimar dogara da alamomi ɗaya akan wani. Microsoft Excel yana da kayan aiki na musamman da aka tsara don aiwatar da wannan nau'in bincike. Bari mu gano yadda ake amfani da wannan fasalin.
Mahimmancin bincike mai ma'ana
Dalilin nazarin daidaituwa shine a gano kasancewar dogaro tsakanin abubuwa daban-daban. Wannan shine, an ƙaddara ko raguwa ko karuwa a cikin ɗaya nuna yana shafi canji a wani.
Idan an kafa dogaron dogaro, to ya zama yana da ma'anar daidaitawa. Ba kamar ƙididdigar tashin hankali ba, wannan shine kawai alamar cewa wannan hanyar ƙididdigar bincike ta ƙididdige shi. Ma'anar daidaitawa ta bambanta daga +1 zuwa -1. A gaban ingantaccen daidaituwa, haɓaka cikin alamomi guda ɗaya yana ba da gudummawa ga karuwa a na biyu. Tare da hulɗa mara kyau, haɓaka a cikin ɗaya nuna yana ƙaruwa a cikin wani. Mafi girma mafi mahimmancin daidaitawa na daidaitawa, mafi bayyane shine canji a cikin alamomi guda ɗaya yana shafar canjin a na biyu. Lokacin da coefficient ne 0, dogara a tsakanin su gaba daya ba ya nan.
Lissafi na daidaitawa mai aiki
Yanzu bari muyi kokarin lissafta coelation daidai ta amfani da takamaiman misali. Muna da tebur wanda a cikin lissafin farashin tallan wata da ƙimar tallace-tallace a cikin sassan rabe daban. Dole ne mu gano matsayin dogara da adadin tallace-tallace a kan adadin kuɗin da aka kashe akan talla.
Hanyar 1: ƙayyade hulɗa ta hanyar Mayen Aiki
Daya daga cikin hanyoyin da za'a aiwatar da bincike mai ma'ana shine amfani da aikin CORREL. Aikin da kansa yana da kallo gabaɗaya CORREL (array1; array2).
- Zaɓi wayar wanda acikin lissafin sakamako ya kamata a nuna shi. Latsa maballin "Saka aikin"wanda yake gefen hagu na dabarar dabara.
- A cikin jerin da aka gabatar a window na Aiki mai aiki, muna bincika kuma zaɓi aiki CORREL. Latsa maballin "Ok".
- Farashin muhawara na aiki zai bude. A fagen "Array1" shigar da daidaitawar kewayon tantanin halitta ɗayan dabi'u, abin dogaro wanda ya kamata ayi ƙaddara. A cikin yanayinmu, waɗannan za su zama dabi'u a cikin "Adadin tallace-tallace". Domin shigar da adireshin tsararru a cikin filin, za mu zaɓi kawai duk ƙwayoyin da bayanai a cikin shafi na sama.
A fagen Shirya2 kuna buƙatar shigar da daidaitawa na shafi na biyu. Muna da farashin wannan talla. Haka kuma kamar yadda yake a baya, mun shigar da bayanai a fagen.
Latsa maballin "Ok".
Kamar yadda kake gani, ma'anar daidaitawa a cikin hanyar lamba tana bayyana a cikin tantanin da aka zaɓa a baya. A wannan yanayin, 0.97 ne, wanda alama ce mai girma da ke nuna dogarowar adadin adadi a kan wani.
Hanyar 2: yin lissafi don amfani da kunshin bincike
Bugu da ƙari, za a iya lasafta ta amfani da ɗayan kayan aikin, wanda aka gabatar a cikin kunshin bincike. Amma da farko muna buƙatar kunna wannan kayan aiki.
- Je zuwa shafin Fayiloli.
- A cikin taga da ke buɗe, matsa zuwa ɓangaren "Zaɓuɓɓuka".
- Na gaba, je zuwa "Karin abubuwa".
- A kasan taga na gaba a sashin "Gudanarwa" matsar da canji zuwa wuri Addara Add-insidan yana cikin wani yanayi na daban. Latsa maballin "Ok".
- A cikin taga-add-kan, duba akwati kusa da Kunshin Nazarin. Latsa maballin "Ok".
- Bayan wannan, an kunna kunshin bincike. Je zuwa shafin "Bayanai". Kamar yadda kake gani, anan kan kaset ɗin sabon kayan aikin ya bayyana - "Bincike". Latsa maballin "Nazarin Bayanai"wanda yake a ciki.
- Jerin yana buɗewa tare da zaɓuɓɓuka daban-daban don nazarin bayanai. Zaɓi abu Daidaitawa. Latsa maballin "Ok".
- Taka taga yana buɗewa tare da sigogin bincike. Ba kamar hanyar da ta gabata ba, a fagen Tsarin Tsarin Input mun shigar da tazara ba kowane layi daban ba, amma na dukkan labulen da ke shiga cikin bincike. A cikin lamarinmu, wannan shine bayanan da ke cikin layin "Kudin Talla" da "Adadin Talla".
Matsayi "Rungumewa" bar canzawa - Harafi da shafi, tunda rukunin bayananmu sun kasu kashi biyu. Idan an karye su layi-layi, to yakamata a canza wurin zuwa wurin Yayi layi-layi.
A zaɓuɓɓukan fitarwa, an saita tsohuwar zuwa "Sabon takardar aiki", wato, za a nuna bayanan a kan wani takarda. Kuna iya canza wurin ta hanyar motsa maɓallin. Wannan na iya zama takarda na yanzu (sannan kuna buƙatar ƙayyade ayyukan daidaita bayanan kwayoyin halitta) ko sabon littafin aiki (fayil).
Lokacin da aka saita duk saitin, danna maɓallin "Ok".
Tun da wurin da aka haifar da sakamakon binciken bincike ta hanyar tsohuwa, muna matsa zuwa sabon takarda. Kamar yadda kake gani, ma'anar daidaitawa yana nuna anan. A zahiri, daidai yake da lokacin amfani da hanyar farko - 0.97. Wannan ya faru ne saboda gaskiyar cewa duka zaɓuɓɓuka suna yin lissafin iri ɗaya, ana iya yin su ta hanyoyi daban-daban.
Kamar yadda kake gani, aikace-aikacen Excel yana ba da hanyoyi guda biyu na nazarin daidaituwa lokaci guda. Sakamakon lissafin, idan kun yi komai daidai, zai zama daidai yake. Amma, kowane mai amfani zai iya zaɓar zaɓi mafi dacewa a gare shi don aiwatar da ƙididdigar.
