Njira zocheperako

Njira yocheperako ndi njira yamasamu kuti ipange mawonekedwe a mzere, zomwe zingafanane kwambiri ndi mizere iwiri ya manambala. Cholinga chogwiritsa ntchito njirayi ndikuchepetsa cholakwika chonse cha quadratic. Pulogalamu yapamwamba imakhala ndi zida zomwe njira iyi ingagwiritsire ntchito powerengera. Tiyeni tichitepo ndi momwe zimachitikira.

Kugwiritsa ntchito njirayo

Njira yocheperako (Mnc) ndi malongosoledwe a masamu a kudalira kosiyanasiyana kwachiwiri. Itha kugwiritsidwa ntchito polosera.

Kuthandizira "Kusaka" Kusaka "

Pofuna kugwiritsa ntchito mne ku Excel, muyenera kuthandizira "njira yosakira" yowonjezera, yomwe imalemala.

1. Pitani ku "fayilo" tabu.



2. Dinani pa dzina "magawo".



3. Pazenera lomwe limatsegula, lekani kusankha pa "zowonjezera".



4. Mu "kasamalidwe", womwe umapezeka pansi pazenera, khazikitsani malo owonjezerapo "(ngati mtengo wina wakhazikitsidwa) ndikudina batani.



5. Windo laling'ono limatseguka. Tidayiyika ngati "njira yothetsera". Dinani pa batani la "OK".

Tsopano ntchito yothetsera vutoli pantchito imayendetsedwa, ndipo zida zake zidawonekera pa tepi.

Phunziro: Sakani mayankho mu bwino

Zinthu zavutoli

Timalongosola kugwiritsa ntchito kwa MABODZA. Tili ndi mizere iwiri ya manambala X. ndi y. Mndandanda womwe umaperekedwa m'chithunzichi pansipa.

Kudalira kolondola kwambiri kumatha kufotokozera ntchitoyi:

y = a + nx

Nthawi yomweyo, zimadziwika kuti liti x = 0. y. Zofanana 0 . Chifukwa chake, kuyerekezera uku kumatha kufotokozedwa ndi zosokoneza y = NX..

Tiyenera kupeza kuchuluka kwa mabwalo a kusiyana kwake.

Kankho

Tiyeni titsegule mafotokozedwe a njira mwachindunji.

1. Kumanzere kwa tanthauzo loyamba X. ikani digito 1 . Udzakhala mtengo woyenera wa mtengo woyamba wa zogwirizana N..



2. Kumanja kwa mzati y. Onjezani nambala ina - NX. Mu khungu loyamba la mzatiwu, lembani zochulukitsa za zowonjezera N. pa cell ya zosintha zoyambirira X. . Nthawi yomweyo, kulumikizako kumunda ndi kominjikayo kumapangidwa mtheradi, chifukwa mtengo uwu susintha. Dinani batani lolemba.



3. Pogwiritsa ntchito cholembera chodzaza, koperani njirayi pamtundu wonse wa tebulo ili pamzere pansipa.



4. Mu khungu lina, kuwerengera kuchuluka kwa kusiyana kwa mabwalo a mfundozi y. ndi NX. . Kuti muchite izi, dinani pa batani la "Inning".



5. Mu "mbuye wa ntchito" omwe amatsegula, ndikuyang'ana mbiri "Chinsinsi". Sankhani ndikudina batani la "OK".



6. Khomo lachikangano limatseguka. Mu "gawo lalikulu-", timalowetsa maselo osiyanasiyana y. . M'munda wa "waukulu_akulu, timalowa m'maselo osiyanasiyana NX. . Pofuna kulowa m'makhalidwe, ingokhazikitsa cholozera m'munda ndikusankha malo oyenera papepala. Mukalowa, kanikizani batani la "OK".



7. Pitani ku "deta" tabu. Pa tepi mu "chindale" Chida chomwe timadina batani la "Yankho".



8. Zenera la parament limatseguka. Mu "kukweza gawo la chandamale" Mu "BC", onetsetsani kuti mukusinthana ndi "ochepa". Mu "Fielng", fotokozerani adilesi ndi mtengo wa zogwirizana N. . Dinani pa batani la "Pezani yankho".



9. Njira yothetsera vutoli idzawonetsedwa mu khungu N. . Mtengo uwu udzakhala lalikulu kwambiri la ntchitoyo. Ngati zotsatira zake zikukwaniritsa wogwiritsa ntchito, kenako dinani batani la "OK" munjirayo.

Monga mukuwonera, kugwiritsa ntchito njira yocheperako ndi njira yovuta masamu. Tinaziwonetsa izi pochita zinthu zosavuta, ndipo pali milandu yovuta kwambiri. Komabe, microsoft Excekit idapangidwa kuti ithe kuwerengetsa.