Misali na yin nazarin daidaituwa a cikin Excel

Ɗaya daga cikin hanyoyin da aka fi amfani da su a cikin ƙididdiga don nazarin bayanai shine nazarin daidaituwa, wanda za'a iya amfani dashi don tantance tasirin wani adadi akan wani. Bari mu ga yadda za a iya yin wannan bincike a cikin Excel.

Manufar nazarin daidaituwa

Binciken daidaitawa yana ba ku damar nemo dogara da mai nuna alama akan wani, kuma idan an samo shi, lissafta daidaito (digiri na dangantaka), wanda zai iya ɗaukar dabi'u daga -1 zuwa +1:

• idan ma'auni ya kasance mara kyau, dogara ya bambanta, watau karuwar darajar ɗaya yana haifar da raguwa a ɗayan kuma akasin haka.
• idan ƙididdiga ta tabbata, dogara kai tsaye ne, watau karuwa a cikin alama ɗaya yana haifar da karuwa a cikin na biyu kuma akasin haka.

Ƙarfin dogara yana ƙaddara ta hanyar ma'auni na haɗin haɗin kai. Girman darajar, mafi ƙarfin canji a cikin ƙimar ɗaya yana rinjayar ɗayan. Bisa ga wannan, tare da sifili coefficient, ana iya jayayya cewa babu dangantaka.

Yin nazarin alaƙa

Don koyo da ƙarin fahimtar nazarin alaƙa, bari mu gwada shi don teburin da ke ƙasa.

Anan akwai bayanai akan matsakaicin zafin rana da matsakaicin zafi na watannin shekara. Ayyukanmu shine gano ko akwai dangantaka tsakanin waɗannan sigogi kuma, idan haka ne, yaya ƙarfi.

Hanyar 1: Aiwatar da Ayyukan CORREL

Excel yana ba da aiki na musamman wanda ke ba ku damar yin nazarin haɗin gwiwa - CORREL. Tsarinsa yayi kama da haka:

КОРРЕЛ(массив1;массив2).

Hanyar yin aiki tare da wannan kayan aiki shine kamar haka:

1. Mun tashi a cikin tantanin halitta kyauta na tebur wanda a cikinsa muke shirin ƙididdige ma'auni na daidaituwa. Sannan danna gunkin "fx (Saka aikin)" zuwa hagu na mashayin dabara.
2. A cikin taga shigar aikin da aka buɗe, zaɓi nau'i "Kididdiga" (ko "Cikakken jerin haruffa"), Daga cikin zaɓuɓɓukan da aka gabatar mun lura "CORREL" kuma danna OK.
3. Za a nuna taga gardamar ayyuka akan allon tare da siginan kwamfuta a filin farko akasin haka "Array 1". Anan muna nuna daidaitawar sel na ginshiƙi na farko (ba tare da taken tebur ba), bayanan waɗanda ke buƙatar bincika (a cikin yanayinmu, B2: b13). Kuna iya yin haka da hannu ta hanyar buga haruffan da ake so ta amfani da madannai. Hakanan zaka iya zaɓar kewayon da ake buƙata kai tsaye a cikin tebur kanta ta hanyar riƙe maɓallin linzamin kwamfuta na hagu. Sa'an nan kuma mu matsa zuwa hujja ta biyu "Arraya 2", kawai ta danna cikin filin da ya dace ko ta danna maɓallin tab. Anan muna nuna daidaitawar kewayon sel na shafi na biyu da aka bincika (a cikin teburin mu, wannan shine ku: ku2). Danna lokacin da aka shirya OK.
4. Muna samun ma'aunin daidaitawa a cikin tantanin halitta tare da aikin. Ma'ana "-0,63" yana nuna alaƙa mai ƙarfi tsaka-tsaki tsakanin bayanan da aka bincika.

Hanyar 2: Yi amfani da "Analysis Toolkit"

Wata hanyar da za a bi don yin nazarin haɗin gwiwa ita ce amfani "Nazarin Kunshin", wanda dole ne a fara kunna shi. Don wannan:

1. Je zuwa menu "Fayil".
2. Zaɓi abu daga lissafin hagu "Parameters".
3. A cikin taga da ya bayyana, danna kan ƙaramin sashe Addara ". Sa'an nan kuma a gefen dama na taga a kasa sosai don ma'auni "Sarrafa" zabi "Excel add-ins" kuma danna "Tafi".
4. A cikin taga da ke buɗewa, yi alama "Kunshin Nazari" kuma tabbatar da aikin ta latsa maɓallin OK.

An shirya komai, "Kunshin Nazari" kunnawa. Yanzu za mu iya ci gaba zuwa babban aikinmu:

1. Tura maballin "Nazarin bayanai", wanda ke cikin shafin "Bayanai".
2. Taga zai bayyana tare da jerin zaɓuɓɓukan bincike da ake da su. Muna murna "Daidaitawa" kuma danna OK.
3. Wani taga zai bayyana akan allon wanda dole ne ka ƙayyade sigogi masu zuwa:
   • "Tazarar shigarwa". Muna zaɓar duka kewayon sel da aka bincika (wato, duka ginshiƙai a lokaci ɗaya, kuma ba ɗaya lokaci ɗaya ba, kamar yadda aka yi a hanyar da aka bayyana a sama).
   • "Rukunin rukuni". Akwai zaɓuɓɓuka guda biyu don zaɓar daga: ta ginshiƙai da layuka. A cikin yanayinmu, zaɓi na farko ya dace, saboda. wannan shine yadda bayanan da aka bincika suke a cikin tebur. Idan an haɗa kanun labarai a cikin kewayon da aka zaɓa, duba akwatin kusa "Labels a layin farko".
   • "Zaɓuɓɓukan fitarwa". Kuna iya zaɓar zaɓi "Fita tazara", a wannan yanayin za a shigar da sakamakon binciken a kan takarda na yanzu (zaka buƙaci ka ƙayyade adireshin tantanin halitta wanda za a nuna sakamakon). Hakanan ana ba da shawarar nuna sakamakon akan sabon takarda ko a cikin sabon littafi (za a saka bayanan a farkon farkon, watau farawa daga tantanin halitta. (A1). A matsayin misali, mun bar "Sabon Taskar Aiki" (wanda aka zaba ta tsohuwa).
   • Lokacin da komai ya shirya, danna OK.
4. Muna samun daidaitattun daidaito kamar yadda aka yi a hanya ta farko. Wannan yana nuna cewa a cikin duka biyun mun yi komai daidai.

Kammalawa

Don haka, yin nazarin haɗin gwiwa a cikin Excel hanya ce mai sarrafa kanta da sauƙi kuma mai sauƙin koya. Duk abin da kuke buƙatar sani shine inda zaku samu da yadda ake saita kayan aikin da ake buƙata, kuma a cikin yanayin "kunshin mafita", yadda ake kunna shi, idan kafin haka ba a riga an kunna shi a cikin saitunan shirin ba.