MATLAB: Importing data from excel and losing precision

excel importrounding error

I am importing data from excel, and it is only importing to the 3rd decimal place. I have tried formatting long to no avail, example: from excel 7.369487E-10 becomes 1.0e-09 * 0.737. Is it because of the E-10 that it will only import to this precision? When it is formatted long it shows 1.0e-09* .73700000000. It is an array that I am importing and I am comparing averages of the array in matlab and excel and they are not matching up for this reason, thanks

Best Answer

the problem was I was using xlsread on a csv file, once i changed the file back to a xlsx file i was able to retain all of the decimal places.

Related Solutions

MATLAB: Lose of Precision when storing values

What do you mean, you loose precision? I guess you mean the numbers displayed in the command window, such as

x=[1e7 1.1]
x =
     1.0e+07 *
      1.0000    0.0000

No worries here, of course the second value is still 1.1, it's just not displayed:

>> x(2)
ans =
      1.1000

If you want to get more digits displayed, check out the format function:

>> format long
>> x=[1e7 1.1]
x =
     1.0e+07 *
     1.000000000000000   0.000000110000000

Hope this helps!

MATLAB: Losing Format on import.

use readtable() to read the excel file

Best Answer

Related Solutions

MATLAB: Lose of Precision when storing values

MATLAB: Losing Format on import.

Related Question