Amplitude vs Frequency graph

JimMueller

Board Regular
Joined
Nov 24, 2004
Messages
83
I'd like to create a graph in Excel 2010 similar to this, where f0, f1 & f2 are variables picked by a human. I'm not even sure what type of chart this is considered to be :(

FilterBandwidth09B.gif


Thanks for any help!

Jim
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
It's a scatter (x-y) plot. What's the underlying mathematical function?
 
Upvote 0
From another site:

---
Definition of Octave
Assume one note has a frequency of 200Hz, the note an octave above it is at 400Hz, and the note an octave below is at 100Hz. The ratio of frequencies of two octaves is 2:1. Another example: 50Hz is one octave below 100Hz, and 400Hz is two octaves above 100Hz.

An Octave band is characterized by the following formulas:

If the F1 is the lower cutoff frequency and F2 is the upper cutoff frequency, the ratio of the band limits is given by:

F2/F1 ≈ 2^N

where N = 1 for full Octave and N= 1/3 for 1/3 Octave bands.

An Octave has a center frequency that is 2^(1/2) (square root of 2) times the lower frequency cutoff frequency and has an upper cutoff frequency that is twice the lower cutoff frequency. Therefore,

F1 = F0 / 2^(1/2)
F2 = 2^(1/2) . F0, where F0 is the center frequency
F2 = 2 . F1
BW = F2 - F1, where BW = Band Width

A 1/3 Octave has a center frequency that is 2^(1/3) (cubic root of 2) times the lower frequency cutoff frequency and has an upper cutoff frequency that is twice the lower cutoff frequency.

Therefore,

F1 = F0 / 2^(1/3)
F2 = 2^(1/3) . F0

Example 1. Calculate the 1/3 Octave band limits for center frequency of 16Hz.

2^(1/3) = 1.26

Lower band limit: F1 = 16Hz / 1.26 ≈ 12.5Hz
Upper band limit: F2 = 16Hz * 1.26 ≈ 20Hz

Example 2. Calculate the 1/3 Octave band limits for center frequency of 125Hz.

2^(1/3) = 1.26

Lower band limit: F1 = 125Hz / 1.26 ≈ 100Hz
Upper band limit: F2 = 125Hz * 1.26 ≈ 160Hz
---
 
Upvote 0

Forum statistics

Threads
1,223,834
Messages
6,174,914
Members
452,590
Latest member
CraiginColorado

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top