Yuav Ua Li Cas Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB: 13 Cov Kauj Ruam

Cov txheej txheem:

Yuav Ua Li Cas Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB: 13 Cov Kauj Ruam
Yuav Ua Li Cas Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB: 13 Cov Kauj Ruam

Video: Yuav Ua Li Cas Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB: 13 Cov Kauj Ruam

Video: Yuav Ua Li Cas Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB: 13 Cov Kauj Ruam
Video: Musicians talk about Buckethead 2024, Tej zaum
Anonim

Txawm hais tias koj yog tus paub siv MATLAB lossis tshiab, koj yuav tsis paub txog MATLAB cov peev txheej teeb duab. MATLAB tso cai rau koj hloov kho yooj yim, daim ntawv lo, thiab txheeb xyuas cov duab, muab kev ywj pheej rau koj ntau dua li cov duab Excel ib txwm muaj. Txhawm rau siv MATLAB lub peev xwm teeb duab kom tiav, txawm li cas los xij, koj yuav tsum xub nkag siab cov txheej txheem rau kev xa cov ntaub ntawv. Cov txheej txheem qhia no yuav qhia koj yuav ua li cas ntshuam thiab teeb duab cov ntaub ntawv zoo hauv MATLAB.

Cov kauj ruam

Ntu 1 ntawm 3: Ntshuam Excel Cov Ntaub Ntawv rau MATLAB

Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB Kauj Ruam 1
Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB Kauj Ruam 1

Kauj Ruam 1. Qhib MATLAB Screen tshiab

Txhawm rau ua cov txheej txheem ntawm kev ntshuam thiab teeb duab cov ntaub ntawv yooj yim dua, tshem tawm cov ntawv hauv qhov hais kom ua qhov rai nrog cov lus txib clc ua.

Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB Kauj Ruam 2
Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB Kauj Ruam 2

Kauj ruam 2. Qhib koj cov ntaub ntawv Excel xav tau

Nco ntsoov sau lub npe ntawm daim ntawv Excel rau siv tom qab.

Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB Kauj Ruam 3
Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB Kauj Ruam 3

Kauj Ruam 3. Txuag Excel cov ntaub ntawv rau hauv koj daim ntawv MATLAB

Txoj hauv kev rau daim nplaub tshev feem ntau yog: C: / Users [koj tus account npe] Documents / MATLAB. Nco ntsoov tias koj khaws cov ntawv ua Excel Phau Ntawv Ua Haujlwm kom muaj cov ntaub ntawv tsim nyog rau kev ntshuam. Thaum cov kauj ruam no tiav, koj yuav tsum pom koj cov ntawv Excel hauv ntu ntu tam sim no hauv MATLAB.

Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB Kauj Ruam 4
Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB Kauj Ruam 4

Kauj Ruam 4. Nrhiav cov kab uas yuav raug xa tawm

Txheeb xyuas qhov ntau ntawm txhua kab ntawv yuav raug xa tawm. Qhov ntau ntawm kab ntawv yog thawj lub cell hauv kab ntawv mus rau lub cell kawg hauv kab. Cov txheej txheem tsim nyog rau thaj tsam no yog thawj lub cell ua raws los ntawm cov nyuv ua raws los ntawm lub xov tooj kawg (piv txwv li “B1: B30”)

Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB Kauj Ruam 5
Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB Kauj Ruam 5

Kauj Ruam 5. Ntshuam cov kab ntawv rau MATLAB

Nkag mus rau qhov hais kom ua var = xlsread ('filename', 'xlrange');

rau hauv qhov hais kom ua qhov rai rau txhua kab ntawv koj xav import. Hauv cov lus txib no:

  • Var yog lub npe sib txawv ntawm koj xaiv (Piv txwv: “x” lossis “y”)
  • Filename yog lub npe ntawm koj daim ntawv nthuav qhia zoo
  • Xlrange yog thaj tsam ntawm kab ntawv xav tau hauv daim ntawv "X-: X--", nrog X yog tsab ntawv ntawm kab ntawv tom qab tus lej ntawm tes.

Ntu 2 ntawm 3: Txheeb Cov Ntaub Ntawv hauv MATLAB

Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB Kauj Ruam 6
Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB Kauj Ruam 6

Kauj Ruam 1. Tsim daim duab

Nkag mus rau qhov hais kom ua p = phiaj (indep, dep1, indep, dep2) nyob rau hauv qhov hais kom ua qhov rai Hauv qhov lus txib no, indep yog qhov sib txawv ntawm tus kheej thiab dep1 thiab dep2 yog qhov sib txawv ntawm qhov sib txawv. Yog tias koj xav kom teeb duab ntau dua ob qhov kev hloov pauv, ua raws tib hom ntawv thiab ntxiv qhov sib txawv dep3. Yog tias koj xav teeb tsa tsuas yog ib qho sib txawv ntawm qhov sib txawv, tsuas yog teeb thawj thawj ntawm x thiab y qhov tseem ceeb (Piv txwv: phiaj (x, y1)).

Ntu 3 ntawm 3: Kho Cov Duab hauv MATLAB

Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB Kauj Ruam 7
Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB Kauj Ruam 7

Kauj Ruam 1. Hloov kab xim

Nkag mus rau qhov hais kom ua teeb (p, 'xim', '[Xav Tau Xim]');

mus rau hauv lub qhov rai hais kom hloov tag nrho cov kab sib txuas rau tib xim. Hauv qhov lus txib no, p yog siv rau qhov sib txawv koj teeb tsa koj cov phiaj sib npaug rau hauv qib 6. Yog tias koj xav hloov xim ntawm tsuas yog ib kab nkag mus teeb (p (x), 'xim', '[Xav Tau Xim]');

rau hauv kab hais kom ua. Tus x hauv p (x) yog tus lej uas sib haum rau qhov kev txiav txim uas cov kab tau npaj tseg hauv (Piv txwv: y1 = p (1), y2 = p (2)).

Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB Kauj Ruam 8
Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB Kauj Ruam 8

Kauj Ruam 2. Hloov kab ntawv

Nkag mus rau qhov hais kom ua teeb (p, 'LineStyle', 'style');

mus rau hauv lub qhov rai hais kom hloov tag nrho cov kab sib txuas rau tib yam. Yog tias koj xav hloov tus qauv ntawm ib kab nkaus xwb, nkag mus rau qhov hais kom ua teeb (p (x), 'LineStyle', 'style');

rau hauv kab hais kom ua. Hauv qhov lus txib no, x hauv p (x) sib raug rau tus lej uas cov kab ntawv tau muab piv (Piv txwv: y1 = p (1), y2 = p (2)). Cov kab uas nquag muaj xws li:

  • dashed kab = '-'
  • dotted kab = ':'
  • khoom kab = '-'
  • dash-dot kab = '-.'
Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB Kauj Ruam 9
Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB Kauj Ruam 9

Kauj Ruam 3. Sau koj lub axis

Txhawm rau x-axis, sau cov lus txib xlabel ('ntawv') nyob rau hauv qhov hais kom ua qhov rai Txhawm rau sau daim y-axis, nkag mus rau cov lus txib ylabel ('ntawv') nyob rau hauv qhov hais kom ua qhov rai

Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB Kauj Ruam 10
Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB Kauj Ruam 10

Kauj Ruam 4. Ntxiv lub npe rau koj daim duab

Nkag mus rau qhov hais kom ua title ('ntawv nyeem') nyob rau hauv qhov hais kom ua qhov rai Lub npe yuav tso tawm rau saum koj daim duab.

Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB Kauj Ruam 11
Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB Kauj Ruam 11

Kauj Ruam 5. Ntxiv cov ntawv hauv kab ntawv

Yog tias koj xav nkag mus rau cov ntawv nyob ze koj cov kab ntawv, sau cov lus txib gtext ('ntawv'). Thaum koj nkag mus rau qhov hais kom ua, tus cursor yuav tshwm rau ntawm kab lus tso cai rau koj nyem rau thaj chaw uas koj xav thov daim ntawv lo. Daim ntawv lo tuaj yeem muab tso rau txhua qhov chaw hauv kab duab.

Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB Kauj Ruam 12
Ntshuam, Duab, thiab Sau Cov Ntaub Ntawv Excel hauv MATLAB Kauj Ruam 12

Kauj Ruam 6. Ntxiv kab kab rau kab ntawv

Yog tias koj xav muab kab kab hauv kab lus rau koj kom yooj yim nyeem, nkag mus rau qhov hais kom ua daim phiaj mus rau qhov hais kom ua qhov rai Nkag mus rau cov lus txib dua yuav tshem tawm kab kab.

Kauj Ruam 7. Txuag koj daim duab

Nyem ntaub ntawv nyob rau sab saud sab xis ntawm MATLAB teeb duab ua raws los ntawm txuag as hauv cov ntawv qhia zaub mov. Txuag daim duab rau qhov chaw xav tau.

Pom zoo: