Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.charting,microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel,microsoft.public.excel.charting,microsoft.public.excel.programming
|
|||
|
|||
Weibull paper in Excel - how?
|
#3
Posted to microsoft.public.excel,microsoft.public.excel.charting,microsoft.public.excel.programming
|
|||
|
|||
Weibull paper in Excel - how?
In this example, I've used the normal distribution to generate a custom Y
axis. All you need to do is use your Weibull function. I've done this as well, but I have no self-contained example. http://peltiertech.com/Excel/Charts/...lityChart.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ wrote in message ups.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Excel -- paper symbol attached to cursor? | Excel Discussion (Misc queries) | |||
Microsoft Excel in Microsoft works - how to open | Excel Discussion (Misc queries) | |||
How do I print on continuous label paper in Excel? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |