Home / Statistical Tools / Distribution Fit/Calc / Distribution Fit / Auto-Fit
Auto-Fit Distribution Fitting (Non-Reliability)¶
From Excel click...
QXL Stat Tools Tab > Distribution Fit/Calc > Distribution Fit > Auto-Fit
Auto-Fit will analyze your dataset, fit all of the available distributions, and then present the results in rank order.
Step #1: Prepare data for Analysis¶
The data should be in a single column as in the example below
Step #2¶
From Excel click...
QXL Stat Tools Tab > Distribution Fit/Calc > Distribution Fit > Auto-Fit
Step #3: Select the data range which includes your data¶
Step #4: Generate the report(s) for the best distribution(s)¶
Quantum XL will display the fit for each of the distributions with the "best fit" at the top. The quality of the fit can be assessed by either Anderson Darling p-value (AD p-value), Akaike's Information Criteria (AIC) , Bayesian Information Criteria (BIC), or --2*LogLikelihood. To change how the table is sorted, click on the name at the top of the column. (See more information about AD p-value, AIC, BIC, and --2*LogLikelihood.) Select the distribution(s) of interest by clicking on the respective check box in the left column. You may select one or all of the distributions. Enter the specification limits (optional). Note: if you provide specification limits, Quantum XL will calculate the area out of specification. Change the confidence interval for the resulting analysis (optional). If you wish to have a hazard and survivor plot created, check the checkbox (optional). When you're done selecting the desired options, click on the "Create reports for selected distributions" button.
Specification Limits (Optional): If you enter the Upper and/or the Lower Specification Limit, Quantum XL will calculate the associated probabilities in the report.
Confidence Interval: The resulting report will include confidence intervals for estimated parameters. The default value is 95%, but you may enter any value greater than 0 and less than 1.
Create hazard and survivor plot: If you would like hazard and survivor plots, check this box. Note: see Quantum XL's reliability fitting options.
Step #5: Click "Create reports for selected distributions"¶
Quantum XL will generate the desired report(s). The distribution fit report includes several sections. See Understanding Distribution Fitting Results for more information about the analysis.
