Recent content by expertalmost

  1. E

    MHB How to calculate max/min scales on a scatter plot

    I've generated a working solution and just wanted to post it for future generations ;) Someone pointed out that because the data is not really fall under "standard error" due to the gaps, that medians +/- stddev would not really work. I have confirmed this with many days of attempts...
  2. E

    MHB How to calculate max/min scales on a scatter plot

    Thank you for your suggestions! You obviously know considerably more math than me and I appreciate your insights and experience. I will have to investigate cubic polynomials. Right now I take the 25 largest/smallest of the last 100 elements and average that. I also add a stddev amount to the...
  3. E

    MHB How to calculate max/min scales on a scatter plot

    Thank you for your time and questions! I appreciate your efforts. Here are some brief answers to your questions. 1) I use financial market analysis and these are the log-normal values of them. Whether the data is actually/truly log-normal is not really a concern as extremes are clipped and...
  4. E

    MHB How to calculate max/min scales on a scatter plot

    Good morning! I have 3 log scatter plots that I want to establish smooth maximum and minimum lines. What is the usual mathematical method to do that? (Image and excel file links below.) The black lines on the scatter plot images are hand drawn. The third scatter plot is especially tricky and...
Back
Top