Njira yokhala ndi malo owerengeka ndiyo njira yopangira masamu omwe angagwirizane kwambiri ndi magawo awiri a manambala. Cholinga cha njira iyi ndi kuchepetseratu zolakwika zonse. Excel ili ndi zida zogwiritsira ntchito njira iyi yowerengera. Tiyeni tiwone momwe izi zakhalira.
Kugwiritsa ntchito njira mu Excel
Njira ya malo ochepa (OLS) ndikulongosola kwa masamu za kudalira kwa kusintha kotere pa yachiwiri. Ikhoza kugwiritsidwa ntchito pokonzekera.
Kulowetsa "Solution Finder" kuwonjezera
Kuti mugwiritse ntchito OLS mu Excel, muyenera kuwonjezera kuwonjezera "Fufuzani yankho"chimene chalepheretsedwa ndi chosasintha.
- Pitani ku tabu "Foni".
- Dinani pa dzina la gawo "Zosankha".
- Pawindo limene limatsegulira, lekani kusankha pa ndimeyi Zowonjezera.
- Mu chipika "Management"yomwe ili pansi pazenera, ikani kasinthasintha ku malo Zowonjezeretsa Zolemba (ngati mtengo winanso uli mkati mwake) ndipo panikizani batani "Pitani ...".
- Dindo laling'ono limatsegulidwa. Timayikiranso zowonjezereka zapadera "Kupeza yankho". Timakanikiza batani "Chabwino".
Tsopano yambani Kupeza yankho Excel yamasulidwa, ndipo zipangizo zake zikuwoneka pa tepi.
Phunziro: Fufuzani yankho mu Excel
Mkhalidwe wa vutoli
Timafotokoza kugwiritsa ntchito MNC ndi chitsanzo chapadera. Tili ndi mizere iwiri ya manambala x ndi y, mndandanda wa zomwe zikufotokozedwa mu chithunzi pansipa.
Cholondola kwambiri kuti kudalira kumeneku kungathe kufotokoza ntchitoyi:
y = a + nx
Pa nthawi yomweyo, zimadziwika kuti ndi x = 0 y ndi ofanana 0. Choncho, mgwirizano uwu ukhoza kufotokozedwa ndi kudalira y = nx.
Tiyenera kupeza ndalama zochepa zosiyana siyana.
Solution
Tiyeni tipitirize kufotokozera momwe ntchitoyi ikugwiritsire ntchito.
- Kumanzere kwa mtengo woyamba x ikani chiwerengerocho 1. Ichi chidzakhala chiwerengero cha mtengo woyambirira wa coefficient. n.
- Kumanja kwa gawolo y yonjezerani ndime imodzi - nx. Mu selo yoyamba ya ndimeyi, lembani njira yowonjezera coefficient n pa selo yoyamba yosinthika x. Panthawi imodzimodziyo, timayang'ana munda ndi coefficient absolute, popeza phindu limeneli silidzasintha. Dinani pa batani Lowani.
- Pogwiritsira ntchito chikhomo chodzaza, lembani fomu iyi ku gome lonselo m'ndandanda pansipa.
- Mu selo losiyana, ife timawerengera kuchuluka kwa kusiyana kwa miyezo ya makhalidwe. y ndi nx. Kuti muchite izi, dinani pa batani "Ikani ntchito".
- Mudatseguka "Mbuye Wa Ntchito" akuyang'ana zolemba "SUMMKVRAZN". Sankhani ndipo dinani pa batani. "Chabwino".
- Fesholo yotsutsana ikutsegula. Kumunda "Array_x" lowetsani mndandanda wa m'ndandanda y. Kumunda "Array_y" lowetsani mndandanda wa m'ndandanda nx. Kuti mulowe muyeso, ingoikani cholozera mmunda ndikusankha zofunikira pa pepala. Atalowa, dinani pakani "Chabwino".
- Pitani ku tabu "Deta". Pa tepiyi mu chida cha zipangizo "Kusanthula" pressani batani "Kupeza yankho".
- Fenje lazitali za chida ichi chikuyamba. Kumunda "Konzekerani Ntchito Yoyenera" tchulani adilesi ya selo ndi ndondomekoyi "SUMMKVRAZN". Muyeso "Mpakana" Onetsetsani kuti mupange chosinthana kuti muyime "Osachepera". Kumunda "Kusintha maselo" timafotokoza adilesi ndi mtengo wa coefficient n. Timakanikiza batani "Pezani yankho".
- Yankho lidzawonetsedwa mu selo yowonjezera. n. Mtengo uwu udzakhala malo ang'onoang'ono a ntchitoyo. Ngati zotsatira zikhutiritsa wosuta, ndiye dinani batani "Chabwino" muwindo wowonjezera.
Monga tikuonera, kugwiritsa ntchito njira zing'onozing'ono ndi njira yovuta kwambiri ya masamu. Tinawonetsa izi mwachangu ndi chitsanzo chosavuta, ndipo pali zovuta zambiri zovuta. Komabe, bukhuli la Microsoft Excel lapangidwa kuti likhale losavuta kuwerengetsera zomwe zinapangidwa mochuluka.
