Average over repetitions in Excel table

版本 1.0.0.0 (12.9 KB) 作者: Wei-Rong Chen
Read Excel table and average the data over unnecessary factors (repetitions)
126.0 次下载
更新时间 2015/4/11

查看许可证

% Read Excel work sheet and average the data over unnecessary factors (repetitions).
% 'IndepVaribles' lists all the reserved factors, which will remain in the output.
% Those columns not included in as 'IndepVaribles' are considered as 'repetitions'.
% Data columns will be automatically detected (Search for columns containing numerical data from the last column).
%
% Example:
% IndepVariables={'Subj','Target'}; XlsFName = 'data.xlsx';
% NewXlsCell=ReadXlsAverageAcrossRep(XlsFName, IndepVariables);
% Input Excel sheet :
% --------------------------------------------------------------------
% Subj Target FName data1 data2 data3
% F01 p R001 2 2 2
% F01 p R002 1 1 1
% F01 t R004 3 3 3
% F01 t R006 2 2 2
% F03 k R039 1 1 1
% F03 k R042 2 2 2
% F03 k R053 3 3 3
% --------------------------------------------------------------------
%
% Output Excel sheet :
% --------------------------------------------------------------------
% Subj Target data1 data2 data3
% F01 p 1.5 1.5 1.5
% F01 t 2.5 2.5 2.5
% F03 k 2 2 2
% --------------------------------------------------------------------

引用格式

Wei-Rong Chen (2024). Average over repetitions in Excel table (https://www.mathworks.com/matlabcentral/fileexchange/50467-average-over-repetitions-in-excel-table), MATLAB Central File Exchange. 检索来源 .

MATLAB 版本兼容性
创建方式 R2008a
兼容任何版本
平台兼容性
Windows macOS Linux
标签 添加标签

Community Treasure Hunt

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

Start Hunting!
版本 已发布 发行说明
1.0.0.0