View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.charting,microsoft.public.excel.programming
 
Posts: n/a
Default Weibull paper in Excel - how?

Hi,

I want to create Weibull paper in Excel. The problem is the labelling
at the Y-axis.

I want to label probabilities (between 0.1 and 99.9%), but want to plot
the transformed logaritmic data; calculated out of the probability via
ln(ln(1/(1-p)))

X P (probabiliy, label) Y (transformed data; to
be plotted)
155 97,89% 1,350040182
325 97,61% 1,317875745
500 97,34% 1,288316244
525 97,07% 1,26088904


How can I do this either with or without VBA?

Has minitab this functionality included? Does it calculate beta and
eta?

thanks for the help,
Roger