none
Weighted mean in excel?

Answers

  • I figured it out.  Thank you.

    =SUMPRODUCT(F3:F22,H3:H22)/SUM(F3:F22)

    Column F is failure rate

    Column G is % of failures causing repair to occur to end item.

    Column H is estimated price for each type failure.

    Result is average cost to repair the end item.

    • Marked as answer by David Wolters Wednesday, December 08, 2010 6:31 PM
    Wednesday, December 08, 2010 6:20 PM