confidence interval

  1. ferdaozdemirsonmez

    Multilevel bar chart show 95% confidence interval

    Hi, I have a multilevel bar chart. I need to show confidence intervals from the descriptive statistics. I can do this easily when I have single level. But with multiple levels (2 levels) I couldn't manage it. I don't want to create 6 charts instead of one for this reason. Can someone please...
  2. 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...
  3. 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...
  4. 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...
  5. 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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top