Excel

6. Electrical engineers use a color-coded system to identify the value

of a resistor. Thus, a resistor with the banding colors green, blue,

yellow, and gold has a value of 560 k�5%. Construct a worksheet

similar to Figure 4.18. The user enters the digit 1 next to the

appropriate color for each band and the resistance is computed in C19

with the help of table G3:I13. The multiplier is 10 raised to the power

in column A. Check your results on the Internet. Cell C19 as the

custom format [<0.001]##0E+0;[<1000]#0.00;##0E+0, which

gives exponents in multiples of three. We shall expand on this

problem in later chapters. Clearly, we really should arrange things

so that there is only a single 1 in each of the Bar columns.

7. Create a worksheet to solve the following system of equations using

matrix algebra:

3x1�4x2 + 5x3 + 6x4 + 2x5 ¼ 62:5

x1 + 2x2 + 3x3 + 4x4 + 5x5 ¼ 19:5

6x1 + 7x2�4x3 + 2x4�x5 ¼ 15

5x1�5x2 + 2x3 + 5x4 + 7x5 ¼ 32

�3x1 + 5x2 + 6x3 + 2x4 + x5 ¼ 16

72 CHAPTER 4 Using Functions

PROBLEMS - CHAPTER 4

2. *To measure the index of refraction μ of a liquid with an Abbe

refractometer, a drop is placed between two prisms and a mirror is

rotated until the boundary of the light and dark zones align with the

crosshairs in a microscope. The index of refraction of the liquid is

given by the following equation in which the angle of rotation is

θ and μg is the refractive index of glass (1.51). For liquid A, the

value of θ was found to be 150°, and for B, it was 75°. Using a

worksheet, find μ for each liquid:

μ¼p1ffiffiffi 2

μ2g� sin2 θ � 1=2�

+ sin θ

� �