Point to the location of the saved EIA_Standard_Values.xla file and select OK. The add-in (Figure 3) should now be enabled for all spreadsheets. Figure 3: Installing the code as an Excel add-in ...

The Excel cell formula below calculates the nearest standard 1%-resistor value without using a lookup table or macro. Type or electronically paste the text below into any cell (other than A1).

For example, if your mean is in cell A2, population mean in cell B2, standard deviation in cell C2, square root of degrees of freedom in E2, type the formula as =(A2-B2)/(C2/E2) to generate the T ...

The simple Excel formula below determines the nearest 5% standard resistor value by comparison without using a lookup table or a macro. A preliminary calculation is needed to determine the decade ...