Finding Bestfit Distribution [image]

  • Context: Undergrad 
  • Thread starter Thread starter hoodrych
  • Start date Start date
  • Tags Tags
    Distribution Image
Click For Summary
SUMMARY

The discussion centers on finding the best fit distribution using CurveExpert and Excel. Users report challenges in obtaining results due to the absence of Y values, which is critical for the analysis. It is recommended to utilize a cumulative histogram to visualize data effectively, with the x-axis representing errors and the y-axis indicating frequency. CurveExpert is highlighted as a valuable tool for identifying best fit models, although users may encounter issues if the input data is incomplete.

PREREQUISITES
  • Familiarity with CurveExpert for statistical modeling
  • Understanding of cumulative histograms for data visualization
  • Basic knowledge of Excel for graphing
  • Concept of best fit models in statistical analysis
NEXT STEPS
  • Learn how to create cumulative histograms in Excel
  • Explore advanced features of CurveExpert for model fitting
  • Research best practices for preparing data for statistical analysis
  • Investigate common errors in CurveExpert and their solutions
USEFUL FOR

Data analysts, statisticians, and anyone involved in statistical modeling or data visualization using Excel and CurveExpert.

hoodrych
Messages
17
Reaction score
0
I need to find the bestfit distribution for this. I'm using excel, so I need to be able to use xcel to graph it.


[PLAIN]http://img831.imageshack.us/img831/8770/unledcwx.png
 
Last edited by a moderator:
Physics news on Phys.org
I use CurveExpert to find best fit models; give that a try. Then simply evaluate a few points from the model and plot them as separate data.
 
adoado said:
I use CurveExpert to find best fit models; give that a try. Then simply evaluate a few points from the model and plot them as separate data.


Maybe I'm using the program wrong (I don't think I am), but it's not coming up with any results.


I have no Y values, only X's, so that may be the problem? There are lots of errors for almost every test. And when I click the "scan for bestfit" button, the 20 or so different best fit models it tests all come up with a Score of 0.0.
 
As I said in the other thread, you should use a cumulative histogram of the data. The x-axis should be the errors and the y-axis should be the frequency.
 

Similar threads

  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 7 ·
Replies
7
Views
2K
  • · Replies 3 ·
Replies
3
Views
4K
  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 11 ·
Replies
11
Views
3K
  • · Replies 1 ·
Replies
1
Views
1K
  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 15 ·
Replies
15
Views
2K
  • · Replies 3 ·
Replies
3
Views
1K
  • · Replies 9 ·
Replies
9
Views
5K