confidence interval

  1. D

    Calculate Confidence Interval for Binary Data Set

    Hi - I have a data set that is organized by date in column A and then in column B it is binary data of 0's and 1's where 1 means the customer was declined and 0 means it was not. Each week I calculate the rate that customers were declined and plot that out over a 12 week period. I now would...
  2. F

    Confidence Interval Trendline

    Hi All. New to the forum, so please be gentle. I have a bubble chart that I have a weighted trendline on. I'm not happy with how the line of best fit gives a misleading representation of the predictability of the data, hence I would like to replace this single line with a band of possible...
  3. J

    Charting confidence interval with a fuzzy line?

    Hi all, When building charts, I always like to include confidence intervals so the reader has a sense of how solid the results are. However, I don't think error bars do a great job of visually demonstrating the idea of a confidence interval. It shows the upper and lower range, but doesn't...
  4. M

    Question regarding how to plot interval estimates for a bell curve

    Hi! My group and I are doing a Business Statistics course, and we're pretty new at Microsoft Excel, so we're hoping we'll be able to get some help here! Microsoft Excel 2007. Question: Develop a 95% confidence interval estimate of the mean assets for the population of money market funds (the...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top