필터 지우기
필터 지우기

comparing results from matlab calculation with a table from excel

조회 수: 2 (최근 30일)
badrul hisham
badrul hisham 2016년 4월 10일
댓글: John D'Errico 2016년 4월 10일
hi, i have a set of data saved in excel and i need to compare it with the calculation result from matlab.in my situation, i have calculated the height and get 54 inches, next i got 1.65 of trunk index,71lbs, and a value of 4. I need to find which row 54 inch is at(as you can see there are 9 rows which contains the number 54),out of all the 54 inch,find where the 1.65 of trunk index is at,next find whether value 4 is in column endo,meso,ecto or balanced.the final result would show the name of the category. for example, in row 9 of the excel, it is 54 inches,1.65 trunk index,and 4 is meso. so the output would say that the category is meso. can someone please show me how to do this? inches,trunk index and value 4 are my input from several calculations. i have attached together the excel file and an image. please help me, thanks in advance
  댓글 수: 2
dpb
dpb 2016년 4월 10일
Can you be sure there is and exact match on the three variables of Ht, Tidx, Wt? Matching floating point computation exactly is fraught with danger firstly, and secondly; would require a pretty good computational correlation to hit the values identically it would seem. What if you get 54, 1.63 and 70, instead? Or, even if the first three are somehow constrained to be in the precise bins and in those particular relationships, will the last be identically one of the specific choices?
John D'Errico
John D'Errico 2016년 4월 10일
And of course, the fear is that your computation would yield 1.6499999999999... which IS less than 1.64.
It is always important to watch for floating point errors.

댓글을 달려면 로그인하십시오.

답변 (0개)

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

제품

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by