| 24小時熱門版塊排行榜 |
| 2 | 1/1 | 返回列表 |
| 查看: 320 | 回復(fù): 1 | ||
chenming7899木蟲 (初入文壇)
|
[求助]
如何進(jìn)行非線性方程擬合?
|
|
審稿人提出要采用非線性方程進(jìn)行擬合。如何用 Excel來擬合? 編輯的話 one should never compare SD nor R2 for fits in different coordinates. Determination of parameters and comparisons of fit quality should be performed for the same definition of data deviation. When common (nonweighted and not orthogonal) LSQ fit is performed for any Y-value (minimization of Sum[(Y_exp-Y_fit)^2]) it corresponds to the assumption of constant statistical deviation of Y (i.e. SD(Y) does not depend on X or Y) with Gaussian distribution. If any kind of data transformation is used to obtain linear plot, then this assumption is no longer valid. E.g. LSQ in the linear Freundlich plot (log coordinates) corresponds to the assumption that in your system SD(q)/q = const (not SD(q)=const) an d for the linear Langmuir plot (i.e. 4 linear Langmuir plots) it is even more complicated. The only way is to use non-linear fitting (e.g. with free Solver module present in Excel and Open/LibreOffice) – or better yet, weighted non-linear LSQ - and reserve linear plots for presentation purposes. 理科出身,沒學(xué)過。請各位大俠幫忙。 |
金蟲 (小有名氣)
|
1. ?????????????????????????Langmuri model ???е????????Freundlich model ????????????????????????????????????Excel?e???????w???????????@?N??????С??x????W???????????? 2. ????????????^?}?s????????????????t????????N???????(Origin??1stOpt??Matlab??SPSS??R??Statistica......)?e?????????????M?????????P????????y????? ?????Y????o?????????? [???]?????????????????????????????? ???? 1stopt ???????? ?????@?治??Global fitting?? http://www.gaoyang168.com/bbs/viewthread.php?tid=4586018&fpage=1 1stOpt ?????? - ?????? http://www.7d-soft.com/files/1stOpt%20Manual.pdf 3. ???о??????????????????Z??????????W???????H?? |
| 2 | 1/1 | 返回列表 |
| 最具人氣熱帖推薦 [查看全部] | 作者 | 回/看 | 最后發(fā)表 | |
|---|---|---|---|---|
|
[考研] 085701環(huán)境工程求調(diào)劑 +8 | 多久上課 2026-03-27 | 8/400 |
|
|---|---|---|---|---|
|
[考研] 266分,求材料冶金能源化工等調(diào)劑 +5 | 哇呼哼呼哼 2026-03-27 | 7/350 |
|
|
[考研] 070300化學(xué)求調(diào)劑 +4 | 起個名咋這么難 2026-03-27 | 4/200 |
|
|
[考研] 265求調(diào)劑11408 +3 | 劉小鹿lu 2026-03-27 | 3/150 |
|
|
[考研] 材料292調(diào)劑 +12 | 橘頌思美人 2026-03-23 | 12/600 |
|
|
[考研] 287求調(diào)劑 +10 | land xuxu 2026-03-26 | 10/500 |
|
|
[考研] 一志愿211,335分,0856,求調(diào)劑院校和導(dǎo)師 +4 | 傾____蕭 2026-03-27 | 5/250 |
|
|
[考研] 0703化學(xué)一志愿南京師范大學(xué)303求調(diào)劑 +3 | zzffylgg 2026-03-24 | 3/150 |
|
|
[考研] 材料調(diào)劑 +8 | 匹克i 2026-03-23 | 8/400 |
|
|
[考研] 求調(diào)劑 一志愿 本科 北科大 化學(xué) 343 +6 | 13831862839 2026-03-24 | 7/350 |
|
|
[考研] 281求調(diào)劑 +3 | 亞克西good 2026-03-26 | 5/250 |
|
|
[考研] 化學(xué)工程085602 305分求調(diào)劑 +17 | RichLi_ 2026-03-25 | 17/850 |
|
|
[考研] 289求調(diào)劑 +17 | 碩星赴 2026-03-23 | 17/850 |
|
|
[考研] 309求調(diào)劑 +4 | gajsj 2026-03-25 | 5/250 |
|
|
[考研] 一志愿哈工大,085400,320,求調(diào)劑 +4 | gdlf9999 2026-03-24 | 4/200 |
|
|
[考研] 26考研-291分-廈門大學(xué)(085601)-柔性電子學(xué)院材料工程專業(yè)求調(diào)劑 +3 | min3 2026-03-24 | 4/200 |
|
|
[考研] 0854電子信息求調(diào)劑 324 +4 | Promise-jyl 2026-03-23 | 4/200 |
|
|
[考研] 276求調(diào)劑 +3 | YNRYG 2026-03-21 | 4/200 |
|
|
[考研]
|
2117205181 2026-03-21 | 8/400 |
|
|
[考研] 求調(diào)劑 +3 | .m.. 2026-03-21 | 4/200 |
|