Pali nthawi zina pamene mukufuna kudziwa zotsatira za kuwerengera ntchito kunja kwa malo odziwika. Nkhaniyi ndiyothandiza makamaka pakuwonetseraku. Pali njira zingapo mu Excel zomwe zingagwiritsidwe ntchito pochita opareshoni. Tiyeni tiwayang'ane ndi zitsanzo zapadera.
Kugwiritsa ntchito njira zina
Poyerekeza kutanthauzira, ntchito yomwe ikupeza phindu la ntchito pakati pa mfundo ziwiri zomwe zadziwika, kuphatikiza kumaphatikizanso kupeza yankho kunja kwaderako. Ichi ndichifukwa chake njirayi ikufunikira kulosera.
Mu Excel, extrapolation ingagwiritsidwe ntchito kuzinthu zonse za masamba ndi zithunzi.
Njira 1: kupititsa patsogolo njira zowerengera
Choyamba, timagwiritsa ntchito njira yowonjezera pazomwe zili pamndandanda. Mwachitsanzo, tengani tebulo momwe mumakhala zotsutsana zingapo (X) kuchokera 5 kale 50 ndi mndandanda wamagwiritsidwe ofanana (f (x)). Tiyenera kupeza mtengo wothandizira wotsutsanawo 55omwe ali kunja kwatsatanetsatane wosanjidwa. Pazifukwa izi timagwiritsa ntchito ntchito CHITSANZO.
- Sankhani khungu lomwe zotsatira za kuwerengera zikuwonetsedwa. Dinani pachizindikiro "Ikani ntchito", yomwe imayikidwa pamzere wa formula.
- Tsamba limayamba Ogwira Ntchito. Pitani ku gulu "Zowerengera" kapena "Mndandanda wathunthu wa zilembo". Pamndandanda womwe umatsegulira, sakani dzinalo "PREDICTION". Popeza mwachipeza, sankhani, kenako dinani batani "Zabwino" pansi pazenera.
- Timasunthira pazenera la ntchito yomwe ili pamwambapa. Ili ndi malingaliro atatu okha komanso chiwerengero chogwirizana cha minda yolowa.
M'munda "X" tiyenera kuwonetsa kufunika kwa mfundoyo, ntchito yomwe tiyenera kuwerengera. Mutha kungoyendetsa nambala yomwe mukufuna kuchokera pa kiyibodi, kapena mutha kufotokoza zomwe zikugwirizana ndi foni ngati mkanganowo walembedwa papepala. Njira yachiwiri ndiyabwino. Ngati tikhazikitsa gawo motere, ndiye kuti tiwone phindu la chinthu china, sitiyenera kusintha njira, koma zidzakhala zokwanira kusintha zosinthira mu foni yolingana. Kuti muwonetse zomwe zikugwirizana ndi foni iyi, ngati njira yachiwiri idasankhidwa, ndikokwanira kuyika kalozera m'munda wolingana ndikusankha foni iyi. Adilesi yake imawonekera nthawi yomweyo pazenera zotsutsana.
M'munda Mfundo zodziwika bwino Muyenera kufotokozera mtundu wonse wamakhalidwe omwe tili nawo. Icho chikuwonetsedwa mu mzati. "f (x)". Chifukwa chake, timayika cholozera m'munda wolingana ndikusankha mzere wonsewo popanda dzina.
M'munda Makhalidwe Abwino a x mfundo zonse zotsutsana ziyenera kuwonetsedwa, zomwe zimagwirizana ndi zoyambira zomwe tinatulutsazi. Izi zili mu mzati. x. Momwemonso monga nthawi yapita, sankhani mzere womwe tikufuna poyambitsa kounikira gawo la zenera la mkangano.
Pambuyo polemba data yonse, dinani batani "Zabwino".
- Pambuyo pa izi, zotsatira za kuwerengera kopezekanso zikuwonetsedwa mu foni yomwe idawonetsedwa m'ndime yoyamba ya malangizowo isanayambe Ogwira Ntchito. Poterepa, phindu la ntchitoyo pamapikisano 55 zofanana 338.
- Ngati, komabe, njira idasankhidwa ndikuphatikiza ulalo wa khungu lomwe lili ndi mfundo yomwe mukufuna, ndiye kuti titha kusintha ndikusintha kufunika kwa ntchitoyo kwa nambala ina iliyonse. Mwachitsanzo, mtengo wofufuza pamtsutsowu 85 khalani ofanana 518.
Phunziro: Ntchito Wizard ku Excel
Njira 2: kupitilira kwa chithunzi
Mutha kuchita njira yowonjezera chithunzicho pokonzekera mzere wosintha.
- Choyamba, tikukonzekera dongosolo lenilenilo. Kuti muchite izi, ndi chowonekera chomwe chasungidwa ndi batani lakumanzere, sankhani dera lonse la tebulo, kuphatikiza zokangana ndi malingaliro ofanananira. Kenako, kusamukira ku tabu Ikanidinani batani Tchati. Chizindikirochi chimapezeka. Ma chart pa riboni ya chida. Mndandanda wa zosankha za chart zikupezeka. Timasankha zabwino kwambiri mwa kufuna kwathu.
- Graph itamangidwa, chotsani mzere wina wotsutsana nawo, ndikuuwunikira ndikudina batani Chotsani pa kiyibodi yamakompyuta.
- Chotsatira, tifunika kusintha magawidwe agundana, chifukwa sichiwonetsa zofunikira za malingaliro, momwe timafunira. Kuti muchite izi, dinani kumanja pa tchati ndi mndandanda womwe umawonekera, imani pa "Sankhani deta".
- Pazenera lomwe limatsegulira, sankhani gwero la deta, dinani batani "Sinthani" mu block kwa kusintha siginecha ya cholowera.
- Windo la signature ya axis limatsegulidwa. Ikani chidziwitso m'munda wa zenera ili, kenako sankhani data yonse "X" wopanda dzina lake. Kenako dinani batani "Zabwino".
- Mukabwereranso pazenera losankha deta, bwerezani zomwezo, ndiye kuti dinani batani "Zabwino".
- Tsopano tchati chathu chakonzedwa ndipo mutha, mwachindunji, kuyamba kupanga mzere wazowoneka. Timasinthira pulogalamuyo, pambuyo pake ma tabu owonjezerapo amatsekera riboni - "Kugwira ntchito ndi ma chart". Pitani ku tabu "Kamangidwe" ndipo dinani batani Chikhalidwe mu block "Kusanthula". Dinani pazinthuzo "Kuyandikira kwa mzere" kapena "Makamaka.
- Chingwe chowonjezera chawonjezeredwa, koma chiri chonse pansi pa mzere wa tchati ichochokha, popeza sitinawonetse phindu la lingaliro lomwe likuyenera kulolera. Kuti muchite izi kachiwiri, dinani batani motsatizana Chikhalidwekoma tsopano sankhani "Zowonjezera mzere mzere".
- Windo lazithunzi lazithunzi limayamba. Mu gawo Magawo Omwe Amayenda pali choletsa "Zonenedweratu". Monga momwe tinachitira kale, tiyeni titengetu mkangano woti tichoke 55. Monga mukuwonera, mpaka pano graph ili ndi kutalika mpaka kutsutsana 50 kuphatikiza. Zikhala kuti tidzafunika kuwonjezera zina 5 mayunitsi. Pamalo opingasa ndikuwoneka kuti magawo asanu ndi ofanana gawo limodzi. Ndiye iyi ndi nthawi imodzi. M'munda "Pitani ku" lowetsani mtengo wake "1". Dinani batani Tsekani m'makona akumunsi a zenera.
- Monga mukuwonera, tchati chinakulitsidwa ndi kutalika komwe kunenedwa pogwiritsa ntchito mzere wowonera.
Phunziro: Momwe mungapangire mzere wotsogolera ku Excel
Chifukwa chake, tidasanthula zitsanzo zosavuta kwambiri zakusintha kwa matebulo ndi ma graph. Poyambirira, ntchitoyo imagwiritsidwa ntchito CHITSANZO, ndipo chachiwiri - mzere wotengera. Koma kutengera zitsanzozi, zovuta zovuta kulosera zitha kuthetsedwa.
