Mafi ƙarancin hanyar murabba'in murabba'i

Hanyar murabba'in murabba'ai aiki ne na lissafi don gina daidaituwa na layi, wanda zai dace sosai da saitin layuka biyu. Dalilin amfani da wannan hanyar shine rage jimlar kuskuren quadratic. Shirin Excel Shirin yana da kayan aikin da ake iya amfani da wannan hanyar lokacin da lissafi. Bari muyi amfani da yadda ake yi.

Amfani da hanyar a fice

Hanyar murabba'ai (MNC) bayanin ilmin lissafi ne na Dogaro da mai canzawa ɗaya daga na biyu. Ana iya amfani dashi lokacin da annabta.

Bayar da "Binciken Magani"

Don amfani da MNA a Fore Excel, kuna buƙatar kunna "bincike na bayani", wanda aka kashe ta tsohuwa.

1. Je zuwa shafin "fayil".



2. Danna kan sunan "sigogi" sashe.



3. A cikin taga da ke buɗe, dakatar da zaɓi akan maɓallin "add-in".



4. A cikin "Gudanar da" toshe, wanda yake a kasan taga, wanda saita sauyawa zuwa matsayin "Excel addit-a" FIcel addoes "saika saita) kuma danna ..." tafi ... "button.



5. Karamin taga yana buɗewa. Mun sanya a cikin sa a kusa da "search" siga. Latsa maɓallin "Ok".

Yanzu kayan aikin aikin da ake aiki a Excel, kuma kayan aikin ya bayyana a kan tef.

Darasi: Neman mafita a cikin excele

Yanayin matsalar

Mun bayyana amfani da MK akan takamaiman misali. Muna da layuka biyu na lambobi X. da y. Jerin abin da aka gabatar a hoton da ke ƙasa.

Mafi kyawun abin dogaro zai iya bayyana aikin:

y = + nx

A lokaci guda, an san cewa lokacin da x = 0. y. Ya kuma daidaita 0 . Saboda haka, wannan daidaituwa za a iya bayyana ta hanyar jaraba y = NX..

Dole ne mu sami mafi ƙarancin adadin murabba'un.

Bayani

Bari mu juya zuwa bayanin aikace-aikacen kai tsaye na hanyar.

1. Zuwa hagu na ma'anar farko X. saka lambar lamba 1 . Zai zama kimanin darajar darajar farkon darajar N..



2. Zuwa dama na shafi y. Sanya wani shafi - NX. A cikin tantanin farko na wannan shafi, rubuta dabara da yawa na coine N. A kan tantanin halitta na farko X. . A lokaci guda, hanyar haɗin zuwa filin da aka yi da cikakken ingancin an yi cikakke, tunda wannan darajar ba zai canza ba. Latsa maɓallin Shigar.



3. Amfani da alamar cika, kwafan wannan tsari zuwa kewayon tebur a cikin shafi a ƙasa.



4. A cikin wani sel daban, lissafta jimlar bambanci a cikin murabba'un na dabi'u y. da NX. . Don yin wannan, danna kan maɓallin "Saka bayanai".



5. A cikin "Master na ayyuka" wanda ke buɗe, Ina neman yin rikodin "Tallkvson". Zaɓi kuma danna maɓallin "Ok".



6. Tagan taga yana buɗe. A cikin filin "MIVE_x", za mu shigar da kewayon sel na shafi y. . A cikin "m_y" filin, za mu shiga kewayon sel na shafi NX. . Domin shigar da dabi'u, kawai shigar da siginan kwamfuta a cikin filin kuma zaɓi kewayon da ya dace a kan takardar. Bayan shiga, danna maɓallin "Ok".



7. Je zuwa shafin "bayanai". A kan tef a cikin "Bincike" Toshewar kayan aiki muna danna kan "search" button.



8. Bayyanon taga yana buɗewa. A cikin "inganta aikin da aka yi niyya" filin, saka adireshin tantanin halitta tare da tsari "Tallkvson". A cikin "BC" siga na "BC, tabbatar da saita canjin" mafi karancin ". A cikin "filin Pell", saka adireshin tare da ƙimar mafi ƙima N. . Danna kan "Nemo mafita".



9. Za a bayyana mafita a cikin sandar sandar N. . Wannan darajar zata zama mafi ƙarancin murabba'in aikin. Idan sakamakon ya gamsar da mai amfani, danna maɓallin "Ok" a cikin zaɓi.

Kamar yadda kake gani, amfani da mafi ƙarancin hanyar hanyar hanyar hanya kalma ce mai rikitarwa. Mun nuna shi a aikace akan mafi sauki misali, kuma akwai wasu lokuta da yawa rikitarwa. Koyaya, an tsara Microsoft Kayan aiki don sauƙaƙe lissafin.