Electronics World articles Popular Electronics articles QST articles Radio & TV News articles Radio-Craft articles Radio-Electronics articles Short Wave Craft articles Wireless World articles Google Search of RF Cafe website Sitemap Electronics Equations Mathematics Equations Equations physics Manufacturers & distributors LinkedIn Crosswords Engineering Humor Kirt's Cogitations RF Engineering Quizzes Notable Quotes Calculators Education Engineering Magazine Articles Engineering software RF Cafe Archives Magazine Sponsor RF Cafe Sponsor Links Saturday Evening Post NEETS EW Radar Handbook Microwave Museum About RF Cafe Aegis Power Systems Alliance Test Equipment Centric RF Empower RF ISOTEC Reactel RF Connector Technology San Francisco Circuits Anritsu Amplifier Solutions Anatech Electronics Axiom Test Equipment Conduct RF Copper Mountain Technologies Exodus Advanced Communications Innovative Power Products KR Filters LadyBug Technologies Rigol TotalTemp Technologies Werbel Microwave Windfreak Technologies Wireless Telecom Group Withwave RF Cafe Software Resources Vintage Magazines RF Cafe Software WhoIs entry for RF Cafe.com Thank you for visiting RF Cafe!
RF Electronics Shapes, Stencils for Office, Visio by RF Cafe

Windfreak Technologies Frequency Synthesizers - RF Cafe

Innovative Power Products Passive RF Products - RF Cafe

Please Support RF Cafe by purchasing my  ridiculously low-priced products, all of which I created.

RF Cascade Workbook for Excel

RF & Electronics Symbols for Visio

RF & Electronics Symbols for Office

RF & Electronics Stencils for Visio

RF Workbench

T-Shirts, Mugs, Cups, Ball Caps, Mouse Pads

These Are Available for Free

Espresso Engineering Workbook™

Smith Chart™ for Excel

Innovative Power Products Couplers

Error Analysis / Calculation Excel Spreadsheet - by Michael Maguire
Cool Product Report

Featured Product Archive

The inventions and products featured on these pages were chosen either for their uniqueness in the RF engineering realm, or are simply awesome (or ridiculous) enough to warrant an appearance.

| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 |

<Previous                     Next>


Analysis - Error Calculations by Michael Maguire (Analysis - Error Calculations tab) - RF Cafe Cool Product

Tab: "Analysis - Error Calculations"

Analysis - Error Calculations by Michael Maguire (Analysis - Error (dB to Linear) tab) - RF Cafe Cool Product

Tab: "Analysis - Error (dB to Linear) "

Analysis - Error Calculations by Michael Maguire (Analysis - Error (Linear to dB) tab) - RF Cafe Cool Product

Tab: "Analysis - Error (Linear to dB) "

Thanks once again to RF Cafe visitor Michael Maguire for providing yet another useful spreadsheet†, this one for calculating errors (Error Analysis) in various sorts of combinations of numbers. It also handily includes an ability to calculate errors when converting between linear and decibel values - which is useful when performing cascade analysis.

As you might recall from your statistics and probabilities or error analysis class, errors propagate through a system according to how serial and parallel elements are combined from input to output. Calculation can be as simple as linear addition of individual elemental errors to more complex calculations when multiplication, division, and exponentiation are involved.

An Introduction to Error Analysis - RF CafeIf I recall correctly, my introduction to formal error analysis was in a math course of that name in the Fall semester of my sophomore year of engineering school. It was a prerequisite to taking Physics II, Chemistry II, and Statistics and Dynamics classes because laboratory write-ups required that error analysis be performed on all our projects from that point forward. That was sometime around 1985. The textbook was the one shown in the thumbnail here, and is quite memorable because of the cover image of a train having broken through the wall of a roundhouse due to, implicitly, an error in judgment, which is in reality difficult to objectively quantify.

The screenshots provided here of Michael's Error Analysis spreadsheet give you a good idea of the usefulness of his work. Click this link to download a free ZIPed copy of the Error Analysis spreadsheet.

Hint: I like to lock the equation cells to prevent accidently overwriting them. An even better thing to do is to protect all cells except the "Data Entry Field" cells (bluish-gray) against being accidentally changed. To do so, select all the "Data Entry Field" cells by clicking in them while holding down the Ctrl key. Right-click and select "Format cells..." from the sub-menu, select the "Protection" tab, and uncheck the "Locked" box, then "OK." Finally, go to the main menu "Review" tab and click on "Protect Sheet." Click OK without changing any of the default settings (only enter a password if you need one; otherwise, leave it unchecked). To check the lock, click in an empty cell and hit the "Del" key. You should get warning about attempting to change a protected cell. Unprotect everything by doing "Review" and "Unprotect Sheet."


† See also CNES RF Propagation Calculations DLL



Posted July 26, 2022

Innovative Power Products Couplers
Anatech Electronics RF Microwave Filters - RF Cafe

Innovative Power Products Passive RF Products - RF Cafe

Crane Aerospace Electronics Microwave Solutions: Space Qualified Passive Products