Difference between revisions of "Manuals/calci/FOURIERANALYSIS"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''FOURIERANALYSIS'''(Array, NewTableFlag) where, '''Array '''- Input range should be one or more blocks. ...")
 
 
(16 intermediate revisions by 4 users not shown)
Line 1: Line 1:
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''FOURIERANALYSIS (Array,NewTableFlag)'''</div><br/>
 +
*<math>Array</math> is the set of numbers.
 +
*<math>NewTableFlag</math> is the value true or false.
 +
**FOURIERANALYSIS() is a method of dissociating time series or spatial data into sets of sine and cosine waves
  
'''FOURIERANALYSIS'''(Array, NewTableFlag)
+
==Description==
 +
*This function gives the value of the discrete fourier tranform.
 +
*Fourier analysis is the study of the way general functions may be represented by sums of simpler trigonometric functions.
 +
*It converts a set of numbers into another equal sized set of numbers.
 +
*It 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.
 +
*In <math>FOURIERANALYSIS (Array,NewTableFlag)</math>, <math>Array</math>is the set of  real numbers.
 +
*But the size of the set to be a power of 2.i.e., Array is  the size of the numbers can be 2,4,8,16....
 +
*So we can form the Fourier transform of a set of 64 numbers, but not a set of 50  numbers.
 +
*In the discrete Fourier Transform (DFT) decomposes the input time series into a set of cosine functions.
 +
*It is having the following properties
 +
  1.The transformed data is no longer in the time domain.
 +
  2. The transformation operates on the whole data set. It is not a point-by-point transformation.
 +
  3.The transformed data is complex (not real-valued).
 +
*So the output of this function is Hermite symmetric, which means that the positive and negative real parts will be identical, and that the positive and negative imaginary parts will be the same, but of opposite sign.
 +
*The formula for the DFT is :
 +
<math>x_m=\frac{1}{N}\sum_{k=1}^N A_k *cos(\phi_k+k*\omega*m)</math>
 +
where <math>A_k</math> is the amplitude,<math>\phi_k</math> is the phase value in radians.
 +
*<math>\omega</math> is the fundamental or principal radian frequency and <math>\omega=\frac{2\pi}{T}</math>, <math>T</math>  is the number of observations in the equally-spaced input time series.<math>N</math> is the is the number of  pairs.
 +
*This function will give the result as error when
 +
  1. any one of the argument is nonnumeric.         
 +
  2. The number of input value is not a power of 2.
  
where,
+
==Examples==
 +
{| class="wikitable"
 +
|+Spreadsheet
 +
|-
 +
! !! A !! B !! C !! D!! E!! F !! G !! H
 +
|-
 +
! 1
 +
| 21 || 28 || 34 ||46 || 15 || 10 || 4 ||9
 +
|-
 +
! 2
 +
| 6 || 17 || 22 || 16 || 39 || 50 || 11 || -27
 +
|}
 +
#=FOURIERANALYSIS(A1:D1)
 +
{| class="wikitable"
 +
|+Fourier Analysis
 +
|-
 +
! Input!! Output
 +
|-
 +
| 21 || 129+0i
 +
|-
 +
| 28 || -13.000000000000002+18i
 +
|-
 +
| 34  || -19+0i 
 +
|-
 +
| 46 ||-12.999999999999998 -18i
  
'''Array '''- Input range should be one or more blocks.
+
|}
 
+
#=FOURIERANALYSIS(A2:H2)
'''NewTableFlag''' - is the TRUE or FALSE.If set as TRUE,the result in new sheet. If NewTableFlag is omitted, it assumed to be FALSE.
+
{| class="wikitable"
 +
|+Fourier Analysis
 +
|-
 +
! Input!! Output
 +
|-
 +
| 6 || 134+0i
 +
|-
 +
| 17 || -86.7401153701776 -18.07106781186548i
 +
|-
 +
| 22  || 12.000000000000005 -78i 
 +
|-
 +
| 16 ||20.740115370177605+3.928932188134528i
 +
|-
 +
| 39 || 22+0i
 +
|-
 +
| 50 || 20.740115370177605 -3.928932188134521i
 +
|-
 +
| 11  || 11.999999999999995+78i 
 +
|-
 +
| -27 ||-86.7401153701776+18.071067811865472i
 +
|}
  
</div>
+
==Related Videos==
----
 
<div id="1SpaceContent" class="zcontent" align="left">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.</div>
 
----
 
<div id="7SpaceContent" class="zcontent" align="left">
 
  
If the number is not complex number, FOURIERANALYSIS returns the NaN.
+
{{#ev:youtube|NEYOcxQpppo|280|center|FOURIER Analysis}}
  
</div>
+
==See Also==
----
+
*[[Manuals/calci/FIBONNACI| FIBONNACI]]
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
+
*[[Manuals/calci/PASCAL| PASCAL]]
  
FOURIER ANALYSIS
+
==References==
 +
*[http://en.wikipedia.org/wiki/Fourier_analysis Fourier Analysis]
  
</div></div>
 
----
 
<div id="8SpaceContent" class="zcontent" align="left">
 
  
Lets see an example in (Column2, Row3)
 
  
<nowiki>=FOURIERANALYSIS(R1C1:R2C2, TRUE)</nowiki>
+
*[[Z_API_Functions | List of Main Z Functions]]
 
 
It returns the result in new sheet(5Sapce).
 
 
 
</div>
 
----
 
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
 
----
 
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
 
----
 
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
 
----
 
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
 
----
 
<div id="2SpaceContent" class="zcontent" align="left">
 
 
 
{| id="TABLE3" class="SpreadSheet blue"
 
|- class="even"
 
| class=" " |
 
| Column1
 
| Column2
 
| Column3
 
| Column4
 
|- class="odd"
 
| class=" " | Row1
 
| class="                sshl_f " | 2+4i
 
| class=" " | 8i
 
| 4
 
| class="sshl_f" | 5
 
|- class="even"
 
| class="  " | Row2
 
| class=" " | 6
 
| class=" " | 12+56i
 
| 9
 
| class="sshl_f" | 128
 
|- class="odd"
 
| Row3
 
| class="    " | 12
 
| class="sshl_f" | 5Space
 
| 14
 
| class="sshl_f    " | 15
 
|- class="even"
 
| Row4
 
| 17
 
| class="  SelectTD1 ChangeBGColor SelectTD1" |
 
<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]]  </div>18
 
| class="sshl_f" | 10000
 
| class="  " | 20
 
|- class="odd"
 
| class=" " | Row5
 
| 35
 
| 18
 
| 10027
 
| 168
 
|- class="even"
 
| Row6
 
| NaN
 
| 0.850904
 
| 1.619775
 
| 0.525322
 
|}
 
 
 
<div align="left">[[Image:calci1.gif]]</div></div>
 
----
 
<div id="5SpaceContent" class="zcontent" align="left">
 
 
 
{| class="SpreadSheet blue"
 
|+ <br />Fourier Analysis
 
|- class="even"
 
! Input
 
! Output
 
|- class="odd"
 
| 2+4i
 
| 20+68i
 
|- class="even"
 
| 8i
 
| -52+15.999999999999996i
 
|- class="odd"
 
| 6
 
| -4 -60i
 
|- class="even"
 
| 12+56i
 
| 44 -7.9999999999999964i
 
|}
 
  
</div>
+
*[[ Z3 |  Z3 home ]]
----
 

Latest revision as of 16:22, 17 August 2018

FOURIERANALYSIS (Array,NewTableFlag)


  • is the set of numbers.
  • is the value true or false.
    • FOURIERANALYSIS() is a method of dissociating time series or spatial data into sets of sine and cosine waves

Description

  • This function gives the value of the discrete fourier tranform.
  • Fourier analysis is the study of the way general functions may be represented by sums of simpler trigonometric functions.
  • It converts a set of numbers into another equal sized set of numbers.
  • It 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.
  • In , is the set of real numbers.
  • But the size of the set to be a power of 2.i.e., Array is the size of the numbers can be 2,4,8,16....
  • So we can form the Fourier transform of a set of 64 numbers, but not a set of 50 numbers.
  • In the discrete Fourier Transform (DFT) decomposes the input time series into a set of cosine functions.
  • It is having the following properties
 1.The transformed data is no longer in the time domain.
 2. The transformation operates on the whole data set. It is not a point-by-point transformation.
 3.The transformed data is complex (not real-valued).
  • So the output of this function is Hermite symmetric, which means that the positive and negative real parts will be identical, and that the positive and negative imaginary parts will be the same, but of opposite sign.
  • The formula for the DFT is :

where is the amplitude, is the phase value in radians.

  • is the fundamental or principal radian frequency and , is the number of observations in the equally-spaced input time series. is the is the number of pairs.
  • This function will give the result as error when
  1. any one of the argument is nonnumeric.           
  2. The number of input value is not a power of 2.

Examples

Spreadsheet
A B C D E F G H
1 21 28 34 46 15 10 4 9
2 6 17 22 16 39 50 11 -27
  1. =FOURIERANALYSIS(A1:D1)
Fourier Analysis
Input Output
21 129+0i
28 -13.000000000000002+18i
34 -19+0i
46 -12.999999999999998 -18i
  1. =FOURIERANALYSIS(A2:H2)
Fourier Analysis
Input Output
6 134+0i
17 -86.7401153701776 -18.07106781186548i
22 12.000000000000005 -78i
16 20.740115370177605+3.928932188134528i
39 22+0i
50 20.740115370177605 -3.928932188134521i
11 11.999999999999995+78i
-27 -86.7401153701776+18.071067811865472i

Related Videos

FOURIER Analysis

See Also

References