How to write this equation?
조회 수: 3 (최근 30일)
이전 댓글 표시
Dear All, I have this equation in excel, what is the best way to write in matlab?
Y = 1.13+13/(1+EXP(7.57-15.5*LOG(x+0.0001)))
I tried this in matlab, but it did not give the same results for all values of x:
Y = 1.13+(13./(1+exp(7.57-15.5.*log(x+0.0001))));
x is a vector column of 200 values.
댓글 수: 2
Image Analyst
2019년 11월 26일
What values did x cover? Which of those gave a different value? Can you attach x in a .mat file or .xlsx file?
채택된 답변
Rik
2019년 11월 26일
There is a difference between log and log10. What you have done in Excel is actually calculate the log10, because you omitted the base as an input. The log function in Matlab computes the natural logarithm. If you want to have the same effect, either put EXP(1) as the base in Excel, or use this in Matlab:
Y = 1.13+(13./(1+exp(7.57-15.5.*log10(x+0.0001))));
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!