I am having trouble converting my data into a table and exporting it as an excel file.
Essentially, I am importing multiple .mat matrix files, and I am turning that data into basic statistical observations for each file. I wish to tabulate all of these values from a for loop.
Here is the simplified code I have so far
datadirectory = '/Users/name/Desktop/data/';
import = dir(fullfile(datadirectory,'*.mat'));
save_directory = uigetdir('/Users/name/Desktop/data/');
Data = load(fullfile(import(i).folder, import(i).name));
mean = mean(Data.importData, 'all');
stdev = std(Data.importData, 0, 'all');
median = median(Data.importData, 'all');
mode = halfrange(Data.importData);
fileName = strrep(import(i).name,'.mat','')
What I would like to do is make a table of the filename, its respective mean, and its respective standard deviation for each loop. I understand that you would have to use the "table(...)" function, however I am unsure how to convert looped results into it. I tried the following and it doesn't work.
tabData = table( filename(i), mean(:), stdev(:) )
Thank you all for your help!