how to calculate RMS of excel sheet having multiple channel

8 views (last 30 days)
Pralhad Uttam
Pralhad Uttam on 22 Dec 2021
Commented: Mathieu NOE on 22 Dec 2021
I want to calculate RMS of sheet having nine channel
Time Floor Vibration X Floor Vibration Y Floor Vibration Z

Accepted Answer

Mathieu NOE
Mathieu NOE on 22 Dec 2021
Edited: Mathieu NOE on 22 Dec 2021
see demo code below with attached excel file
I assumed the data are column oriented
the rms values are stored in array : col_rms
T = readmatrix('data_demo.xlsx');
time = T(:,1);
data = T(:,2:end);
col_rms = my_col_rms(data);
function col_rms = my_col_rms(data)
[m,n] = size(data);
for ci = 1:n
col_rms(1,ci) = sqrt(mean(data(:,ci).^2));

More Answers (0)

Community Treasure Hunt

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

Start Hunting!