Bayanin gyare-gyare - hanyar da ake amfani da shi na binciken bincike, wanda aka yi amfani dashi don gane ma'anar dogara da alamar alama ɗaya daga wani. Microsoft Excel yana da kayan aikin musamman wanda aka tsara don yin irin wannan bincike. Bari mu gano yadda za mu yi amfani da wannan alama.
Dalilin yin nazari
Dalilin yin hulɗa da juna shine gano ainihin dangantaka tsakanin dalilai daban-daban. Wato, an ƙayyade ko ragewa ko ƙarawa a alamar alama yana rinjayar canji a wani.
Idan an tabbatar da dogara, to, haɗin gwargwado ya ƙaddara. Ba kamar rikici ba, wannan shine kawai alamar cewa wannan tsarin bincike na lissafi ya kirga. Hakan daidaitawar jeri daga +1 zuwa -1. A gaban kasancewa mai kyau, haɓakawa a cikin alamar alama yana taimaka wa karuwa a na biyu. Tare da haɓakawa mara kyau, haɓakawa a alamar alama yana haɓaka wani. Mafi mahimmancin ma'auni na haɗin gwargwadon daidaitawa, ƙarin ganewa canji a alamar alama yana nunawa cikin canji a karo na biyu. Lokacin da mahaɗin yake 0, dangantakar tsakanin su bata gaba daya.
Ƙididdigar haɗin gwargwado
Yanzu bari muyi ƙoƙarin lissafin mahaɗin daidaitawa akan wani misali. Muna da tebur wanda aka biya a kowace wata a cikin ginshiƙai daban don tallafin tallace-tallace da tallace-tallace. Dole ne mu gano matakin da dogara ga yawan tallace-tallace a kan adadin kuɗin da aka kashe akan talla.
Hanyarka 1: Ƙayyade Hadakarwa ta Amfani da Wizard na Ginin
Ɗaya daga cikin hanyoyin da za'a iya yin nazarin daidaitawa shine amfani da aikin CORREL. Ayyukan kanta yana da ra'ayi na gaba. CORREL (array1; array2).
- Zaɓi tantanin halitta wadda za'a nuna sakamakon sakamakon lissafi. Danna maballin "Saka aiki"wanda yake a gefen hagu na tsari.
- A cikin jerin, wanda aka gabatar a cikin Wizard na Wurin Sanya, muna nema da kuma zaɓar aikin CORREL. Muna danna maɓallin "Ok".
- Ƙungiyar shawara ta buɗewa ta buɗe. A cikin filin "Massive1" shigar da daidaituwa na kewayon sel na ɗaya daga cikin dabi'un, wanda za'a dogara da shi. A cikin yanayinmu, waɗannan za su kasance dabi'u a cikin sashin "Tallace-tallace". Domin shiga adireshin mahaɗin a cikin filin, kawai zabi dukkanin kwayoyin da bayanai a cikin shafi na sama.
A cikin filin "Massiv2" kana buƙatar shigar da daidaitattun shafi na biyu. Muna da wannan farashin talla. Kamar yadda a cikin akwati na baya, mun shigar da bayanai a filin.
Muna danna maɓallin "Ok".
Kamar yadda kake gani, mahaɗin haɓakawa yana bayyana kamar lambar a cikin cell da aka zaɓa. A wannan yanayin, yana da daidai da 0.97, wanda shine babban alamomi na dogara akan ɗayan ɗaya a kan wani.
Hanyar 2: Ƙira Daidaitawa Ta Amfani da Tattalin Juyawa
Bugu da ƙari, ana iya ƙididdigewa ta amfani da ɗaya daga cikin kayan aikin da aka gabatar a cikin tsarin bincike. Amma da farko muna buƙatar kunna wannan kayan aiki.
- Jeka shafin "Fayil".
- A cikin taga wanda ya buɗe, koma zuwa sashe "Zabuka".
- Kusa, je zuwa maƙallin Ƙara-kan.
- A kasan taga na gaba a sashe "Gudanarwa" Swap da canza zuwa matsayi Ƙara Add-insidan yana cikin wani wuri daban. Muna danna maɓallin "Ok".
- A cikin akwatin ƙara-kan, duba akwatin kusa da abin. "Shirye-shiryen Bincike". Muna danna maɓallin "Ok".
- Bayan haka, ana kunna kunshin bincike. Jeka shafin "Bayanan". Kamar yadda muka gani, sabon kayan aiki na kayan aiki ya bayyana akan tef - "Analysis". Muna danna maɓallin "Tasirin Bayanan Bayanai"wanda aka samo a cikinta.
- Jerin yana buɗe tare da zaɓuɓɓukan zaɓin bayanai. Zaɓi abu "Daidaitawa". Danna maballin "Ok".
- Fitilar yana buɗewa tare da fasalin daidaitawa. Ba kamar hanyar da ta gabata ba, a filin "Lokacin shiga" mu shiga cikin lokaci ba kowane shafi ba ne, amma duk ginshiƙan da suke cikin bincike. A cikin yanayinmu, wannan shine bayanan a cikin "Tallalan Kuɗi" da "ginshiƙan Kasuwanci" ginshiƙai.
Alamar "Rukuni" bar canzawa - "Da ginshiƙai", tun da yake muna da ƙungiyoyin bayanai rarraba daidai cikin ginshiƙai guda biyu. Idan aka lalata layi ta layi, to lallai ya zama dole a sake shirya canji zuwa matsayin "A cikin layuka".
An saita zaɓin fitowar fitowar ta zuwa "Sabon Wurin Layi", wato, bayanan za a nuna a wata takarda. Zaka iya canja wuri ta hanyar motsiwa. Wannan zai iya zama takarda na yanzu (sa'an nan kuma kuna buƙatar saka adadin bayanan fitarwa) ko sabon littafin aiki (fayil).
Lokacin da aka saita duk saituna, danna maballin. "Ok".
Tun lokacin da aka samo asali na sakamakon binciken sakamakon tsoho, mun matsa zuwa sabon takardar. Kamar yadda kake gani, a nan shi ne haɗin daidaitawa. A al'ada, yana daidai da lokacin amfani da hanyar farko - 0.97. Wannan ya bayyana ta hanyar cewa duka zaɓuɓɓuka suna yin wannan lissafi, zaka iya sanya su cikin hanyoyi daban-daban.
Kamar yadda kake gani, aikace-aikacen Excel yana ba da hanyoyi guda biyu na daidaitawa. Sakamakon lissafi, idan kunyi duk abin da ke daidai, zai kasance daidai. Amma, kowane mai amfani zai iya zaɓar wani zaɓi mafi dace don aiwatar da lissafi.
