Basically, I need a macro writin in Statistica Visual Bacic, which would let on:
1. performance of more Spectral Fourier Analysis in the same time (for 12-24 variables in the file) and
2. calculations (from the Spreadsheet given after performed Spectral Analysis) of sums of the squared Density (Density*Density) for three different frequency bands (i.e. 0.0033-0.04 Hz, 0.04-0.15 and 0.15-0.4) for each variable in the file.
It would be good if these frequency bands stay open (can be changed).
Finally, results (three sums for each variable) should be in one final spreadsheet in the form: 3 columns (for three different sums) and 24 rows (cases -variables from the initinal file).
## Deliverables
1) Complete and fully-functional working program in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Statistica (StatSoft Inc.)
version:6.1.478.0