WORDWORD版本WORDWORD版本一、langmiur模型擬合1輸入數據，繪制散點圖@OrninPra85-T@OrninPra85-TAE口齒.JUNTTREC

一」FolJerlmLongNameLinnsCommenis10.34EI23344）.C-：25 fl_ Q死4B7Bgioii121?15151T10192D212223242526272選擇langmiur模型開始進行擬合Analysis>Fitting>NonlinearCurveFit>OpenDialog（這一步可直接用快捷鍵ctrl+Y）3選擇langmiur模型，注意核對公式是否一致，一致可直接采用，不一致需另外自行編輯公式，這里示公式一致的模型擬合操作方式，編輯公式請參考下面的Freundlich模型擬合方法步驟

根據langmiur公式，需要將參數c設置為04點擊Fit，出現：ReminderMessage□oyou'A-：iTLttoswitcht*+h&Te與ariddothee：=jtihinthe￡口七ur嘲/nc立已史&to：=le1:電弓二elld_.1WIL"：=ltl(1demtbotherme智1七}lt?iieacairi.IotT'（目前沒發現Yes或No有什么不同……）擬合結果如下：-N口麗日4CubeFH05ngm向EXTD《20?移也?我6:07)彳Wofes*參數值在這里fflinputDafaT參數值在這里iQ^alIlBT-alnna-n*0Ftidn忒converge-pgrarKtcrts}bhenedde口kbin市aiisd.Hmsc：checkandcorrectther^nluw.Sfafrs/i-cs-IBNumtJflraTPDlntGBNumtJflraTPDlntG013gg『gtis；ofFraedDirii0Reduced!Chi-8qr0R0sidiij；aiSumurs3uaeg0Adj.R-Equare0Fil:SlatusFailed(-103)相關度在這且，越接近1越好Ft5t■Blum :T33:FtdidKtcanYeffie-Narine盟n：￡it-arenotcrc&e：如inHisJicedLPhasechuck3ndoore用tbtryoJdu-Somma/yTat> cStatisticsValueStandardErrorValueStandardEjtdfValueStandardErrorRGduc@dlChl-SqrAdj.R-SquareB06f4 -—— Q 一aD-ANOVA□FSumDTsquaresMeansquareFvalueProb>FRecression3Z021E60.67395tfflNF0pResidual2□□uncorrectedTotal52.D2186CorrectedTotal40.11D75因為示數據是我隨便選的，數據并不好，所以無法擬合5將模型與散點圖組合

1AltXI)同A3CX2]的A4(￥2j aLongNam^iidcptniJeiilvuiltiEjIeLailOrriullE.KT1Fi|yr&|itcl.lBjindependentVariableRegularResidualorsneeN日ParametersFinedcurvespi01i1-8.074I07E-30110.34521D7Q71-flE4497E-3013D.7B93彳-92159600140.693d1.21212-^.7B676E-3Q170.61D25120233-1D3577E-30Da0.6E46 135354-1.09295€-30Q71.42124-1.14994E-30D31.49495-1.2D703E-3J3D156566-1.2E412E-30D101.63636-1.^121E-30D111.70707-1.3783E-30D121.77770T43519E-30D1310-S94B二149248E-.3￡^M1.9191!?-1.549S7E-3QD1E1.9899-160666E-30D16 206061?1,6637^-30Q172.13131-1.72084E-3QDia2.20202-1.77793E-30Dig257273-1,B35Q2E-3JJD20234343二[B9211E-30D212J1414-1.9JI92E-30D22248435-2DDSME-30DZ3 25555b?2.Qg"E-30Q2-42.6262B-212046E-30D筆2.69697-2177S5E-3002627B76G-2.22464E-30D272.0383B-229173E-3aD232.90909-234882E-30D我297gs-24D591E-30D30J05051-246非國口31工12121-252009E-3aD32119192-257713E-30D33 3擊-3■Z534Z7E-30Q刈3.33333-2B0135E-3OD353J0404-274S45E-30D3S347475-ZBD554E-30D37J545^5-2B6263E^0333.61S1B-251972E-30D3g160697-2J97GeiE-30D40 3-57M-3D3399E-3￡2413.S282B-3.DD093E-3aD42上893gg-3.140O7E-3OO423.9697-22D516E-30D一一 Hn皿十nwuuinnJ\SheetL/FilHLL'FitnCurEj把這里的數據全部復制，去sheetl里面粘貼，記得重新setXIACX1)0(Y1)C(X2)D(Y2)E{X3)研）G(X4)Hg)LongNameunitsCDTiments110.345-8.Q74I07E-3012J07S91.07071S04497E-3O1340.693--.14141■921536E-301470.61D21.21212-9.7S676E-301&a0.6541.282S^-t02577E-30D01.353S4-1.09295￡-20371.42般4.1.H994E20J31.395-1.20703E-30D9-.5656B-1264-12E-203101.63636-1.32121E-30D111.7D7D7-117a3E-3DD121.77770-1.43539E-30D131.9404B■1.49246E-30D141.91919-1.54957E-30D151.9399-1WfflflE-M'D162.06061-1.66J75E-303172.13131-1.72084E-30D182.20202-177T93E-30D192.27273-1.9J5O2EJ0D202.34343-1.39211E-30D912.4141.4.-194.92E-30D將所有的模型擬合數據輸入后，回到圖像，用自己擅長的方法，在原有散點圖上添加數據

n3- ■ . . ? . . . . , . .n3M-I|I|I|I|I|I|I|I|I TMO1￡3456709A下面提供兩種添加數據的方法，即把模型圖與散點圖結合創建圖層法：.Dr^mProE.5-Q^UMUTLEDT-fradirl/-j^rapkl],+0?? -3tieEditViewCir-JiphCWsinaiysitGsdg上TookFormal：VMind*Help口臼曲混的磁固度區二宮扇口日偏巡*d球卜g-沙史國朝目f%#1301城中laEl"EgL6回口匕世『3'也?，GCc^>hFf]口里-￡I—1-- i才士|lMxt—am1口器吃 CEZI 點拈斛新的律

12k新圖層右避單擊.選擇C。merits0.8-言siiXVAAvailableDataDeleteJkcriklkbook.1fCancelLaperProperties...PlotSetup...UngraupEditBsnge...ShowRange

,RescaleanOK0.7-言siiXVAAvailableDataDeleteJkcriklkbook.1fCancelLaperProperties...PlotSetup...UngraupEditBsnge...ShowRange

,RescaleanOK將df都放進右邊，然后點擊OKwordword版本WORDWORD版本2直接添加數據法：現在表格處選中所需要添加的數據，記得設置X（列表單擊右鍵）A(X1)B[Y1>C{X打D(Y2)Eg)F[Y3>LongNameUnitsComments110.3451-S.07407E-30-110.4-8215230.7891.07077]-S.64497E-30-11.07077]0.4-8S2S340.6931.14141-9.21^EE^0-11141410.4-9409470.6-1021.21212-9.m7EE^0-11.212120.4-9962580.6&41.23283刁演沅百而1.232830.504S961,35354-1.09^5E^0O1.3535405099371.42424-1.14994E^OO1.4242405147501.49495-1.20703E^OO1.4949&05193991.56566-1.26412E^OO1.56566]0.523S5101.656^61-32121E^01636350.52515111.7Q707-1.37B3E^OO1.707070.532312C7777回-1.43539E^OO17777810.5363113184848-1.+9248E^OOT84S480&402141.91919-1.54957E^OO1919190.54395回到圖形的頁面選擇Gragh>AddPlottoLayer>Line完成二、Freundlich模型擬合（自定義公式擬合教程）1從上述第2步開始，選擇自定義公式2創建公式WORDWORD版本WORDWORD版本會出現以下頁面：Conpile?JFileEditViewToolsWindowHelpIWTEFEIE?ISSI一行人I?dII"工「II口I廠I□:.喃Untitled-CedeBuilder-LnlfFreLJndlichSample]顯示Dcine,就是OK了“配芭iJini帕ofeditablepart-a+K-(1/i)//IndofQditablepart]// v口m_n]gfEreniDd1ichsanplet//FitrarameterCs)：doublea?doubleb?KInileperrtsnt^ariablets)：rtoutiles, .//DependentYariable(s)：doublsiy)^Linking...Doihb!Usd0,6or-3/2.0togettheczirrect7a.lug.ForuareiJiloimatLoiianle?;aniple5?pleaserefertothe'Uffir-BefineiFittiJisFujiction""sectionoftieOrisinMbLtpiling^.nlfFreunrtlichSairnple.fitDoneJ匾世.etxirntoDial口然后關掉點OK，保存FundtianOrg^iriizErE-Ihgfnm一H；由5皿亡fflWyjwb□1kffiLdgktiLlunffi二JFqakFunjcti田 FQl^rtani石FundtianOrg^iriizErE-Ihgfnm一H；由5皿亡fflWyjwb□1kffiLdgktiLlunffi二JFqakFunjcti田 FQl^rtani石E二JFxwEi二jRMibddl,1Vgict出_JEkpoowntiiLEl_JGrurrlb/Sis力dalE二JIThrun-itflgriph^E二JElacttrophyslol口gyE FliArn-Leal0jyS SpecifC'scopjfEl-JticsE二JQuickFit~IUsfltrD&fin.a1E二JL皿狗uitEOhyy匡口DLXBitionalOSineE二IHwCdts￡orpg■如fmujwili心.■國際其電留Fgeti.%fVsar)PgfEm已&巴■Eetinngs：Usn-LaUefLiLtthefimctnaiimlththefim口fU