Calculating average and standard deviation for element correction factor from excel file

Question

Lucas Acuna Scafati 2020-2-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/504197-calculating-average-and-standard-deviation-for-element-correction-factor-from-excel-file

评论： fred ssemwogerere 2020-2-12

I'm importing data from an excel file. I need to take the average of every of every serial number, then calculate the standard deviation percentage of every serial number. Any ideas how i could do that? Thank you

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

fred ssemwogerere 2020-2-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/504197-calculating-average-and-standard-deviation-for-element-correction-factor-from-excel-file#answer_414346

在 MATLAB Online 中打开

Hello, this should do nicely;

% Assuming your spreadsheet file is in the current (working) Matlab folder
optns=detectImportOptions('file.xlsx'); % replace the input "file.xlsx" here with the name of your file and extension
% Set variables to import from your file and import as table
optns.SelectedVariableNames={'SerialNumber','RawCounts'};
T=readtable('file.xlsx',optns); % replace "file.xlsx" with the name of your file
% Determine unique serial numbers and corresponding indices
% The unique serial numbers are stored in "C".
[Z,mX,mY]=unique(T.SerialNumber);
% Compute the mean for each unique serial number
avg=accumarray(mY,T.RawCounts,[],@mean);
% Compute the standard deviation for each unique serial number
stdev=accumarray(mY,T.RawCounts,[],@std);
% To calculate the percentage standard deviation or relative deviation, you
% multiply each standard deviation by 100, and divide it by its
% corresponding mean value in array; "avg".
percentdev=(stdev.*100)./avg;