maintain string in a cov matrix

1 view (last 30 days)
fede
fede on 22 Sep 2015
Commented: Matt J on 5 Nov 2015
Hi I want to know if it's possible maintain the name of my stocks in the var-cov matrix. If I have a matrix as dataset, for example:
IBM JPM C
p11 p12 p13
p21 p22 p23
...........
pn1 pn2 pn3
it's not possible calculate the var-cov matrix untill I transform my dataset in matrix, but lossing my string (ibm ecc ecc).

Accepted Answer

Kirby Fears
Kirby Fears on 22 Sep 2015
Edited: Kirby Fears on 22 Sep 2015
fede,
Your data can be stored in a table. Tables allow you to operate on numeric values while also keeping column headers to easily interpret your data.
If you are getting data from a delimited text file or Excel file, try using the readtable function so your data is in table format. If this is not an option, you can transform data from your workspace into a table.
Below is example code for building a table out of workspace data (a numeric matrix and cell of headers).
testdata = magic(3);
stocks = {'ibm','jpm','etc'};
tabledata = array2table(testdata,'VariableNames',stocks);
Hope this helps.

More Answers (0)

Categories

Find more on Statistics and Machine Learning Toolbox in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!