Sanaike mu kupambana: Features, njira ndi zitsanzo,

Excel spreadsheet limakupatsani msanga osati kokha kupereka zosiyanasiyana anapezazo, komanso kuthetsa ntchito m'malo ovuta. Mwachitsanzo, angathe kuchitidwa ntchito mawerengeredwe masamu zochokera pa amatsogoza apawokha cha ntchito yake, kuphatikizapo ntchito kupeza phindu wapakatikati ndi sanaike. Mu kupambana kwa cholinga ichi amapereka zipangizo zosiyanasiyana ntchito akuphunzitseni nkhaniyi.

Sanaike Njira: ndichiyani?

Mu otchedwa n'zosangalatsa kumva kusanthula njira kupeza mfundo zokhwima pa ntchito osadziwika Y (X) a akonzedwa apawokha ya kale.

The sanaike ntchito Y (X) angathe kuchitidwa okhawo zifukwa zake, amene ali mkati imeneyi [X _0, X _N], ngati kuti khalidwe Y (X ₀₎ ndi Y (X _n).

Ngati X sikuli kwa [X _0, X _N], n'zotheka ntchito extrapolation njira.

Mu chiphunzitso chakale sanaike vuto chofunika kupeza pafupifupi analytic ntchito φ (X), imene mfundo pa mfundo nodal X _ine ali ndi makhalidwe Y (X _i) ku gome gwero, mwachitsanzo. E. Potsatira chikhalidwe _{φ (X i) = Y ine} (i = 0,1,2, ..., n).

Liniya sanaike mu kupambana

Wotchuka spreadsheet ntchito ku Microsoft pali zothandiza kwambiri woyendetsa "Mapa".

Taonani deta m'magulu tebulo pansipa.

Mu ndime yoyamba mfundo ×, ndipo chachiwiri - phindu lokwanira ndendende a liniya ntchito f (x). Tiyerekeze kuti tiyenera kudziwa kufunika kwa mtsutso wa × = 28. Kuchita izi:

• kuonetsetsa aliyense purosesa selo akusowekapo pa tebulo pepala, kumene zotsatira zake zidzakhala linanena bungwe kuchokera kukhazikitsa kanthu Mwachitsanzo C1;
• kutsamba pa chizindikiro «FX» ( «Ikani ntchito"), anaika kumanzere kwa chilinganizo bala;
• mu bokosi "ntchito Master" alowe m'gulu la "masamu";
• kupeza woyendetsa "Mapa" ndipo alemba pa «Chabwino».

Mu mfundo 3 gofu. Woyamba kiyibodi athandizira mtengo kukangana (ndi ntchito yeniyeni 28). Pofuna lembani "odziwika mfundo _ Y», alemba pa mafano ndi muvi wofiira kumanzere kwa zenera ofanana ndi kumasula m'dera yoyenera pa chipepalacho. Pa nkhani zosiyanasiyana, gawo ili la maadiresi ndime mu osiyanasiyana B2: B7.

Mofananamo, lembani "makhalidwe amadziwika _ ×" ndipo dinani "Chabwino" batani.

Chifukwa, mu khungu anasankha C1 chimaonetsedwa 176, yomwe ndi chotsatira chake cha ndondomeko sanaike.

Graphic Njira: Kukonzekera

Sanaike kuti kupambana, chitsanzo cha lopatsidwa pamwamba, ndi njira yokhayo yodziwira zosadziwika mfundo zokhwima pa ntchito Y (X) a akonzedwa apawokha a kale ayi. Makamaka njira mawonekedwe angagwiritsidwe ntchito. Zingakhale zothandiza ngati tebulo mmodzi wa mfundo mwachindunji ntchito mtengo lolingana monga amene ali pansipa (onani. Selo ndi adiresi B9).

Sanaike mu kupambana mu nkhani iyi imayamba ndi ndandanda yomanga. Kuchita izi:

• mu tsamba la "Amaika" akutali tebulo osiyanasiyana;
• mu chida chipika "Charts" anasankha mafano "Chithunzi";
• mu mndandanda limapezeka, sankhani yabwino yoti cholinga chinachake.

Popeza selo B9 ndandanda kanthu kuti anang'amba. Komanso, alipo zina mzere X, omwe si koyenera, ndi olamulira yopingasa m'malo mfundo ya mtsutso wa zalembedwa mu dongosolo la mfundo.

Sanaike mu kupambana: chisankho likutipatsa njira

Tiyeni zithunzi processing. Pakuti ichi zimatulutsa mosalekeza buluu mzere ndi kuchotsa izo ndi kukanikiza Chotsani, umene uli kiyibodi.

ndiye:

• kuonetsetsa ndege limene Zithunzi;
• kusankha batani "Select Data ..." ku menyu nkhani;
• mu "Sankhani Data Gwero" mu bokosi lamanja, atolankhani "Change";
• alemba pa mafano ndi muvi wofiira lamanja la kuthengo "zolemba manambala olamulira";
• kuonetsetsa A2 osiyanasiyana: A11;
• alemba pa batani «Chabwino»;
• kachiwiri chifukwa zenera "Data Gwero Kusankha";
• alemba pa batani "Obisika wachabechabe Maselo" mu ngodya wamanzere;
• mu "Show Chopanda Maselo" mzere lophimba ndi kuwayalanso mu "Line" malo ndi akanikizire «Chabwino»;
• atsimikizire zimenezi m'njira yomweyo.

Ngati mwachita bwino, kusiyana adzachotsedwa, ndi anasamutsa cholozera mpaka Napempha kwa Zithunzi mudzaona mfundo lolingana mfundo ndi ntchito.

Ntchito yapadera ntchito na-

Tsopano inu mukudziwa momwe mungachitire ndi sanaike mu kupambana njira mawonekedwe kapena ndi woyendetsa "Mapa", yankho la mavuto ambiri othandiza kwa inu kuti akhale ovuta. Koma si onse. Spreadsheet pulogalamu kwa Microsoft ndi kupeza phindu osadziwika a ntchito ndi ntchito LP ntchito.

Musamachite ndandanda kale anamanga, izo wakhazikitsa chizindikiro olondola lonse lapansi. Tiyeni tiyese kutseka lisaoneke. Kuchita izi:

• Table akutali maselo amene sadziwa kufunika ntchito;
• kusankha chizindikirochi "Ikani Limagwira";
• mu "Ntchito mfiti" mu bokosi "Categories" kupeza chingwe "Full afabeti mndandanda" (m'mabaibulo ena a purosesa "Fufuzani katundu ndi makhalidwe");
• dinani kulowa "na-" ndi kugwedeza batani «Chabwino».

Pambuyo pake, mu B9 selo limapezeka phindu zolakwa "# N / A." Komabe, Zithunzi lotseguka ali basi inathetsedwa.

Mungachite kwambiri chabe: kuti kiyibodi mu zophiphiritsa selo B9 "# N / A" (popanda zotchingira).

bilinear sanaike

Osiyanasiyana ntchito imene mungagwiritse ntchito kayeseleledwe mwa ntchito za variable wina, okha. Choncho kuganizira mmene mfundo ndi sanaike awiri ntchito kupambana. Zitsanzo zikhoza kukhala zosiyana kwambiri. Mwachitsanzo pali tebulo (onani m'munsimu.).

Ndi chofunika kuwerengera kuthamanga mphepo pa mtengo wa kutalika kwa 300 mamita pa msinkhu wa mamita 25.

Tebulo kuwonjezera zolemba zatsopano monga tikuonera chithunzi (onani. Mmunsimu).

Zikuoneka anawonjezera kuti kutalika selo ndi chikhato mu J1 ndi J2.

Ndi n'zosiyana yotsatana M'MALO "anasonkhanitsa 'megaformulu tipeze kuthamanga mphepo pa magawo enieni. Kuchita izi:

• kukopera lemba la chilinganizo ndi malo khungu mu khungu J17 J19;
• m'malo mwa chilinganizo amanena kuti J15 kuti J15 mtengo selo: J7 + (J8-J7) * J11 / J13;
• Bwerezani njira izi mpaka chilinganizo ankafuna.

kugwiritsa spline

njira Previous ndi wolemera kwambiri, choncho zina bwino spline sanaike. Excel Kwenikweni ake tichipeza kupeza sanaike ntchito φ (X) monga mwa mitunduyi a mtundu womwewo kwa subsets osiyana wa mkanganowo. Komanso anagwira atazikocheza mfundo φ (x) ndi ena ofanana pa mfundo malire a mfundo iliyonse ya subsets lapansi. Mu kupambana kwa cholinga ichi pali ntchito yapadera komanso zotheka kulemba macros kuti VBA. Komabe, iwo ayenera analenga ntchito yeniyeni, kotero phunziro lawo zambiri sizimatanthauza.

Tsopano inu mukudziwa momwe kulemba chilinganizo cha sanaike awiri mu kupambana molondola kapena kupeza phindu osadziwika wa ntchito ya liniya kudzera anamanga-mu ntchito kapena zithunzi. Tikukhulupirira kuti zimenezi kudzakuthandizani kuthetsa mavuto zambiri.