Finding the relationship between three columns

Question

wesso Dadoyan 2017-6-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/343649-finding-the-relationship-between-three-columns

评论： wesso Dadoyan 2017-6-7

Sample.zip

I have a data set (attached in zip) downloaded from a database. the first column(date)is the dates column, the second is the id of the firm (RSSD9001), the third is GTA which is the total assets in real term, the fourth(GTAnom) is the nominal total assets and the fifth (implGDPpricedefl) is the implicit GDP price deflator. The relationship between GTA and GTAnom should be theoretically as follows: GTA=GTAnom*(100/implGDPpricedefl); the results however don't match. Is it possible using matlab to find the relationship between GTA,GTAnom and implGDPpricedefl using this long series of data using any kind of solvers?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

KSSV 2017-6-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/343649-finding-the-relationship-between-three-columns#answer_269836

编辑：KSSV 2017-6-7

在 MATLAB Online 中打开

[num,txt,raw] = xlsread('Sample.csv') ;
gta = num(:,2) ;
gtanorm = num(:,3) ;
impl = num(:,4) ;
%%actual relation
lhs = gta ;
rhs = gtanorm*100./impl ;
%%Get factor 
fac = gta.*impl./gtanorm ;
% fac = uniquetol(fac,0.1)
rhs1 = gtanorm*max(fac)./impl ;
%%plot
figure
hold on
plot(lhs,'.r') ;
plot(rhs,'.b') ;
plot(rhs1,'Ob') ;
legend({'GTA','old relation','Newrelation'})