Kusanthula za kugonana ndi imodzi mwa njira zofunikirako zowerengera. Ndicho, mungathe kuyika chiwerengero cha mphamvu zosiyana pazomwe zimadalira. Microsoft Excel ili ndi zida zogwiritsira ntchito mtundu uwu wa kusanthula. Tiyeni tiwone zomwe iwo ali ndi momwe angawagwiritsire ntchito.
Kulumikiza Kulumikiza Package
Koma, kuti mugwiritse ntchito ntchito yomwe imalola kuti kuyambanso kusanthula, choyamba, muyenera kuyambitsa Analyse Package. Pomwepo zida zofunikira pa njirayi zidzawonekera pa Excel tepi.
- Pitani ku tabu "Foni".
- Pitani ku gawoli "Zosankha".
- Fayilo la Excel zosankha limatsegula. Pitani ku gawo Zowonjezera.
- Pansi pa zenera lomwe limatsegulira, yongolani kusinthana "Management" mu malo Zowonjezeretsa Zolembangati ziri zosiyana. Timakanikiza batani "Pitani".
- The Excel add-ons zitsegulira. Ikani chongani pafupi ndi chinthucho "Analysis Package". Dinani pa batani "OK".
Tsopano pamene tipita ku tabu "Deta", pa tepi muzitsulo "Kusanthula" tidzawona batani latsopano - "Kusanthula Deta".
Mitundu yowonongeka
Pali mitundu yambiri ya zovuta:
- chithunzi;
- mphamvu;
- logarithmic;
- exponential;
- chiwonetsero;
- chithandizo;
- kusinthika kwachilendo.
Tidzayankhula zambiri za kukhazikitsidwa kwa kafukufuku wotsiriza wa Excel.
Kugonjetsa kwapakati pa Excel
Pansipa, mwachitsanzo, tebulo ikuwonetsedwa yomwe imasonyeza kutentha kwa mpweya tsiku ndi tsiku kunja, ndi chiwerengero cha ogula sitolo tsiku lomwe likugwira ntchito. Tiyeni tipeze mwa kuthandizidwa ndi kusanthula kachitidwe ka nyengo, momwe nyengo ikuyendera mofanana ndi kutentha kwa mpweya kungakhudzire kupezeka kwa malonda.
Kugwirizana kwachiwiri kwa mtundu wofanana ndi motere:Y = a0 + a1x1 + ... + akhk. Mwachidule ichi Y amatanthauza kusinthika, chikoka cha zinthu zomwe tikuyesera kuti tiphunzire. Kwa ife, iyi ndi chiwerengero cha ogula. Meaning x - izi ndi zinthu zosiyanasiyana zomwe zimakhudza kusintha. Parameters a ndi regress coefficients. Izi ndizo, amadziŵa tanthauzo la chinthu china. Ndondomeko k amatanthauza chiwerengero cha zifukwa izi.
- Dinani pa batani "Kusanthula Deta". Ikuyikidwa mu tabu. "Kunyumba" mu chigawo cha zipangizo "Kusanthula".
- Dindo laling'ono limatsegulidwa. M'menemo, sankhani chinthucho "Kugonjetsa". Timakanikiza batani "Chabwino".
- Zowonongeka zowonjezera zenera ziyamba. Mmenemo, minda yoyenera ndi "Nthawi Yowonjezera Y" ndi "Nthawi yowonjezera X". Zosintha zina zonse zingasiyidwe ngati zosasintha.
Kumunda "Nthawi Yowonjezera Y" timafotokozera adiresi ya maselo osiyanasiyana pamene deta yosinthika ilipo, mphamvu ya zinthu zomwe tikuyesera kukhazikitsa. Kwa ife, izi zidzakhala maselo mu "Nambala ya Ogula". Adilesi ingalowetsedwe pamakinawo, kapena mungathe kusankha mndandanda womwe mukufuna. Njira yotsirizayi ndi yophweka komanso yosavuta.
Kumunda "Nthawi yowonjezera X" lowetsani adiresi ya maselo osiyanasiyana komwe deta ya chinthucho, zomwe zimakhudza zomwe zimasintha, zikupezeka. Monga tafotokozera pamwambapa, tifunikira kudziwa zotsatira za kutentha kwa chiwerengero cha makasitomala m'sitolo, choncho pitani adiresi ya maselo mu "Kutentha". Izi zikhoza kuchitidwa mofanana ndi "Nambala ya ogula".
Mothandizidwa ndi zochitika zina, mukhoza kulemba malemba, mlingo wokhala wodalirika, nthawi zonse-zero, kusonyeza galasi labwino, ndikuchita zina. Koma, nthawi zambiri, masewerawa safunikira kusintha. Chinthu chokha chimene muyenera kumvetsera ndi zotsatira za magawo. Mwachidule, zotsatira zowonongeka zimachokera pa pepala lina, koma mwa kukonzanso kusinthika, mungathe kuyika chiwerengerocho pa tsamba lomwelo pomwe tebulo liri ndi deta yapachiyambi, kapena mu bukhu lapadera, ndiko, mu fayilo yatsopano.
Pambuyo pokonza zonsezi, dinani pa batani. "Chabwino".
Kufufuza kwa zotsatira za kusanthula
Zotsatira za kusinthidwa kwazithunzi zikuwonetsedwa mu tebulo pamalo omwe amasonyezedwa.
Chimodzi mwa zizindikiro zazikulu ndi R-squared. Amasonyeza khalidwe la chitsanzo. Kwa ife, chiwerengero ichi ndi 0.705, kapena pafupifupi 70.5%. Iyi ndi mlingo woyenera wa khalidwe. Kudalira zosakwana 0,5 n'koipa.
Chizindikiro china chofunika chili mu selo pambali ya mzere. "Y-intersection" ndi gawo Zovuta. Zimasonyeza kufunika kwa Y, ndipo kwa ife, iyi ndi chiwerengero cha ogula, ndi zinthu zina zonse zofanana ndi zero. Mu tebulo ili, mtengo uwu ndi 58.04.
Gwiritsani ntchito pamphambano ya grafu "Zosintha X1" ndi Zovuta amasonyeza kukula kwake kwa Y pa X. Kwa ife, iyi ndiyo mlingo wodalirika wa chiwerengero cha makasitomala a sitolo pa kutentha. Coefficient ya 1.31 ikuwoneka ngati chizindikiro chokwanira cha mphamvu.
Monga mukuonera, kugwiritsa ntchito Microsoft Excel n'kosavuta kupanga kapangidwe ka zowonongeka. Koma, munthu wophunzitsidwa yekha angagwiritse ntchito ndi chiwerengero cha deta, ndikumvetsetsa zomwe akufunikira.
