Hanyar ƙananan ƙananan hanyar hanya ce ta hanyar ilmin lissafi domin gina tsarin lissafin layi wanda zai fi dacewa da saitin layuka biyu na lambobi. Manufar wannan hanyar shine rage girman kuskuren kuskure. Excel na da kayan aiki don amfani da wannan hanyar don lissafi. Bari mu ga yadda aka yi hakan.
Amfani da hanyar a Excel
Hanyar ƙananan murabba'ai (OLS) shine bayanin ilmin ilmin lissafi na dogara da ɗayan ɗayan a kan na biyu. Ana iya amfani dasu a cikin tsinkaya.
Tsayar da "Mai Neman Magani" ƙarawa
Domin amfani da OLS a Excel, kana buƙatar kunna add-in "Bincika don bayani"wanda aka lalace ta hanyar tsoho.
- Jeka shafin "Fayil".
- Danna sunan sashen "Zabuka".
- A cikin taga wanda ya buɗe, dakatar da zaɓi a kan sashi Ƙara-kan.
- A cikin toshe "Gudanarwa"wanda yake a cikin ƙananan ɓangaren taga, saita canza zuwa matsayin Ƙara Add-ins (idan an saita wani darajar ta ciki) kuma latsa maballin "Ku tafi ...".
- Ƙananan taga yana buɗe. Mun sanya kaska a ciki game da saiti "Gano bayani". Muna danna maɓallin "Ok".
Yanzu aikin Gano bayani An kunna Excel, kuma kayan aikinsa sun bayyana akan tef.
Darasi: Nemo bayani a Excel
Yanayin matsalar
Mun bayyana yadda ake amfani da MNCs tare da misali. Muna da layuka biyu na lambobi x kuma y, wanda aka tsara a cikin hoton da ke ƙasa.
Mafi yawan wannan dogara zai iya bayyana aikin:
y = a + nx
A lokaci guda, an san cewa tare da x = 0 y Har ila yau, daidai yake 0. Saboda haka, wannan daidaitattun za a iya bayyana ta hanyar dogara y = nx.
Dole ne mu samo mintin mitoci na banbanci.
Magani
Bari mu ci gaba da kwatanta aikace-aikacen kai tsaye na hanyar.
- Hagu na darajar farko x sanya lambar 1. Wannan zai zama darajar kimanin darajar farko na mahaɗin. n.
- Don dama na shafi y ƙara ɗayan shafi - nx. A cikin sakon farko na wannan shafi, rubuta tsarin don ƙara yawan mahaɗin n a kan tsohuwar tantanin halitta x. A lokaci guda kuma, zamu yi magana da filin tare da cikakkiyar matsayi, tun da wannan darajar ba zai canza ba. Danna maballin Shigar.
- Amfani da alamar cika, kwafa wannan tsari zuwa dukan kewayon tebur a shafi na ƙasa.
- A cikin tantanin tantanin halitta, muna lissafin ƙididdigar bambance-bambance na wurare masu daraja. y kuma nx. Don yin wannan, danna maballin "Saka aiki".
- A bude "Ma'aikatar Ayyuka" neman rikodin "SUMMKVRAZN". Zaɓi shi kuma danna maballin. "Ok".
- Maganin gardama ya buɗe. A cikin filin "Array_x" shigar da tantanin salula na shafi y. A cikin filin "Array_y" shigar da tantanin salula na shafi nx. Domin shigar da dabi'un, kawai saita siginan kwamfuta a cikin filin kuma zaɓi hanyar da aka dace a kan takardar. Bayan shigar da danna akan maballin "Ok".
- Jeka shafin "Bayanan". A tef a cikin asalin kayan aiki "Analysis" danna maballin "Gano bayani".
- Ƙungiyar sigogi na wannan kayan aiki yana buɗewa. A cikin filin "Sanya Ayyukan Target" saka adireshin tantanin halitta tare da tsari "SUMMKVRAZN". A cikin saiti "Har sai" Tabbatar tabbatar da canza zuwa matsayi "Ƙananan". A cikin filin "Canji Kwayoyin" mun saka adireshin tare da darajar coefficient n. Muna danna maɓallin "Nemo bayani".
- Za a nuna mafita a cikin mahaɗin ƙira. n. Wannan darajar za ta kasance mafi girman ƙananan aikin. Idan sakamakon ya cika mai amfani, sannan danna maballin "Ok" a cikin ƙarin taga.
Kamar yadda muka gani, yin amfani da hanya mafi ƙanƙanci a cikin mitoci hanya ce mai rikitarwa. Mun nuna shi cikin aiki tare da misali mafi sauki, kuma akwai wasu lokuta da yawa masu rikitarwa. Duk da haka, an tsara kayan aikin Microsoft na Excel don sauƙaƙe lissafin da aka yi kamar yadda ya yiwu.
