[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
11/02/2009 at 07:24PM PST, ID: 24866037 | Points: 500
[x]
Attachment Details

Bar Graphs / Histograms with 95% Confidence Interval 'Bars' - Quick way to make several?

Asked by justearth in Microsoft Excel Spreadsheet Software, Math & Science, Visual Basic Programming

Tags: excel, excel 2007, office, statistics, math, bar graph, histogram, 95%

Hello,
I have attached a worksheet and am looking for a way to make several bar graphs with 95% confidence intervals.  Is there a cool way to do this?  I want to make one set with the data (groupings) from Column A on the X axis and another set using Column B.  I want to have a bar with 95% confidence intervals for Columns G - M.

- Two graphs one for each grouping
- Each will have 7 bars using  Columns G - M
- Each bar will have 95% confidence interval 'bars'

Can this be done with a macro or script?  Each graph on a new sheet too.  If a macro some explanation of the macro would be nice too.


Thanks,
JE
Attachments:
 
JustEarth-bars-with-95-ci.xlsx (39 KB) (File Type Details) 
Example Spreadsheet
 
[+][-]11/03/09 04:55 AM, ID: 25728417

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/03/09 09:24 AM, ID: 25731265

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/03/09 09:29 AM, ID: 25731319

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/03/09 09:39 AM, ID: 25731429

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-91 - Hierarchy / EE_QW_3_20080625