Pali mkhalidwe pamene muli ndi zidziwitso zambiri zomwe mukufunikira kupeza zotsatira zapakatikati. Mu masamu, izi zimatchedwa interpolation. Mu Excel, njira iyi ingagwiritsidwe ntchito pazithunzi zonse ndi ma graphing. Tiyeni tione njira iliyonseyi.
Gwiritsani ntchito kutanthauzira
Chinthu chachikulu chomwe chitha kugwiritsidwa ntchito ndi chakuti mtengo wofunikila uyenera kukhala mkati mwa deta, ndipo usapite mopitirira malire ake. Mwachitsanzo, ngati tili ndi ziganizo 15, 21, ndi 29, ndiye pamene tipeze ntchito yotsutsana 25 tingagwiritse ntchito kutanthauzira. Ndipo kufufuza mtengo wofanana wa kukangana 30 - panonso. Ichi ndicho kusiyana kwakukulu kwa njirayi kuchokera ku extrapolation.
Njira 1: Kuyankhulana kwa deta
Choyamba, ganizirani kugwiritsa ntchito interpolation kwa deta yomwe ili pa tebulo. Mwachitsanzo, tengani ndemanga yambiri ndi machitidwe ogwirizana, chiŵerengero cha zomwe zingathe kufotokozedwa ndi mgwirizano wofanana. Deta iyi ili mu tebulo ili m'munsiyi. Tiyenera kupeza ntchito yoyenera pazokangana. 28. Njira yosavuta yochitira izi ndi woyendetsa. ZAMBIRI.
- Sankhani selo iliyonse yopanda kanthu pa pepala komwe wogwiritsa ntchito akukonzekera kuti asonyeze zotsatira kuchokera pazochitika. Kenako, dinani pakani. "Ikani ntchito"yomwe ili kumanzere kwa bar.
- Yatsegula zenera Oyang'anira ntchito. M'gululi "Masamu" kapena "Mndandanda wathunthu wa alfabeti" fufuzani dzina "ZAMBIRI". Pambuyo phindu lofanana likupezeka, sankhani ilo ndipo dinani pa batani "Chabwino".
- Ntchito yotsutsana zenera ikuyamba. ZAMBIRI. Lili ndi minda itatu:
- X;
- Zomwe Amadziwika Y;
- Zodziwika bwino x.
Mu gawo loyambirira, tikungoyenera kutengera zoyenera za mkangano kuchokera ku kibodiboli, ntchito yomwe iyenera kupezeka. Kwa ife ndizo 28.
Kumunda "Zomwe Amadziwika Y" muyenera kufotokoza zochitika zazomwe muli tebulo, zomwe ziri ndi ziyeso za ntchitoyi. Izi zikhoza kuchitidwa pamanja, koma zimakhala zosavuta komanso zosavuta kuziyika mthunzi mmunda ndikusankha malo ofanana pa pepala.
Mofananamo, khalani m'munda "Zodziwika x" Mndandanda umagwirizana ndi zifukwa.
Pambuyo pa deta zonse zofunika, dinani pa batani "Chabwino".
- Chofunika chogwira ntchito chidzawonetsedwa mu selo yomwe tidasankha mu sitepe yoyamba ya njira iyi. Zotsatira zake zinali nambala 176. Zidzakhala zotsatira za ndondomekoyi.
Phunziro: Excel ntchito wizara
Njira 2: Interpolate graph pogwiritsa ntchito zoikamo
Ndondomekoyi ikhonza kugwiritsidwa ntchito pomanga ma grafu a ntchito. Ndikofunikira ngati mtengo wofanana wa ntchitoyo sunawonetsedwe mwachinthu chimodzi chomwe chili pa tebulo pa maziko omwe graph amamangidwa, monga mu chithunzi pansipa.
- Yambani kumanga graph mwanjira yonse. Izi zikutanthauza kuti kukhala mu tab "Ikani", timasankha mtundu wa tebulo pogwiritsa ntchito ntchito yomanga. Dinani pazithunzi "Ndondomeko"anaikidwa mu chida cha zipangizo "Zolemba". Kuchokera pa mndandanda wa ma graph omwe akuwonekera, sankhani zomwe timaganiza kuti zili zoyenera pazinthu izi.
- Monga mukuonera, graph imamangidwa, koma osati momwe ife tikusowa. Choyamba, icho chathetsedwa, chifukwa ntchito yowonjezera sinapezeke chifukwa cha kutsutsana kokha. Chachiwiri, pali mzere wina pa izo. X, zomwe simukufunikira, ndipo mfundo zomwe zili pamzere wosakanikirana ndi zinthu zokhazokha, osati mfundo zomwe zimatsutsana. Tiyeni tiyesere kukonza zonsezi.
Choyamba, sankhani mzere wofiira wa buluu womwe mukufuna kuwachotsa ndipo dinani pa batani Chotsani pabokosi.
- Sankhani ndege yonse yomwe galasi imayikidwa. M'ndandanda wamakono yomwe ikuwonekera, dinani pa batani "Sankhani deta ...".
- Fayilo yosankhira deta yopezera deta ikuyamba. Mulowetsa bwino "Zisindikizo zazitali zozungulira" pressani batani "Sinthani".
- Fasilo yaing'ono imatsegula pamene mukufunikira kufotokoza zochitika zazomwezo, zomwe zidzasonyezedwe pamlingo wazitali. Ikani cholozera mmunda "Mbali Yachizindikiro ya Axis" ndi kungosankha malo ofanana pa pepala, yomwe ili ndi zifukwa zomveka. Timakanikiza batani "Chabwino".
- Tsopano tiyenera kuchita ntchito yaikulu: kugwiritsa ntchito mawu omveka kuti tipewe kusiyana. Kubwerera kuzenera zosankhidwa zowonetsera deta dinani pa batani. "Maselo obisika ndi opanda kanthu"ili kumbali ya kumanzere kumanzere.
- Mawindo opangidwira a maselo obisika ndi opanda kanthu amatsegulidwa. Muyeso "Onetsani maselo opanda kanthu" ikani kasinthasintha kuti muyime "Mzere". Timakanikiza batani "Chabwino".
- Titabwerera ku zenera zosankha, timatsimikiza kusintha komweku podutsa batani "Chabwino".
Monga mukuonera, graph isinthidwa, ndipo mpata wachotsedwa ndi kutanthauzira.
Phunziro: Mungamange bwanji graph mu Excel
Njira 3: Kuyankhulana kwa Grafu Pogwiritsa ntchito Ntchitoyi
Mukhozanso kutanthauzira pa graph pogwiritsa ntchito ntchito yapadera ND. Icho chimabweretsanso chikhalidwe chosadziwika mu selo yeniyeni.
- Pambuyo pa pulogalamuyi yomangidwa ndi yokonzedweratu, momwe mukufunira, kuphatikizapo malo oyenerera a signature, ikutsalira kuti mutseke kusiyana. Sankhani selo lopanda kanthu patebulo limene deta imatulutsidwa. Dinani pa chithunzi chodziwika kale "Ikani ntchito".
- Kutsegulidwa Mlaliki Wachipangizo. M'gululi "Kusanthula katundu ndi mfundo" kapena "Mndandanda wathunthu wa alfabeti" pezani ndikuwonetseratu mbiri "ND". Timakanikiza batani "Chabwino".
- Ntchitoyi ilibe mtsutso, womwe ukuwonetsedwa ndiwindo lazomwe likuwonekera. Kuti mutseke izo dinani basi pa batani. "Chabwino".
- Pambuyo pachithunzi ichi, kulemera kwa malingaliro kumawoneka mu selo losankhidwa. "# N / A", koma, monga momwe mukuonera, kudula kumangokhala kokha.
Mukhoza kuzipanga mosavuta popanda kuthamanga Mlaliki Wachipangizo, koma kuchokera pa khibhodiyi kuti ayendetse mtengo kupita mu selo yopanda kanthu "# N / A" popanda ndemanga. Koma zimadalira kale momwe zilili zosavuta kwa wosuta.
Monga mukuonera, pulogalamu ya Excel mungathe kupanga malemba monga ma deta pamagwiritsidwe ntchito ZAMBIRIndi zithunzi. Pachifukwachi, izi zikhoza kuchitika pogwiritsa ntchito ndandanda kapena ntchito NDkuchititsa zolakwika "# N / A". Kusankhidwa kwa njira yomwe mungagwiritsire ntchito kumadalira kusintha kwa vuto, komanso zosankha za mnzanuyo.
