Mafi ƙarancin hanyoyin murabba'ai shine hanya don lissafi don ƙirƙirar daidaituwa ta layi wanda zai fi dacewa da tsarin lambobi biyu. Dalilin amfani da wannan hanyar shine rage ƙarancin kuskure. Excel yana da kayan aikin da zaku iya amfani da wannan hanyar a cikin lissafin ku. Bari mu ga yadda ake yin hakan.
Yin amfani da hanyar a Excel
Leastaramar hanyar murabba'ai (aƙalla murabba'ai) bayanin lissafi ne game da dogaro da mai lamba ɗaya akan ta biyu. Ana iya amfani dashi a cikin annabta.
Inganta Searchara Binciken Magani na Magani
Don amfani da OLS a cikin Excel, kuna buƙatar kunna ƙarin-ciki “Neman mafita”wanda aka kunna ta tsohuwa.
- Je zuwa shafin Fayiloli.
- Danna sunan sashen "Zaɓuɓɓuka".
- A cikin taga da ke buɗe, dakatar da zaɓin akan sashin yanki "Karin abubuwa".
- A toshe "Gudanarwa"located a gindin taga, saita sauya zuwa Addara Add-ins (idan aka saita wata ƙima a ciki) kuma danna maɓallin "Ku tafi ...".
- Wani karamin taga yana budewa. Sanya kaska a ciki kusa da sigar "Neman mafita". Latsa maballin "Ok".
Aiki yanzu Nemi mafita kunna a cikin Excel, kuma kayan aikinta sun bayyana akan kintinkiri.
Darasi: Neman mafita a cikin Excel
Yanayin aiki
Mun bayyana yadda ake amfani da OLS akan wani takamaiman misali. Muna da layuka lambobi biyu x da ywanda aka nuna jerinsa a hoton da ke ƙasa.
Aikin zai iya bayyana wannan dogarowar ta daidai:
y = a + nx
Haka kuma, an san cewa tare da x = 0 y kuma daidai yake 0. Saboda haka, ana iya bayyana wannan lissafin ta hanyar dogaro y = nx.
Dole ne mu sami mafi ƙarancin murabba'ai na bambanci.
Magani
Mun juya zuwa bayanin kwatancen kai tsaye na hanyar.
- A hagu na ƙimar farko x sanya lamba 1. Wannan zai zama kimanin kimar darajar farkon mai amfani n.
- A hannun dama na shafi y kara wani shafi - nx. A farkon sashin farko na wannan takarda, mun yi rubutu da tsari mai sauƙaƙawa n kowace sel na farkon m x. A lokaci guda, muna yin hanyar haɗi zuwa filin tare da cikakke cikakke, tunda wannan ƙimar ba za ta canza ba. Latsa maballin Shigar.
- Yin amfani da alamar cikawa, kwafa wannan dabara zuwa gaukacin teburin da ke ƙasa.
- A cikin wata sel daban, muna lissafin jimlar bambance-bambance na murabba'ai na dabi'u y da nx. Don yin wannan, danna maballin "Saka aikin".
- A cikin bude "Mataimakin Aiki" neman rakodi SUMMKVRAZN. Zaɓi shi kuma danna maballin. "Ok".
- Tattaunawa ta buɗe tana buɗewa. A fagen "Array_x" shigar da kewayon sel sel y. A fagen Array_y shigar da kewayon sel sel nx. Don shigar da ƙimomin, kawai muna sanya siginan kwamfuta a cikin filin kuma zaɓi kewayon m a kan takardar. Bayan kun shiga, danna maɓallin "Ok".
- Je zuwa shafin "Bayanai". A kan kintinkiri a cikin akwatin kayan aiki "Bincike" danna maballin "Neman mafita".
- Zaɓuɓɓukan taga wannan kayan aiki yana buɗewa. A fagen "Inganta aikin na gaba" saka adireshin tantanin halitta tare da dabara SUMMKVRAZN. A cikin siga "Zuwa" Tabbatar sanya madaidaicin a wuri "Karami". A fagen "Canza sel" saka adireshin tare da mai amfani n. Latsa maballin "Nemi mafita".
- Maganin za a nuna a cikin coefficient tantanin halitta n. Yana da wannan darajar zata zama mafi girman murabba'in aikin. Idan sakamakon ya gamsar da mai amfani, to sai a danna maballin "Ok" a cikin wani ƙarin taga.
Kamar yadda kake gani, aikace-aikacen ƙananan hanyoyin murabba'I hanya ce mai wahalar lissafi. Mun nuna shi a aikace tare da mafi kyawun misali, kuma akwai kararraki masu rikitarwa. Koyaya, an tsara kayan aikin Microsoft Excel don sauƙaƙe ƙididdigar gwargwadon iko.
