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)'.
How Averages are Calculated. The following question types calculate an average or weighted average. For more details on how we calculate averages for each question type, see the articles below: Ranking, Matrix/Rating Scale, Multiple Textboxes, and Slider questions calculate an average or weighted average. See each question type article for details on how the results for each question type are calculated in the Analyze Results section. Start making better decisions with the world's leading survey platform.