+ Reply to Thread
Results 1 to 2 of 2

Exponential function in Excel - Fourier Transformation

  1. #1
    Registered User
    Join Date
    05-22-2015
    Location
    LD
    MS-Off Ver
    2013
    Posts
    1

    Exponential function in Excel - Fourier Transformation

    Hello,

    can you help me please with fourier transformation of Exponential function, please?

    I have this: img31.png. I have constant K=1 and A= for example 1.

    Can you please help me with function? I want to have a graph of this function.
    I try to use my interest, but i get i think that is a SINUSOIDE.

    Can you help me please? Thank you very much

    JOHN

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Exponential function in Excel - Fourier Transformation

    Suppose the values of [x] in column A from A2, the value of [a] in cell E2.
    The matrix formula is then
    =2/PI()*SINH($E$2*PI())*(1/(2*$E$2)+SUM(((-1)^ROW($A$1:$A$1000)/($E$2^2+ROW($A$1:$A$1000)^2))*($E$2* COS(ROW($A$1:$A$1000)*A2)-ROW($A$1:$A$1000)*SIN(ROW($A$1:$A$1000)*A2))))
    PHP Code: 
    =2/PI()*SINH($E$2*PI())*(1/(2*$E$2)+SUM(((-1)^ROW($A$1:$A$1000)/($E$2^2+ROW($A$1:$A$1000)^2))*($E$2COS(ROW($A$1:$A$1000)*A2)-ROW($A$1:$A$1000)*SIN(ROW($A$1:$A$1000)*A2)))) 
    Do not forget to confirm the formula with Ctrl + Shift + Enter

    [k] is not a constant. It ranges from 1 to infinity.
    In the formula [k] belongs to the interval [1..1000] and is ROW($A$1:$A$1000).
    For greater accuracy must use higher values. Ex: ROW($A$1:$A$65000).
    See de file

    Best regards.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Data transformation in Excel cells.
    By bartszu in forum Excel General
    Replies: 4
    Last Post: 08-09-2013, 09:31 PM
  2. Excel 2007 : Excel Scientific (Exponential) Function
    By sharad.ram1989 in forum Excel General
    Replies: 3
    Last Post: 02-16-2012, 09:53 AM
  3. Array Transformation Function Needed
    By Petro in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-03-2008, 05:03 AM
  4. compatibility to EXCEL transformation
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-03-2006, 06:10 AM
  5. Excel's Fourier Analysis should be a function, so that results upd
    By BobM in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-30-2006, 11:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1