How can I calculate mean on matlab gui?
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Hello,
I need to know, how I get data from excel to GUI and calculate this data's mean and standard deviation. This data is one coloumn and 8760 line. Thanks.
0 comentarios
Respuestas (2)
Image Analyst
el 13 de Oct. de 2016
Try this:
% Have user browse for a file, from a specified "starting folder."
% For convenience in browsing, set a starting folder from which to browse.
startingFolder = 'C:\Program Files\MATLAB';
if ~exist(startingFolder, 'dir')
% If that folder doesn't exist, just start in the current folder.
startingFolder = pwd;
end
% Get the name of the file that the user wants to use.
defaultFileName = fullfile(startingFolder, '*.xls*');
[baseFileName, folder] = uigetfile(defaultFileName, 'Select a workbook file');
if baseFileName == 0
% User clicked the Cancel button.
return;
end
fullFileName = fullfile(folder, baseFileName)
% Open Excel workbook:
[numbers, strings, raw] = xlsread(fullFileName)
% Extract column 1 (or whatever).
col1 = numbers(:, 1);
% Compute mean and standard deviation, or whatever
theMean = mean(col1);
stDev = std(col1);
If you want to, you can put that all into two separate button callbacks, but it's a little more complicated, so if you go that route, you'll need to study the FAQ: http://matlab.wikia.com/wiki/FAQ#How_can_I_share_data_between_callback_functions_in_my_GUI.28s.29.3F
2 comentarios
Image Analyst
el 14 de Oct. de 2016
Just use GUIDE to place a button on the GUI, then right click and say View Callback. It will throw you into the editor. Then you can write your code into that function. See the GUIDE tutorial for further instructions: http://blogs.mathworks.com/videos/category/gui-or-guide/
Ver también
Categorías
Más información sobre Spreadsheets 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!