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
更新 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