Create new variable using if function from existing array variables
1 view (last 30 days)
Show older comments
Hi,
I have a table 'PMIdata' with 3 columns; 1st column is the date (monthly), 2nd column is a numeric value 'PMInum' corresponding to that date (economic growth) and 3rd column is a moving average of the second column 'PMIave' (so again numeric). I would like to add a fourth column 'AboveMA' to the table that specifies whether for each element in the 2nd column if it is greater than the corresponding element in the 3rd column, i.e. a binary variable of 0 or 1 indicating if the value is greater than its moving average (for all given dates).
I think this should be done using an 'IF' statement but I'm not sure of the syntax to navigate through the arrays and how to append this fourth column to the table.
Any help would be appreciated.
Thanks!
0 Comments
Answers (1)
See Also
Categories
Find more on Logical in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!