Interpolation ee Excel: Features, hannaanka iyo tusaalooyin,

Excel isbiriidhshiit kuu ogolaanaya in aad si deg deg ah ma aha oo kaliya ay soo saaraan noocyo kala duwan oo xisaabaha, laakiin sidoo kale si ay u xalliyaan shaqo halkii ay adag tahay. Tusaale ahaan, waxaa laga yaaba in la isticmaalayo Qaabaynta xisaabta ku salaysan set oo ah qiimaha Discrete of function ah, oo ay ku jiraan hawlaha si aad u ogaato qiimaha dhexe by interpolation. In Excel ujeedadaas siisaa qalab kala duwan si ay u isticmaalaan la baraa in this article.

Interpolation Habka: waa maxay?

In habka wax-u tiro falanqaynta helidda qiimaha dhexe ee shaqada la garanayn Y (X) ee go'an Discrete ee hore u ogaan lahaa.

function interpolation The Y (X) la fulin karo oo kaliya kuwa dood ay, kuwaas oo gudaha bareeg ah [X _0, X _n], sida in qiyamka Y (X ₀₎ iyo Y (X _n).

Haddii X uusan ka tirsan [X _0, X _n], waxaa suurtagal ah in la isticmaalo habka extrapolation.

In dejinta classical dhibaato interpolation ayaa loo baahan yahay si aad u hesho ah φ qiyaas analytic function (X), taas oo qiimaha ugu dhibcood X patrilineal _i leedahay uu qiimuhu isku mid Y _{(i X)} oo ka mid ah m miiska asalka ah. E. Ka dib _φ xaalad _{(i X) = Y i} (i = 0,1,2, ..., n).

interpolation toosan ee Excel

Codsiga isbiriidhshiit ugu caansan ka Microsoft waxaa jira shaqaale aad u faa'iido leh "Saadaasha".

Tixgeli xogta qabanqaabiyaa miis hoos.

Tiirka ugu horeysay ee waa dood x, iyo tan labaad - qiimo u dhigma shaqada a f toosan (x). Ka soo qaad in aan u baahanahay si ay u bartaan qiimaha leh Xujada x = 28. Si arrintan loo sameeyo:

• dhigid kasta processor cell maran miiska xaashida, halkaas oo ay natiijada noqon doonta wax soo saarka ka hirgelinta tallaabada, tusaale ahaan C1;
• riixi on icon «fx» ah ( «function Insert"), kaalinta on bidix ee bar caanaha,
• ee "Master hawlaha" sanduuqa soo galay category ah "Math",
• heli wadaha "Saadaasha" iyo riix «OK».

In dood si 3 golf. The qiimaha ugu horeysay muran la gelin keyboard (in this hawl gaar ah 28). Si aad u buuxiso ee "qiyam loo yaqaan _ y», guji icon la arrow cas bidix ee suuqa u dhiganta iyo sii daayo meelaha ku habboon ee xaashida. In kiis gaar ah, oo qayb ka this ee cinwaanada column kala duwan ee B2 ah: B7.

Sidoo kale, buuxi ee "qiyam loo yaqaan _ x" iyo guji badhanka "OK".

Sidaas darteed, in gacanta la soo xulay C1 waxaa soo bandhigay 176, taas oo ah natiijada habka interpolation ah.

Graphic Habka: Diyaarinta

Interpolation in Excel, tusaale ka mid ah kaas oo la kor ku siiyo, ma aha sida kaliya ee si aad u ogaato qiimaha oo aan la garaneyn dhexe oo ka mid ah shaqada Y (X) ee go'an Discrete ee hore u ogaan lahaa. Gaar ahaan, hab garaaf ah loo isticmaali karaa. Waxay noqon kartaa mid waxtar leh haddii ay miiska mid ka mid ah dood ku qeexan hawlaha qiimo u dhigma sida mid ka mid ah in hoos ayaa lagu muujiyey (eeg. Cell The cinwaanka B9).

Interpolation ee Excel kiiskan bilaabmaa jadwalka dhismaha. Si arrintan loo sameeyo:

• in tab ah "Geli" kala duwan oo miiska go'doon,
• in block qalab "gooldhalinta" icon soo xulay "Muujis" ah;
• oo liiska ku jirta oo u muuqata, ka dooro mid ah in uu yahay haboon ujeeddo gaar ah.

Tan iyo B9 cell jadwalka madhan in wada dooxay. Intaa waxaa dheer, waa hadiyad X line dheeraad ah, taas oo aan loo baahnayn, iyo dhidibka siman halkii qiyamka doodda ku qoran yihiin si ay of dhibcood.

Interpolation ee Excel: Go'aanka hab graphic

aynu naqshadeynta processing. Waayo, kanu dhaadheer line buluug ah oo joogto ah oo ka saartid adigoo riixaya Delete, taas oo ah on keyboard ah.

markaas:

• qoondeeyo diyaarad on taas oo garaafka;
• dooran badhanka "Dooro Data ..." ka menu macnaha;
• ee "Dooro Data Source" sanduuqa saxda ah, saxaafadda "Change";
• riix icon la arrow cas si xaq duurka "sumadaha dhidibka Range",
• qoondeeyo A2 kala duwan: A11,
• riix badhanka «OK»;
• mar keeni daaqadda "Data Source Xulashada";
• riix badhanka "Unugyada Qarsoon oo faaruqa ah" ee koonaha bidix ee hoose;
• ee "Show Unugyada faaruqa ah" biiray line waxaa habeyn ee "Line" jago iyo riix «OK»;
• xaqiijiyo tallaabadan si la mid ah.

Haddii si sax ah u samaysay, farqiga laga saari doonaa, oo u dhaqaajinaya dulqabo in ay hal dhibic ka doonayo ee garaafka waxaad arki doontaa qiimaha u dhigma of muran iyo shaqada.

Isticmaalka ND a shaqo gaar ah

Hadda oo aad ogtahay sida loo sameeyo interpolation ah ee Excel hab garaaf ama by operator "Saadaasha" ka, xal of dhibaatooyin badan oo la taaban karo, waayo, ma aad inay aad u adag tahay. Laakiin sidaas maaha oo dhan. Barnaamijka isbiriidhshiit ka Microsoft awoodaa inuu ku helo qiimaha la garaneyn oo shaqo ah oo isticmaalaya function LP ah.

U qaadan in jadwalka horay loo dhisay, waxa uu aasaasay calaamada saxda ah ee miisaanka. Aynu isku day in aad yareyso farqiga. Si arrintan loo sameeyo:

• Table unug go'doon in ka maqan qiimaha shaqada;
• dooran icon ah "Function Insert";
• ee "Wizard Function" sanduuqa "Categories" heli string "liiska Horeeyaan Full" (in versions qaar ka mid ah processor ah "Adiga oo guryaha iyo qiimaha");
• guji soo galo "taago" rux badhanka «OK».

Ka dib markii in, in B9 gacanta u muuqataa qiimaha qaladka "# N / A." Si kastaba ha ahaatee, garaafka furan waxaa si toos ah ciribtiray.

Waxaad samayn kartaa xitaa ka badan si fudud, si ay u sameeyaan keyboard ee calaamadaha B9 cell "# N / A" (bilaa xigashooyin).

interpolation bilinear

kala duwan ee hawlaha waayo oo aad isticmaali karto jilitaanka iyadoo adeegsanayo hawlaha hal doorsoome, waxaa xadiday. Sidaas waxa macno si ay u eegaan sida caanaha waa interpolation a double waxaa loo isticmaalaa in Excel. Tusaale ahaan waxaa laga yaabaa in aad u kala duwan. Tusaale ahaan waxaa jira miis (fiiri hoos.).

Waxaa loo baahan yahay si ay u xisaabiso cadaadis dabayl at qiimaha taako ka mid ah 300 m ee height ah 25 m.

In miiska ku darto entries cusub sida ku cad shaxanka (eeg. Hoos).

Sida aad arki karto, waxay ku daray in ay height cell iyo taako ee J1 iyo J2.

By bedelay xig xiga dambe "ururiyey" megaformulu lagama maarmaan ah in la helo cadaadiska dabaysha ee beegyada uu u gaar ah ee. Si arrintan loo sameeyo:

• dayanayaan qoraalka ah ee caanaha la meel unugyada J19 J17 gacanta ah;
• waxaa lagu bedelaa in formula u gudbiyo J15 qiimaha cell J15: J7 + (J8-J7) * J11 / J13;
• Ku celi tallaabooyinkan ilaa formula la doonayo.

Isticmaalka spline

Habka Previous waa arrin eheeyn, sidaa daraadeed xaaladaha qaarkood interpolation spline doorbidaa. Excel In ay nuxurka ka kooban raadinta φ function interpolation (X) sida ay qaaciidooyinka nooca isla subsets kala duwan ee wax xuja ah. Dheeraad ah oo ku qaadeen φ xirtay qiimaha (x) iyo taagayo ay qiyamka xuduudda oo ka mid ah dood kasta oo subsets ah. In Excel ujeeddo this waxaa jira hawlaha gaarka ah iyo sidoo kale suurto gal ah in ay qoraan macros in VBA. Si kastaba ha ahaatee, waa in ay la abuuray shaqo gaar ah, si ay baadhitaan guud ahaan Macno ma sameeyneeyso.

Hadda oo aad ogtahay sida loo qoro formula ah ee Excel dual interpolating si sax ah ama si aad u ogaato qiimaha oo aan la garaneyn ee shaqada toosan iyada oo ka shaqeeya dhisay-in ama muuqaallo kale. Waxaan rajaynaynaa in macluumaadkan kaa caawin doona xalinta dhibaatooyinka badan oo wax ku ool ah.