Best way to normalize data to Matlab

3 次查看（过去 30 天）
Ilana
Ilana 2013-8-1
Hi, I have numeric data in excel file. The data is of electrical loads measured by the hour. So on Y axis I have date values (Column A- Year, Column B- Month, Column C- Day) and on X axis I have the hours (Row A- hours- 1-24). How can I best Normalize the data, so that when loading it to Matlab the tasks of evaluating time-series and predicting using methods like: regression,MA, exp.smoothing, ARMA,ARIMA, NN and so on, will be most convenient to work with?

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

回答（2 个）

Image Analyst
Image Analyst 2013-8-1
I have no idea how you want to normalize it and what those terms mean, but to read it in you can use xlsread(). Then normalize it however you want. Usually that means dividing by the maximum value of something or total sum of something, but again, I don't know what that might mean for you, and even if it might change depending on what column you're normalizing.
Febin Benjamin
Febin Benjamin 2013-8-1
Depends on how you define 'best normalization'.... there are many... What's yours?

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by