Ukusebenzisa i-Microsoft Excel Interpolation

Kunesimo lapho kunamanani amaningi aziwayo okudingayo ukuthola imiphumela ephakathi. Ezibalo, lokhu kubizwa ngokuthi i-interpolation. Ku-Excel, le ndlela ingasetshenziswa kokubili idatha ye-tabular negraphing. Ake sihlole ngayinye yalezi zindlela.

Sebenzisa ukubhala

Isimo esiyinhloko lapho kusetshenziselwa khona ukubaluleka kungukuthi inani elifunayo kufanele libe ngaphakathi kwedatha yedatha, futhi ungahambi ngaphezu komkhawulo walo. Isibonelo, uma sinesigatshana sezingxabano 15, 21, no-29, khona-ke lapho sithola umsebenzi wezingxabano 25 singasebenzisa ukuphendula. Futhi ukucinga inani elihambelanayo lempikiswano 30 - asisekho. Lona umehluko omkhulu wale nqubo kusuka ku-extrapolation.

Indlela 1: I-interpolation yedatha ye-tabular

Okokuqala, cabanga ukusetshenziswa kwe-interpolation yedatha etholakala etafuleni. Isibonelo, thatha izimpikiswano eziningi kanye nezindinganiso zokusebenza ezihambelanayo, isilinganiso esingahle sichazwe nge-equation equation. Le datha ifakwe kuthebula elingezansi. Kudingeka sithole umsebenzi ohambelana nempikiswano. 28. Indlela elula yokwenza lokhu iwukuba opharetha. UKUPHILA.

1. Khetha noma iyiphi iseli elingenalutho kushidi lapho umsebenzisi ehlela ukubonisa umphumela kusuka ezenzweni ezenziwe. Okulandelayo, chofoza inkinobho. "Faka umsebenzi"elitholakala ngakwesokunxele kwebha yefomula.



2. Iwindi elisebenzayo Amakhosi omsebenzi. Esikhathini "Isibalo" noma "Uhlu oluphelele lwe-alfabhethi" bheka igama "UKUQALA". Ngemuva kokuthi inani elihambelanayo litholakala, khetha bese uchofoza inkinobho "Kulungile".



3. Iwindi lempikiswano yokusebenza iqala. UKUPHILA. Inemikhakha emithathu:
   • X;
   • Ama-Y Amanani we-Y;
   • Amanani axhumene x.

   Esikhathini sokuqala, sidinga nje ukufaka ngamanani ama-argument avela kwikhibhodi, umsebenzi okufanele utholakale. Esimweni sethu kuwukuthi 28.

   Ensimini "Izimpawu Zama-Y" kufanele ucacise izixhumanisi zobubanzi betafula, equkethe amanani omsebenzi. Lokhu kungenziwa ngesandla, kodwa kulula kakhulu futhi elula kakhulu ukubeka isikhombisi endle bese ukhetha indawo ehambelana neshidi.

   Ngokufanayo, usethe ensimini "Eyaziwa x" izixhumanisi zamabanga ngezimpikiswano.

   Ngemuva kokuthi yonke imininingwane edingekayo ingenwe, chofoza inkinobho "Kulungile".



4. I-value function function oyifunayo izoboniswa esitokisini esiyikhethile esiteshini sokuqala sale ndlela. Umphumela waba inombolo 176. Kuyoba umphumela wenqubo yokubamba iqhaza.

Isifundo: I-Excel umsebenzi wizard

Indlela 2: I-Interpolate igrafu usebenzisa izilungiselelo zayo

Inqubo yokubamba iqhaza nayo ingasetshenziswa uma kwakhiwa amagrafu womsebenzi. Kuyafaneleka uma inani elihambelanayo lomsebenzi lingaboniswa kwelinye lamaphuzu etafuleni ngesisekelo esakhiwe ngalo igrafu, njengalesi sithombe esingezansi.

1. Yenza ukwakha igrafu ngendlela evamile. Okungukuthi, ekubeni kuthebhu "Faka", sikhetha uhla lwetafula ngesisekelo lapho ukwakhiwa kuzokwenziwa khona. Chofoza kusithonjana "Hlela"efakwe ebhodini lamathuluzi "Amashadi". Kusukela kuhlu lwamagrafu abonakalayo, khetha lokho esikucabangela ukuthi kufanelekile kakhulu kule simo.



2. Njengoba ubona, igrafu yakhiwa, kodwa hhayi ngendlela esidinga ngayo. Okokuqala, iphukile, ngoba umsebenzi ohambelanayo awatholakalanga ngxabano eyodwa. Okwesibili, kunomugqa owengeziwe kuwo. X, okwamanje akudingeki, futhi amaphuzu e-axis enezingqimba ayinto nje ehlelekile, hhayi amanani wempikiswano. Ake sizame ukulungisa konke.

   Okokuqala, khetha umugqa ohlaza okwesibhakabhaka ofuna ukususa bese uchofoza inkinobho Susa kwikhibhodi.



3. Khetha yonke indiza lapho igrafu ifakwa khona. Emenyu yomongo ebonakalayo, chofoza inkinobho "Khetha idatha ...".



4. Iwindi yokukhetha imithombo yedatha iqala. Esigodini sokunene "Amasignesha we-axis enezingqimba" cindezela inkinobho "Shintsha".



5. Iwindi elincane livula lapho udinga ukucacisa izixhumanisi zobubanzi, amanani okuzoboniswa esikalini se-axis enezingqimba. Setha isikhombisi emkhakheni "I-Axis Signature Range" bese uvele ukhethe indawo ehambelana neshidi, eliqukethe izingqinamba zomsebenzi. Sicindezela inkinobho "Kulungile".



6. Manje kufanele senze umsebenzi oyinhloko: ukusebenzisa i-interpolation ukuqeda igebe. Ukubuyela ewindini lokukhetha ibanga lemininingwane chofoza inkinobho. "Amaseli afihliwe angenalutho"ekhoneni elingezansi elingakwesokunxele.



7. Iwindi lesethingi lamaseli afihliwe futhi angenalutho avuleka. Kupharamitha "Bonisa amaseli angenalutho" setha inkinobho ukuma "Ulayini". Sicindezela inkinobho "Kulungile".



8. Ngemva kokubuyela ewindini lokukhetha umthombo, siqinisekisa zonke izinguquko ezenziwe ngokuchofoza inkinobho "Kulungile".

Njengoba ubona, igrafu ishintshiwe, futhi igebe lisuswa ngokubhaliwe.

Isifundo: Ungakha kanjani igrafu ku-Excel

Indlela 3: Ukuphambana kweGrifu Ukusebenzisa Umsebenzi

Ungaphinda uqondise igrafu usebenzisa umsebenzi okhethekile we-ND. Ibuyisela amanani angalungile kuseli elicacisiwe.

1. Ngemuva kokuthi isimiso sakhiwe futhi sihlelwe, njengoba udinga, kufaka phakathi ukubekwa okulungile kwesilinganiso sesignesha, kuhlala kuphela ukuvala igebe. Khetha iseli elingenalutho etafuleni lapho kudonswa khona idatha. Chofoza kusithonjana esivele sijwayele "Faka umsebenzi".



2. Ivula Umsebenzi weWebhu. Esikhathini "Ukuhlola izindawo nezindinganiso" noma "Uhlu oluphelele lwe-alfabhethi" thola futhi uqokomise irekhodi "ND". Sicindezela inkinobho "Kulungile".



3. Lo msebenzi awunayo impikiswano, eboniswa iwindi lwazi oluvela. Ukuze uyivale nje uchofoze inkinobho. "Kulungile".



4. Ngemuva kwalesi senzo, inani lephutha livela kuseli elikhethiwe. "# N / A", kodwa-ke, njengoba ubona, ukuchofoza kwalungiswa ngokuzenzakalelayo.

Ungenza kube lula nakakhulu ngaphandle kokusebenza Umsebenzi weWebhu, kodwa kusuka kukhibhodi ukuhambisa inani ibe yiseli elingenalutho "# N / A" ngaphandle izingcaphuno. Kodwa kakade kuncike ekutheni kulula kangakanani umsebenzisi.

Njengoba ungabona, ohlelweni lwe-Excel ungenza ukukopisana njengedatha yedatha usebenzisa umsebenzi UKUPHILAfuthi ihluzo. Esikhathini esilandelayo, lokhu kungenziwa ngokusebenzisa izilungiselelo zesimiso noma usebenzisa umsebenzi NDokwenza iphutha "# N / A". Ukukhethwa kwendlela oyisebenzisayo kuxhomeke ekubunjweni kwenkinga, kanye nokuthandwa komuntu siqu komsebenzisi.