How can I calculate mean on matlab gui?

2 次查看（过去 30 天）
RIDVAN BICER
RIDVAN BICER 2016-10-12
评论： Image Analyst 2016-10-14
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.

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

回答（2 个）

Eamon
Eamon 2016-10-12
编辑：Eamon 2016-10-12
You should be able to use the xlsread function to load the Excel file into Matlab. You can use the mean function and the standard deviation function to calculate those parameters.
  6 个评论
显示 4更早的评论
RIDVAN BICER
RIDVAN BICER 2016-10-14
okey if I want make just one button how can I make it?

请先登录，再进行评论。

Image Analyst
Image Analyst 2016-10-13
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 个评论
RIDVAN BICER
RIDVAN BICER 2016-10-14
okey if I want make just one button how can I make it?
Image Analyst
Image Analyst 2016-10-14
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/

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by