Tattaunawa ta yanke shawara shine daya daga cikin hanyoyin da ake buƙata na binciken bincike. Tare da shi, zaka iya saita darajar rinjayar masu rarraba masu zaman kansu a kan ƙimar dogara. Microsoft Excel na da kayan aiki don yin irin wannan bincike. Bari mu dubi abin da suke da kuma yadda za'a yi amfani da su.
Ra'ayin Tattaunawa ta Connection
Amma, don amfani da aikin da zai ba da damar yin nazari na regression, da farko, kana buƙatar kunna Logic Analysis. Sai kawai kayan aikin da ake buƙatar don wannan hanya zai bayyana a kan tef ɗin Excel.
- Matsa zuwa shafin "Fayil".
- Je zuwa sashen "Zabuka".
- Zaɓin zaɓi na Excel ya buɗe. Je zuwa sashi na sashe Ƙara-kan.
- A kasan taga wanda ya buɗe, sake sake canzawa a cikin toshe "Gudanarwa" a matsayi Ƙara Add-insidan yana cikin wani wuri daban. Muna danna maɓallin "Ku tafi".
- Ƙungiyar ƙarawa ta Excel ta buɗe. Saka alamar kusa da abu "Shirye-shiryen Bincike". Danna maballin "OK".
Yanzu idan muka je shafin "Bayanan", a kan tef a cikin wani akwati na kayan aiki "Analysis" za mu ga sabon button - "Tasirin Bayanan Bayanai".
Ra'ayin nazarin ƙwaƙwalwa
Akwai nau'o'in regressions da dama:
- alal misali;
- ikon;
- logarithmic;
- Magana;
- Alamar nunawa;
- hyperbolic;
- lalata rikici.
Za muyi karin bayani game da aiwatar da tsarin bincike na karshe a cikin Excel.
Ƙaddamarwa na Linear a Excel
A ƙasa, alal misali, an gabatar da tebur wanda ya nuna yawan yawan iska a yau da kullum, da yawan masu saye kantin sayar da kwangila don kwanan wata aiki. Bari mu gano tare da taimakon nazarin rikici, yadda yanayin yanayin yanayi a cikin yanayin zazzabi na iska zai iya rinjayar kasancewarsa a cibiyar kasuwanci.
Ƙididdigar juyawa na nau'i na nau'in linzamin kwamfuta kamar haka:Y = a0 + a1x1 + ... + akhk. A wannan tsari Y yana nufin m, rinjayar abubuwan da muke ƙoƙari muyi nazarin. A cikin yanayinmu, wannan ita ce yawan masu sayarwa. Ma'ana x - wadannan abubuwa ne daban-daban da suka shafi m. Sigogi a su ne masu haɓaka kullun. Wato, sun ƙayyade muhimmancin wani matsala. Index k yana nuna yawan adadin waɗannan dalilai.
- Danna maballin "Tasirin Bayanan Bayanai". An sanya shi a cikin shafin. "Gida" a cikin asalin kayan aiki "Analysis".
- Ƙananan taga yana buɗe. A ciki, zaɓi abu "Tsarin". Muna danna maɓallin "Ok".
- Ƙungiyar saiti na ƙwaƙwalwa yana buɗewa. A ciki, filayen da ake buƙata suna "Yunkurin shigarwa Y" kuma "Zangon shigarwa X". Duk sauran saituna za a iya barin azaman tsoho.
A cikin filin "Yunkurin shigarwa Y" mun saka adireshin da kewayon kwayoyin inda aka samo bayanan mai sauƙi, tasirin abubuwan da muke ƙoƙarin kafa. A cikin yanayinmu, waɗannan za su kasance sassan cikin "Kayan masu sayarwa". Za a iya shigar da adireshin da hannu daga keyboard, ko za a iya zaɓar mahallin da aka so. Zaɓin na ƙarshe yana da sauki kuma mafi dacewa.
A cikin filin "Zangon shigarwa X" shigar da adireshin da kewayon kwayoyin halitta inda bayanai na factor, tasirin abin da akan madadin da muke son kafawa, yana samuwa. Kamar yadda aka ambata a sama, muna buƙatar ƙayyade tasirin zafin jiki a kan yawan abokan ciniki a cikin shagon, sabili da haka shigar da adireshin sel a cikin shafi "Tsawan". Ana iya yin hakan a daidai wannan hanya kamar a cikin "Number of buyers" filin.
Tare da taimakon wasu saitunan, za ka iya saita takardu, matakin daidaitaccen, m-zero, nuna hoto na yiwuwar al'ada, da kuma yin wasu ayyuka. Amma, a mafi yawan lokuta, waɗannan saitunan ba sa bukatar canzawa. Abinda ya kamata ka kula shi ne sigogin kayan aiki. Ta hanyar tsoho, sakamakon bincike yana fitowa akan wata takarda, amma ta hanyar sake sauya canjin, zaka iya saita fitarwa a cikin kewayon da aka keɓance a kan takarda ɗin ɗaya inda teburin da asalin asalin ya samo, ko a cikin wani littafin dabam, wato, a cikin sabon fayil.
Bayan an saita saitunan, danna kan maballin. "Ok".
Analysis na sakamakon bincike
Ana nuna sakamakon binciken da ake ciki a cikin nau'i a cikin wurin da aka nuna a cikin saitunan.
Ɗaya daga cikin alamomi masu mahimmanci shine R-squared. Yana nuna ingancin samfurin. A halinmu, wannan rabo shine 0.705, ko game da 70.5%. Wannan ƙira ce mai kyau. Dogaro kasa da 0.5 ba daidai ba ne.
Wani alama mai mahimmanci yana samuwa a cikin tantanin halitta a tsinkayyar layin. "Y-tsangwama" da kuma shafi Daidai. Ya nuna abin da darajar za ta kasance a cikin Y, kuma a cikin yanayinmu, wannan shine yawan masu sayarwa, tare da duk sauran dalilai daidai da nau'i. A wannan tebur, darajar wannan ita ce 58.04.
Darajar a tsakiyar tsinkayen jigilar "Gyara X1" kuma Daidai yana nuna matakin dogara da Y akan X. A cikin yanayinmu, wannan shine matakin dogara ga yawan abokan ciniki na kantin sayar da a kan yawan zafin jiki. An dauki nauyin tasiri na 1.31 a matsayin mai nuna alama mai tasiri.
Kamar yadda kake gani, ta hanyar amfani da Microsoft Excel yana da sauƙi don ƙirƙirar ladabi na ladabi. Amma, kawai wanda aka horar da kansa zai iya aiki tare da bayanan fitarwa, kuma ya fahimci ainihin su.
