2 Replies Latest reply on Jan 28, 2016 6:12 AM by qi yin

    How to create a confidence level reference line in a histogram?

    qi yin

      I have a histogram chart showing the allocation of the return of a stock, bin has a size of 0.01. I want to create a 95% confidence level to show 95% of the time the return will fall into that range (say maybe -0.15 to 0.09). By adding default reference line, tableau is showing 95% chance of the number of counts will appear. So the problem is to add a confidence interval on a horizontal basis instead of a vertical basis. Can someone help?

       

      i tried to calculate the confidence interval with excel, but superisingly the calculated result is [-0.00161, 0.003299]. According to the obervation of the histogram, the confidence interval appreantly shouldn't fall into that range. Please also help me with this calculation....