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 Engineer Jobs LinkedIn Crosswords Engineering Humor Kirt's Cogitations RF Engineering Quizzes Notable Quotes Calculators Education Engineering Magazine Articles Engineering software RF Cafe Archives RF Cascade Workbook 2018 RF Symbols for Visio - Word Advertising RF Cafe Forums Magazine Sponsor RF Cafe RF Electronics Symbols for Visio RF Electronics Symbols for Office Word RF Electronics Stencils for Visio Sponsor Links Saturday Evening Post NEETS EW Radar Handbook Microwave Museum About RF Cafe Aegis Power Systems Anritsu Alliance Test Equipment Amplifier Solutions Anatech Electronics Axiom Test Equipment Berkeley Nucleonics Bittele Centric RF Conduct RF Copper Mountain Technologies Empower RF everything RF Exodus Advanced Communications Innovative Power Products ISOTEC KR Filters Lotus Systems PCB Directory Rigol RF Superstore San Francisco Circuits Reactel RFCT TotalTemp Technologies Triad RF Systems Windfreak Technologies Withwave LadyBug Technologies Wireless Telecom Group Sponsorship Rates RF Cafe Software Resources Vintage Magazines Thank you for visiting RF Cafe!
Boonton RF Power Measurement

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

Axiom Test Equipment - RF Cafe
Innovative Power Products Passive RF Products - RF Cafe
RF Electronics Shapes, Stencils for Office, Visio by RF Cafe
TotalTemp Technologies (Thermal Platforms) - RF Cafe
RF Superstore (RF Components) - RF Cafe

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

These Are Available for Free

 

About RF Cafe

Kirt Blattenberger - RF Cafe Webmaster

Copyright: 1996 - 2024

Webmaster:

    Kirt Blattenberger,

    BSEE - KB3UON

RF Cafe began life in 1996 as "RF Tools" in an AOL screen name web space totaling 2 MB. Its primary purpose was to provide me with ready access to commonly needed formulas and reference material while performing my work as an RF system and circuit design engineer. The World Wide Web (Internet) was largely an unknown entity at the time and bandwidth was a scarce commodity. Dial-up modems blazed along at 14.4 kbps while tying up your telephone line, and a nice lady's voice announced "You've Got Mail" when a new message arrived...

All trademarks, copyrights, patents, and other rights of ownership to images and text used on the RF Cafe website are hereby acknowledged.

My Hobby Website:

AirplanesAndRockets.com