Manuals/calci/FOURIERANALYSIS
Jump to navigation
Jump to search
FOURIERANALYSIS(Array, NewTableFlag)
where,
Array - Input range should be one or more blocks.
NewTableFlag - is the TRUE or FALSE.If set as TRUE,the result in new sheet. If NewTableFlag is omitted, it assumed to be FALSE.
Fourier Analysis is the process of analyzing a complex wave by separating it into a plurality of component wave, each of a particular frequency, amplitude and phase displacement.
If the number is not complex number, FOURIERANALYSIS returns the NaN.
FOURIER ANALYSIS
Lets see an example in (Column2, Row3)
=FOURIERANALYSIS(R1C1:R2C2, TRUE)
It returns the result in new sheet(5Sapce).
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 2+4i | 8i | 4 | 5 |
| Row2 | 6 | 12+56i | 9 | 128 |
| Row3 | 12 | 5Space | 14 | 15 |
| Row4 | 17 | 18 | 10000 | 20 |
| Row5 | 35 | 18 | 10027 | 168 |
| Row6 | NaN | 0.850904 | 1.619775 | 0.525322 |
| Input | Output |
|---|---|
| 2+4i | 20+68i |
| 8i | -52+15.999999999999996i |
| 6 | -4 -60i |
| 12+56i | 44 -7.9999999999999964i |