Binciken sakewa shine ɗayan shahararrun hanyoyin binciken ƙididdiga. Tare da taimakonsa yana yiwuwa a tsayar da matsayin rinjayar adadin masu 'yanci kan canjin dogaro. Ayyukan Microsoft Excel yana da kayan aikin da aka tsara don aiwatar da wannan nau'in bincike. Bari mu bincika menene kuma yadda ake amfani dasu.
Kunshin tantancewar haɗi
Amma, don amfani da aikin da ke ba ku damar gudanar da bincike game da tayar da hankali, da farko, kuna buƙatar kunna Kunshin Nazarin. Kawai sai kayan aikin da ake buƙata don wannan hanya zasu bayyana akan tef ɗin Excel.
- Matsa zuwa shafin Fayiloli.
- Je zuwa sashin "Zaɓuɓɓuka".
- Taga zabin na Excel yana buɗewa. Je zuwa sashin yanki "Karin abubuwa".
- A cikin ɓangaren ƙananan taga wanda ke buɗe, sake shirya sauyawa a cikin toshe "Gudanarwa" a matsayi Addara Add-insidan yana cikin wani yanayi na daban. Latsa maballin Je zuwa.
- Tace akwai wadatar add-ins dinda ke buɗe. Duba akwatin kusa da Kunshin Nazarin. Latsa maɓallin "Ok".
Yanzu idan muka je shafin "Bayanai"a kan kintinkiri a cikin akwatin kayan aiki "Bincike" za mu ga sabon maballin - "Nazarin Bayanai".
Iri Nazarin Juyin Halita
Akwai nau'ikan rajista:
- na misali;
- kaffara;
- logarithmic;
- karin bayani
- m
- magana
- juyayin layi.
Za muyi magana game da aiwatar da dabarun ƙarshe na tashin hankali a cikin Excel.
Koma bayan layi a cikin Excel
A ƙasa, a matsayin misali, an gabatar da tebur wanda ke nuna matsakaicin iska mai zafi a rana, da yawan masu siyayya don ranar aiki mai dacewa. Bari mu gano ta yin amfani da bincike game da rikice-rikice yadda daidai yanayin yanayi a cikin yanayin yanayin zafin iska zai iya shafar halartar ƙungiyar kasuwanci.
Babban lissafin rikice-rikicen layin ƙasa kamar haka:Y = a0 + a1x1 + ... + akhk. A cikin wannan dabara Y yana nufin canji, rinjayar abubuwan da muke ƙoƙarin nazarin su. A cikin lamarinmu, wannan shine adadin masu siyarwa. Daraja x sune abubuwanda suke haifar da canji. Sigogi a su ne masu tayar da hankali. Wannan shine, su ne suke yanke shawarar mahimmancin ɗaya ko wani abu. Index k yana nuna jimlar adadin waɗannan dalilai iri ɗaya.
- Latsa maballin "Nazarin Bayanai". An sanya shi a cikin shafin. "Gida" a cikin akwatin kayan aiki "Bincike".
- Wani karamin taga yana budewa. A ciki, zaɓi abu "Juyowa". Latsa maballin "Ok".
- Takaitaccen tsarin saiti zai buɗe. Filayen da ake buƙata a ciki sune "Hanyar shigowa ta Y" da "Hanyar Shiga Cikin Saiti X". Duk sauran saitunan za a iya barin ta tsohuwa.
A fagen "Hanyar shigowa ta Y" saka adireshin sel tsararraki inda aka canza maɓallin bayanai, tasirin abubuwan da muke ƙoƙarin kafawa. A cikin lamarinmu, waɗannan za su zama sel ɗin shafi "Yawan abokan ciniki". Za'a iya shigar da adireshin da hannu daga maballin, ko kuma zaku iya zabi shafin da ake so. Zaɓin na ƙarshen ya fi sauƙi kuma ya fi dacewa.
A fagen "Hanyar Shiga Cikin Saiti X" muna shigar da adireshin zangon wayar inda bayanan mahimmancin wanda tasirin sa akan m da muke son saita samu. Kamar yadda aka ambata a sama, muna buƙatar kafa tasirin zafin jiki akan yawan kwastomomin kantin, sabili da haka shigar da adireshin sel a cikin "Zazzabi". Ana iya yin wannan ta hanyoyi guda ɗaya kamar a filin "Yawan abokan ciniki".
Ta amfani da wasu saitunan, zaku iya saita lambobi, matakin dogaro, baƙon dindindin, nuna jadawalin yiwuwar aiki na yau da kullun, da aiwatar da wasu ayyuka. Amma, a mafi yawan lokuta, waɗannan saitunan ba sa buƙatar canza su. Abinda yakamata ku kula dashi shine sigogin kayan fitarwa. Ta hanyar tsoho, ana nuna sakamakon bincike akan wani takarda, amma ta hanyar sauya juyawa, zaku iya saita kayan fitarwa a cikin takaddara takamaiman akan teburin tare da bayanan asalin, ko a cikin wani littafi daban, wato a cikin sabon fayil.
Bayan an saita dukkan saiti, danna maballin "Ok".
Nazarin bincike
Sakamakon nazarin rikice-rikice an nuna shi a cikin nau'i na tebur a wurin da aka ƙayyade a cikin saitunan.
Daya daga cikin manyan alamomin shine R-squared. Yana nuna ingancin samfurin. A cikin lamarinmu, wannan coefficient shine 0.705 ko kusan 70.5%. Wannan matakin ingantacce ne na inganci. Dogaro da ƙasa da 0.5 ba shi da kyau.
Wani mahimmancin nuni yana kasancewa a cikin tantanin halitta a tsakiyar shinge. Y rarrabawa da shafi Tsokaci. Yana nuna ƙimar Y za ta samu, kuma a cikin yanayinmu, wannan shine adadin abokan cinikin, tare da duk sauran dalilai daidai yake da sifili. A cikin wannan tebur, wannan darajar ita ce 58.04.
Darajar a karkatar da hoto Canja-ware X1 da Tsokaci yana nuna matakin dogara da Y a kan X. A halinmu, wannan shine matakin dogaro da yawan abokan cinikin shagon akan zazzabi. Coefficient 1.31 ana ɗauka mafi girman nuna alama mai tasiri.
Kamar yadda kake gani, ta amfani da shirin Microsoft Excel, abu ne mai sauki a hada tebur na binciken tashin hankali. Amma, kawai wanda aka horar ne kawai zai iya aiki tare da bayanan da aka karɓa a fitarwa, kuma fahimtar asalinsu.
