find average of x and y values separatly of excel file in Matlab.

1 次查看（过去 30 天）
Tahir
Tahir 2014-5-24
编辑： Azzi Abdelmalek 2014-5-24
Hi, I read an excel file...now i want to one by one take the x values and y values from that excel file.....The x values are at the first column,and y value are in the second column..and similrly again x value at 3rd column and y value at fourth column...i applied two nested loops...but i can not the x and y value...plz help....here is the code
file = xlsread('TrainingDataset\1.csv');
sizeF=size(file);
rows_F=sizeF(1); % number of rows in file
cols_F=sizeF(2); %number of column in file
for i=1:rows_F
xSum=0;
ySum=0;
n=0;
for j=1:cols_F
xSum=xSum + file(:,j); % How to get x values here and y value after this.
ySum=ySum + file(:,j);
n=n+1;
end
% find the averge of x and y values separtly
divider=n./2;
centre=zeros(i,2);
centre(:,1)=xSum ./ divider;
centre(:,2)=ySum ./ divider;
end
please help

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

采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2014-5-24
编辑：Azzi Abdelmalek 2014-5-24
M=randi(10,4,6)
x=M(:,1:2:end)
y=M(:,2:2:end)
average_x=mean(x(:))
average_y=mean(y(:))

更多回答（0 个）

类别

在 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