Creating a Weibull Plot in Microsoft® Excel

Chapter 5, Example 16

  1. Launch Excel.

  2. Enter the data and calculations

    Screenshot: screenshot

  3. Plot ln(-ln(1-p)) vs. ln(xi).

    Excel plots ln(-ln(1-p)) vs. ln(failure voltage) and inserts the chart into Sheet1.

    Screenshot: screenshot

    Note: you can resize the chart that contains the plot by clicking a blank area in the chart to select it and dragging one of the handles that appears on the chart's border. You can further modify the chart by double-clicking various chart elements.