Vector values replaced by zeros

Hello everyone.
I'm working with a dataset (excel file with columns of different variables, with a lot of values for each of them) and trying to do regressions, but i'm facing a problem : when i run vectors that contain values bigger than 1, then matlab seems to replace all values by zeros. Here is a piece of my code:
"
MMData=dataset('XLSFile', 'DescriptiveStatsCorrectedV4.xlsx');
A=MMData.roa;
B=MMData.assets;
C=MMData.roe;
D=MMData.percfemborrowers;
"
A (roa) and D (percfemborrowers) have only values <1 (in absolute value), so no problems with them.
B (roe) and C (assets) have values >1 (in absolute value), and this is what matlab diplays for them for example :
0.0000
0.0000
0.0000
-0.0000
-0.0000
Could someone help me? Thanks
ps : A weird fact : calculating the mean of one of this vector (ex: for C) still works...

답변 (1개)

James Tursa
James Tursa 2015년 3월 18일
편집: James Tursa 2015년 3월 18일

1 개 추천

The values in all likelihood are not exact 0's, they just display as 0's to the precision that is printed. To print more digits, e.g.,
format long
or
format long g
Also pay attention to any exponent that appears at the start of the display. E.g.,
>> a = [1 1e-7]
a =
1.0000 0.0000 % a(2) displays as all 0's
>> a(2)
ans =
1.0000e-07 % but a(2) is really the original 1e-7 value
>> a*10000
ans =
1.0e+04 *
1.0000 0.0000
>> format long g
>> a
a =
1 1e-07

댓글 수: 2

Dan Pron
Dan Pron 2015년 3월 18일
"long g" seems to work fine!!
Thanks you very much!
Image Analyst
Image Analyst 2015년 3월 18일
Would you mark this as "Accepted" and "Vote" for it to give James "reputation points"?

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

카테고리

도움말 센터File Exchange에서 Entering Commands에 대해 자세히 알아보기

질문:

2015년 3월 18일

댓글:

2015년 3월 18일

Community Treasure Hunt

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

Start Hunting!

Translated by