Question

I need help with this question. I will give you 100% rating. Thanks.

Equations 9 & 10 provided in second image

4. Using Excel, create a spreadsheet model of an RC low pass filter using Eqns. 9 & 10. A 1 .0 F capacitor and 1000 2 resistor are used to build the pass filter Let the model run from 10 Hz to 1000Hz in steps of 10 Hz. (Appendix A) Repeat for a high pass filter using the same components. (Print & paste plots) )- 1 |ндою 1+ (оCR)* (9) arg (HGw)) — -tan-1 (оCR) (10)

Answer 1

LOW PASS FILTER:

amplitude 1.2 0.8 0.6 0.4 0.2 0 0 400 200 600 800 1000 1200

phase 200 400 800 1000 600 1200 -10 -20 -30 -40 -50 -60 -70 -80 -90

7 x Excel (Product Activation Failed) bode plotxlsx- CHART TOOLS Sign in FORMULAS REVIEW FILE HOME INSERT PAGE LAYOUT DATA VIEW DESIGN FORMAT Add Chart Quick Change Switch Row/ Select Change Chart Type Mave Element Layout Colors Column Data Chart Chart Layouts Chart Styles Data Type Location Chart 2 M C K C S T Tamplitude -3.59528 0.99803389 0.000001 20 -7.16249 0.99220443 0.000001 -10.6749 0.98271162 0.000001 40 -14.1081 0.96986804 0.000001 50-17.4411 0.95407165 0.000001 1 Serial number frequency Iphase capacitor resistance phase 10 1000 C 3 1000 400 200 600 800 1000 1200 4 30 1000 10 Y 5 1000 20 6 1000 30 60-20.6569 0.93577424 0.000002 7 1000 -23.7423 0.91544997 0.00000: -26.6885 0.89356772 0.0000001 9029.4901 0.87056932 0.000001 -32.1451 0.84685451 0.000001 -34.6543 0.82277231 0.000001 120 -37.0204 0.79861787 0.000001 AD 8 70 1000 80 1000 10 1000 60 10 11 100 1000 70 12 1. 110 1000 13 12 1000 130-39.2481 0.77463332 0.000001. 90 1000 13 * 15043.3113 0.72790075 0.000001 160 -45.1601 0.70541177 0.000001 17046.8964 16 15 1000 ... 17 16 1000 0.6836227 0.000001. 1000 Sheet1 + AVERAGE: 220.2452802 SUM: 44049,05s605 READY COUNT: 202 100% ENG 07:32 ? US 19-06-2019

HIGH PASS FILTER:

AMPLITUDE = wRC / $\sqrt{}$(1 + w²R²C²)

Angle = tan^-1(wRC)

bode plotxlsx- Excel (Product Activation Failed) CHART TOOLS Sign in FORMULAS FILE HOME INSERT PAGE LAYOUT DATA REVIEW VIEW DESIGN FORMAT Cut MAutoSum AY H 10 A A = = _ Wrap Text General Calibri (Body) Fill Copy EE EE Merge & Center Cell Paste Insert Delete Format Sort & Find & BI %, 8 Conditional Format as Format Painter Clear Formatting Table Styles Filter Select- Font Clipboard Alignment Number Styles Cells Editing X Chart 2 C M N D S T 1 Serial number frequency Iphase lamplitude capacitor resistance phase 10 3.595279 0.06267653 0.000001 20 7.162494 0.12462088 0.000001 30 10.67487 0.18514287 0.000001 1000 1000 90 3 4 1000 80 Y 40 14.10809 0.24363085 0.000001 50 17.44113 5 1000 70 0.2995785 0.000001 6 1000 60 60 20.65688 0.35259973 0.000001 7 1000 70 23.74233 0.40243181 0.000001 80 26.68848 0.44892842 0.000001 90 29.49008 0.49204578 0.000001 100 32.14512 0.53182463 0.000001 110 34.65428 0.56837111 0.000001 120 37.02045 0.60183843 0.000001 130 39.2481 0.63241064 0.000001 8 1000 1000 0 10 1000 11 20 1000 12 1. 1000 10 13 12 1000 1000 200 800 1000 13 400 600 200 150 43.31126 0.68568251 0.000001 160 45.16007 0.70879774 0.000001 170 46.89639 .7298356 0.000001 16 15 1000 17 16 1000 1000 +) Sheet READY 100% ENG 07:38 US 19-06-2019

phase 90 80 70 60 50 40 30 20 10 0 1000 200 400 600 800 1200

amplitude 1.2 1 0.8 0.6 0.4 0.2 400 200 600 800 1000 1200