用matlab求excel表中平均值,matlab如何将符合特定条件的数据导入excel并求出平均值...-CSDN博客

本文介绍如何使用Matlab从指定文件中读取数据，筛选符合条件的数据，并计算其平均值，最后将结果导出到Excel文件中。具体步骤包括设置工作路径、读取文件、数据处理及导出。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

matlab如何将符合特定条件的数据导入excel并求出平均值

% outline %step_1 clear %step_2 CurrentWorkingPaht %step_3 a Matrix_r %step_4 Loop getting the 20 close and far values %step_5 writing the Matrix_r into the Excel % clear clc;clear; % currentworkingpath CurrentWorkingPath = fileparts(mfilename( fullpath )); Filename_result = [ result_selectionA_1.txt ]; % set a Matrix_r Matrix_r = zeros(20,2); for i = 1:20 tmpPathname = sprintf( %s\\sub%d\\%s ,CurrentWorkingPath,i,Filename_result); [Col_1 Col_2 Col_3 Col_4 Col_5 Array_type Array_RTs Array_ACC] = textread(tmpPathname, %d%d%d%d%d%d%d%d , delimiter , ); doubleC_Mat = [Array_type Array_RTs]; Matrix_r(i,1) = mean(doubleC_Mat(doubleC_Mat(:,1)12,2)); end % writing into the excel file success = xlswrite( student_update.xls , Matrix_r, sheet1 , B2 ); Series = 1:20; Series = Series ;Conditionnames = {[ student_ID ] [ Close ] [ Far ]}; success = xlswrite( student_update.xls , Series, sheet1 , A2 ); success = xlswrite( student_update.xls , Conditionnames, sheet1 , A1 );