Some purchasing specialist jobs also assign specialists to track the maintenance of office equipment. Maintaining records of warranties and service agreements is sometimes expected of a person in this position.
A retail price index would take this into account and use a weighted average which gives more prominence to commonly bought items. Excel does not contain a built in function to calculate a weighted average. It is however easy to do it using the SUMPRODUCT() function in a simple formula. SumProduct() multiplies two arrays (or ranges) together and returns the sum of the product. In the illustration it would calculate '(B4 x C4) + (B5 x C5) + (B6 x C6)'.
Solution to Example 2: 1. The exponential form 3 = 81 is equivalent to the logarithmic form. Example 3: Solve for x the following equations. 1. log 3 x = 5. 2. log 2 (x - 3) = 2. 3. 2 log 3 (- x + 1) = 6. Solution to Example 3: 1. To solve the equation log3 x = 5, rewrite it into exponential form. More references and links related to the logarithmic functions. Solve Exponential and Logarithmic Equations (self test).