Eng-Tips is the largest engineering community on the Internet
Intelligent Work Forums for Engineering Professionals
-
Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Cumulative Probability 1
- Thread starter Shahram56
- Start date
-
1
- #3
IRstuff is right. However, you can also calculate it directly if you know mu, and alpha. In Excel, look up the probability density or cumulative density function. (I believe that the Weibull function also give a formula for CDF) Be careful, I have found that the alpha's and mu's were switched in the Excel formula!
- Thread starter
- #4
I appreciate you reply, but I am still confused as I do not know the mu or alpha. how can I calculate it and how can I draw a graph for these 15 data, I need a graph with y axis for cumultive probbility (%) and x-axis for the data.
Thank you in advance.
Thank you in advance.
The plot is easy (XY Scatter graph where y=CDF & X=data measured values).
To get the mu or alpha is more difficult (I generally use JMP 4 to get the values), but it is not impossible. Try searching the web for CDF, Cumulative Density Function, etc.. Otherwise, you will be forced to integrate the PDF from -infinity to X (as IRstuff pointed out). That is fairly straightforward to do using excel and a rough approximation technique (integral = area under the curve -> sum of slices [width times height]).
Good luck and keep us posted!
To get the mu or alpha is more difficult (I generally use JMP 4 to get the values), but it is not impossible. Try searching the web for CDF, Cumulative Density Function, etc.. Otherwise, you will be forced to integrate the PDF from -infinity to X (as IRstuff pointed out). That is fairly straightforward to do using excel and a rough approximation technique (integral = area under the curve -> sum of slices [width times height]).
Good luck and keep us posted!
Here is another way.....
ASSUMING THE DATA SET IS NORMALLY DISTRIBUTED!!!! Use the NORMDIST function in Excel. You will need:
1) X (sample)
2) MEAN (AVERAGE on samples)
3) STANDARD DEVIATION (STDEV or STDEVP on samples)
4) CUMMULATIVE (1 or TRUE = CDF, 0 or FALSE = PDF)
You should be able to get it from there! Make sure you plot the data as an XY Scatter, NOT any type of line graph.
Good luck!
ASSUMING THE DATA SET IS NORMALLY DISTRIBUTED!!!! Use the NORMDIST function in Excel. You will need:
1) X (sample)
2) MEAN (AVERAGE on samples)
3) STANDARD DEVIATION (STDEV or STDEVP on samples)
4) CUMMULATIVE (1 or TRUE = CDF, 0 or FALSE = PDF)
You should be able to get it from there! Make sure you plot the data as an XY Scatter, NOT any type of line graph.
Good luck!
- Thread starter
- #7
- Thread starter
- #9
I processed the data in excel but moved them to Origin and then then drew the graph. I would appreciate fi you take alook and tell me wether it is right or not.
thnaks in advance.
thnaks in advance.
- Thread starter
- #10
I am sorry. Please check the following page.
Never mind, I figured it out. Anyway, if I am interpretting your data correctly, you CDF look right. You CDF is the area under the PDF from -infinity to X, therefore the graph will start at 0 and approach 1 (or 100%). The CDF tells you what percentage of parts will fall out by a certain leakage current (your measurement criteria).
Perhaps, you would be more comfortable using a Survival plot.
Survival = 1- CDF
This will allow you to predict the amount of devices that will survive up to a leakage current (your measurement criteria).
Remember, all of this assumes that your data is normally distributed! You should also try to rerun your calcs based on a Weibull distribution (Weibull is a non-normal distribution). The only caveat is that Excel requires you to supply the alpha and beta values for the Weibull distribution, but cannot easily determine them using your data. Although the math is a bit tricky, you can certainly calculate them yourself (using Excel). Just do a websearch on the Weibull distribution, funciton, etc. and make your own worksheet to calculate the alpha and beta.
I hope that this helps / makes sense!
Perhaps, you would be more comfortable using a Survival plot.
Survival = 1- CDF
This will allow you to predict the amount of devices that will survive up to a leakage current (your measurement criteria).
Remember, all of this assumes that your data is normally distributed! You should also try to rerun your calcs based on a Weibull distribution (Weibull is a non-normal distribution). The only caveat is that Excel requires you to supply the alpha and beta values for the Weibull distribution, but cannot easily determine them using your data. Although the math is a bit tricky, you can certainly calculate them yourself (using Excel). Just do a websearch on the Weibull distribution, funciton, etc. and make your own worksheet to calculate the alpha and beta.
I hope that this helps / makes sense!
- Thread starter
- #14
- Thread starter
- #15
I have another question. I had an argue with my colleague. He has a rediculus idea. He claims that I should draw the graph with the same distance between the data. for example i should check the no of data and divide the space between them so the distance between the data and 0 and 100 from the 1st and last data should be the same. I have added a graph at the same address for you to check if you do not mind. post1.doc
thank you in advance,
I remain.
thank you in advance,
I remain.
- Thread starter
- #17
- Thread starter
- #19
- Status