How to normalize 60x3 vector to zero mean and unit variance
1 次查看(过去 30 天)
显示 更早的评论
I have vector size of 60x3 in an excel sheet, I need to find the zero mean and unit variance of all the values in that sheet and write back the result into another excel sheet. Can u please help me in writing the code.
0 个评论
采纳的回答
Walter Roberson
2015-6-16
New_Array = (The_Array - mean(The_Array(:))) . / var(The_Array(:));
This assumes that the array as a whole is to have zero mean and unit variance, rather than each row or column to independently have zero mean and unit variance. If you want the columns done independently:
(The_Array - repmat(mean(The_Array), size(The_Array,1), 1)) ./ repmat(var(The_array), size(The_Array,1), 1);
7 个评论
Luis
2016-8-15
Actually you should divide by the standard deviation (std), not the variance (var)
(The_Array - repmat(mean(The_Array), size(The_Array,1), 1)) ./ repmat(std(The_array), size(The_Array,1), 1);
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!