Finding the relationship between three columns
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
wesso Dadoyan
el 7 de Jun. de 2017
Comentada: wesso Dadoyan
el 7 de Jun. de 2017
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 comentarios
Respuesta aceptada
KSSV
el 7 de Jun. de 2017
Editada: KSSV
el 7 de Jun. de 2017
[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'})
Relation which is holding here is
GTA=GTAnom*108.6180/implGDPpricedefl);
2 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Financial Data Analytics en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!