Bincike na Sweets yana daya daga cikin hanyoyin da aka nema na bincike na ilimin lissafi. Tare da shi, yana yiwuwa a kafa matakin tasirin ƙimar abubuwa masu zaman kansu a kan dogaro mai canzawa. Microsoft mai inganci yana da kayan aikin da aka yi niyya don irin nau'in bincike. Bari mu bincika cewa sun wakilci kansu da yadda za su yi amfani da su.
Haɗa kunshin nazarin
Amma, don amfani da aikin da zai ba ka damar bincika subareity, da farko, kuna buƙatar kunna kunshin nazarin. Kawai to, kayan aikin da ake buƙata don wannan hanyar za ta bayyana a kan tef ɗin hijira.
- Matsar cikin shafin "Fayil".
- Je zuwa sashen "sigogi".
- Ganawa na Excel ya buɗe. Je zuwa Subsection "Addestuction".
- A kasan taga bude, muna sake shirya canzawa a cikin "sarrafawa" Add-a cikin "Excel add-a" m, m, idan yana cikin wani matsayi. Danna maballin "Go button".
- Bude taga dama ga Superstructure. Mun sanya kaska game da kayan "kunshin". Latsa maɓallin "Ok".
Yanzu, lokacin da muka ƙaura zuwa shafin "bayanai", za mu ga kayan aiki a cikin "Bincike" maɓallin "na Bincike.
Iri na Binciken Prasses
Akwai nau'ikan regressions da yawa:- parabolic;
- iko;
- logarithmic;
- Fadada;
- nuni;
- hyperbolic;
- Linear tawaye.
Za mu yi magana game da aiwatar da nau'in nau'in na ƙarshe na bincike na ƙarshe a cikin ƙari.
Lindar Lindar a cikin shirin Excel
A ƙasa, a matsayin misali, an gabatar da tebur a cikin abin da matsakaita yawan zafin jiki na yau da kullun akan titi, da adadin masu siyarwar shagon da suka dace ana nuna su. Bari mu gano tare da taimakon masu bincike na rarrabuwa, daidai yadda yanayin yanayi a cikin nau'in yawan zafin iska zai iya shafan halartar kasuwancin kasuwanci.
Babban daidaituwa na tashin mahimmancin nau'in nau'in layi kamar haka: Y = A0 + A1x1 + ... + akk. A cikin wannan dabara, y yana nufin m, tasirin dalilan da muke ƙoƙarin bincika. A cikin lamarinmu, wannan shine adadin masu sayayya. Darajar X ingantattun dalilai ne suka shafi mai canzawa. Sigogi a kai masu kaifi ne masu ƙarfi. Wato, shi ne wanda ke tantance muhimmancin wani abu. Index K nuna adadin waɗannan abubuwan.
- Latsa maɓallin bincike na "na". An sanya shi a cikin shafin gida a cikin "Bincike" kayan aiki.
- Karamin taga yana buɗewa. A ciki, mun zabi abun "juyo". Latsa maɓallin "Ok".
- Goge saiti Saitunan yana buɗewa. Wajibi ne ga cikar filayen shine "shigarwar Infutwira Y" da "shigarwar Inpent X". Duk sauran saitunan za a iya barin saith.
A cikin "Inputlt Inface tazarar Y" filin, saka adireshin da kewayon sel inda masu canji suke, sakamakon abubuwan da muke ƙoƙarin kafa su. A cikin lamarinmu, wadannan zasu zama sel na "yawan masu sayen" shafi. Adireshin za a iya shigar da hannu daga maɓallin maɓallin, kuma zaku iya zaɓar shafi da ake so. Zabi na ƙarshe yana da sauƙi kuma mafi dacewa.
A cikin "Input tazarar X" filin, za mu shigar da adireshin sel na sel, inda waɗannan maganganun yake, wanda tasirin da muke so ya kafada. Kamar yadda aka ambata a sama, muna buƙatar kafa tasirin rage zafin jiki akan adadin masu sel na shago, sabili da haka shigar da adireshin sel a cikin "zazzabi". Wannan za a iya yin hanyoyi guda ɗaya kamar yadda a cikin "yawan masu sayayya".
Yin amfani da wasu saitunan, zaku iya saita lakabi, matakin aminci, akai ga sifili, nuna wasu abubuwan da ake buƙata. Amma, a mafi yawan lokuta, waɗannan saitunan ba sa bukatar a canza su. Abinda kawai zai kula da shi shine sigogin fitarwa. Ta hanyar tsoho, fitowar sakamakon bincike ana yin ta hanyar wani takarda, amma yana sake canzawa, zaku iya saita fitarwa a cikin takardar da aka ƙayyade a kan takardar da aka ƙayyade tare da bayanan da aka ƙayyade tare da keɓaɓɓun bayanan, ko a cikin wani yanki. Wato, a cikin sabon fayil.
Bayan an saita kowane saiti, danna maɓallin "Ok".
Bincike game da sakamakon bincike
Sakamakon binciken na Sweetwararru yana nunawa a cikin hanyar tebur a cikin wurin da aka nuna a cikin saitunan.
Daya daga cikin manyan alamu shine R-murabba'i. Yana nuna ingancin samfurin. A cikin lamarinmu, wannan madaidaicin shine 0.705 ko kimanin kashi 70.5%. Wannan matakin ne da aka yarda dashi. Dogaro kasa da 0.5 ba shi da kyau.
Wani muhimmin mai nuna alama yana cikin tantanin halitta a cikin hanyar shiga maɓallin "Y-Cairation" da "coefps" shafi "shafi". Yana nuna menene darajar da ke cikin Y, kuma a lamarinmu, wannan shine adadin masu sayayya, tare da sauran dalilai daidai ne da sifili. Wannan tebur shine 58.04 a cikin wannan tebur.
Darajar a cikin hanyar shiga cikin ƙididdigar "m X1" da "coefficesss" yana nuna matakin dogaro na Y daga X. Wannan shine matakin dogaro da adadin abokan adawar akan zazzabi. Mafi kyawun 1.31 an ɗauka wani mai nuna girman gaske.
Kamar yadda kake gani, ta amfani da Microsoft Excel Shirin yana da sauƙin yin tebur na bincike na rarrabuwa. Amma, yin aiki tare da bayanan da aka samu a mafita, kuma fahimtar asalinsu, kawai wani mutum ne kawai zai iya.