Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I perform mathematical convolution in Excel?
Does anyone know how to easily perform the mathematical operation of
convolution in Excel? Thanks! |
#2
|
|||
|
|||
Answer: How do I perform mathematical convolution in Excel?
Yes, you can perform mathematical convolution in Excel using the built-in function called "CONVOLVE". Here's how you can do it:
Note that the CONVOLVE function in Excel performs a discrete convolution, which means that it assumes that the two sets of data are sampled at regular intervals. If your data is not sampled at regular intervals, you may need to interpolate it before using the CONVOLVE function.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I perform mathematical convolution in Excel?
Hello, FeynmanDiagram!
You wrote on Tue, 19 Dec 2006 07:46:01 -0800: F Does anyone know how to easily perform the mathematical F operation of convolution in Excel? Thanks! Since convolution involves integration, numerically or theoretically, I suspect that it would best be done by a program other than Excel. Before I retired, I had Mathematica and MatLab available for that sort of thing but I can't bring myself to buy either of the very expensive programs just for personal interest. James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I perform mathematical convolution in Excel?
See:
http://groups.google.com/group/micro...d1646d344b3e8d -- Gary's Student "FeynmanDiagram" wrote: Does anyone know how to easily perform the mathematical operation of convolution in Excel? Thanks! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I perform mathematical convolution in Excel?
Hello, FeynmanDiagram!
You wrote on Tue, 19 Dec 2006 07:46:01 -0800: F Does anyone know how to easily perform the mathematical F operation of convolution in Excel? Thanks! Further to my earlier reply. If cost is a problem, symbolic algebra programs are available for Linux tho' I have not used any of them lately. MuPad is one that comes to mind. James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I perform mathematical convolution in Excel?
MuPad also runs under Windows
-- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in email address "James Silverton" wrote in message ... Hello, FeynmanDiagram! You wrote on Tue, 19 Dec 2006 07:46:01 -0800: F Does anyone know how to easily perform the mathematical F operation of convolution in Excel? Thanks! Further to my earlier reply. If cost is a problem, symbolic algebra programs are available for Linux tho' I have not used any of them lately. MuPad is one that comes to mind. James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I perform mathematical convolution in Excel?
F Does anyone know how to easily perform the mathematical
F operation of convolution in Excel? Thanks! Excel has an Add-Inn called "Data Analysis" that includes a Fourier Transform program. It surprisingly works quite well. -- HTH :) Dana DeLouis Windows XP & Office 2003 "Bernard Liengme" wrote in message ... MuPad also runs under Windows -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in email address "James Silverton" wrote in message ... Hello, FeynmanDiagram! You wrote on Tue, 19 Dec 2006 07:46:01 -0800: F Does anyone know how to easily perform the mathematical F operation of convolution in Excel? Thanks! Further to my earlier reply. If cost is a problem, symbolic algebra programs are available for Linux tho' I have not used any of them lately. MuPad is one that comes to mind. James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I perform mathematical convolution in Excel?
Thank you everyone for your responses.
Some general comments on the question of convolution in Excel: 1) I agree with everyone that said something to the effect of, "If you are serious about signal processing, you should be using some other program." I'll add to the list by saying that when I am "serious", I use IDL. 2) I was hoping to find a quick method to look at some curves. For quick plotting of data and seeing what is happening, I think Excel is hard to beat. For that purpose, I found Gary's Student's response very helpful. 3) In the end, here is what I did: a) I made a column with the time reversed kernel and named the relevant cells, "ker". b) I put the zero padded input signal in the next column. c) The next column contained array formulas of the form: {=SUM(ker*E18:E118)} d) Plot the output signal. So, I had a four column solution (Time, reversed kernel, input signal, output signal), which made it easy to see the effect of changing the kernel. Thanks again! "FeynmanDiagram" wrote: Does anyone know how to easily perform the mathematical operation of convolution in Excel? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Excel 5 and Excel 2000 question. | Excel Discussion (Misc queries) | |||
How do I perform multiple regression in Excel using two independe | Excel Worksheet Functions | |||
Mathematical explanations/equations for Excel functions in "Help" | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel |