Finding best fit distribution and its Parameters

Click For Summary

Discussion Overview

The discussion revolves around finding the best fit distribution for a dataset and determining the parameters for that distribution. Participants explore various distribution models and methods for fitting, including considerations for data normalization and plotting techniques.

Discussion Character

  • Exploratory, Technical explanation, Debate/contested, Mathematical reasoning

Main Points Raised

  • One participant expresses a need to find the best fit distribution and its parameters after normalizing histograms, mentioning that logarithmic fitting is not suitable due to negative values.
  • Another participant suggests trying a Log-Normal distribution as a potential fit.
  • A request is made for guidance on how to perform the fitting process using Excel.
  • A further suggestion is made to define a new variable Y as the logarithm of the original variable X and to plot frequencies against this new variable, indicating that Excel may have options for logarithmic plotting.

Areas of Agreement / Disagreement

Participants present multiple competing views on the appropriate distribution to use, with no consensus reached on the best fit distribution or its parameters.

Contextual Notes

There are limitations related to the assumptions about the data distribution and the specific characteristics of the dataset that may affect the choice of fitting method.

Who May Find This Useful

Individuals interested in statistical analysis, data fitting, and those using Excel for data visualization and analysis may find this discussion relevant.

shegal
Messages
3
Reaction score
0
Thanks to EnumaElish for helping me in Normalizing the histograms. I now want to find the best fit distribution and what will be the parameters for that distribution. I tried lograthmic but it goes in negative and also is not much fit (the new plots are attached). If I use poisson what will be the parameters. Please help me in finding the bestfit distribution and its parameters.
 

Attachments

  • LL_DDoS_V1_Inside_Normalized.JPG
    LL_DDoS_V1_Inside_Normalized.JPG
    17.1 KB · Views: 594
  • LL_DDoS_v1_Outside_Normalized.JPG
    LL_DDoS_v1_Outside_Normalized.JPG
    16.7 KB · Views: 702
  • LL_DDoS_V2_Inside_Normalized.JPG
    LL_DDoS_V2_Inside_Normalized.JPG
    18.4 KB · Views: 561
Physics news on Phys.org
I'd try Log-Normal, per my previous advice.
 
How would you do this in excel.
 
Define Y = Log(X) where X is your original variable on the X-axis (apparently goes from 1 to 365 or so). Then plot the associated frequencies (of X) against Y. Excel might have a plotting option that let's you express either axis in Log form; if so, you can select that option to logarithmize the X axis.
 
Last edited:

Similar threads

  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 3 ·
Replies
3
Views
2K
  • · Replies 1 ·
Replies
1
Views
1K
  • · Replies 5 ·
Replies
5
Views
4K
  • · Replies 7 ·
Replies
7
Views
2K
  • · Replies 3 ·
Replies
3
Views
2K
  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 13 ·
Replies
13
Views
2K
  • · Replies 16 ·
Replies
16
Views
2K