Excel - graphing mean and standard deviation

Posted by joe_shmoe on Super User See other posts from Super User or by joe_shmoe
Published on 2010-04-17T14:50:36Z Indexed on 2010/04/17 14:53 UTC
Read the original article Hit count: 313

Filed under:

excel

|

chart

Hi all,

I have measurements for multiple devices, and have their mean and sd values. I would like to produce a chart that would show these values, and I think the best would be if I could have something that looks like a bar chart(-ish) - the device names in x axis, values in y axis, and for each device to have a 'floating' bar that would represent values (mean - sd :: mean + sd), and some marker in the middle to show the actual mean value. is it doable? or would you suggest some other chart?

Thanks a lot

© Super User or respective owner

Related posts about excel

Excel error "This workbook contains Excel 4.0 macros or Excel 5.0 modules"

as seen on Super User - Search for 'Super User'
I have a workbook that was protected via the Protect Workbook feature. It was sent to someone else to modify. When they sent it back, it was unprotected and when I try to reprotect it I get this error, "This workbook contains Excel 4.0 macros or Excel 5.0 modules. If you would like to… >>> More
Open excel 2007 excel files and save as 97-2003 formats in VBA

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a weird situation where I have a set of excel files, all having the extension .xls., in a directory where I can open all of them just fine in Excel 2007. The odd thing is that I cannot open them in Excel 2003, on the same machine, without opening the file first in 2007 and going and saving… >>> More
Creating Excel or Excel compatible Spreadsheets on the server side in C#

as seen on Stack Overflow - Search for 'Stack Overflow'
I'd like to make server-side excel compatible spreadsheets that maybe use OpenXML or a structured data format. I've used Office Interop before to generate Excel spreadsheets, but those apps run on a PC that has office installed. For this web project I'm building, the server doesn't have office installed… >>> More
vba access values from excel workbook from another excel workbook

as seen on Stack Overflow - Search for 'Stack Overflow'
Any ideas why this code will not work? Workbooks.Open Filename:="C:\a.xls" Workbooks("a.xls").Activate Worksheets("b").Select Dim OutputArray(10, 10) OutputArray(1, 1) = Workbooks("c.xls").Worksheets("worksheet_otherthan_default").Select.Range(A1).Value I'm trying to run a macro in one file (unnamed… >>> More
Excel workbook event order and usage when closing Excel

as seen on Stack Overflow - Search for 'Stack Overflow'
Given the following workbook events: BeforeClose BeforeSave Please tell me: - The firing order in the case of multiple workbooks alreay opened (wb1, wb2 and wb3 are opened in this order) and the user closes Excel. You can assume all 3 needs saving. - What happen if user cancels one of the saving… >>> More

Related posts about chart

Designing javascript chart library

as seen on Programmers - Search for 'Programmers'
I started coding a chart library on top of d3js: My chart library. I read Javascript API reusability and Towards reusable charts. However, I am NOT really following the suggestions because I am not really convinced about them. This is how my library can be used to create a bubble chart: var… >>> More
Using Microsoft's Chart Controls In An ASP.NET Application: Serializing Chart Data

as seen on Internet.com - Search for 'Internet.com'
This article, by Scott Mitchell, shows how to store (and load) the data generated by the Microsoft Chart Controls to disk or some other store. >>> More
Using Microsoft's Chart Controls In An ASP.NET Application: Serializing Chart Data

as seen on Internet.com - Search for 'Internet.com'
This article, by Scott Mitchell, shows how to store (and load) the data generated by the Microsoft Chart Controls to disk or some other store. >>> More
Using Microsoft's Chart Controls In An ASP.NET Application: Serializing Chart Data

as seen on 4 Guys From Rolla - Search for '4 Guys From Rolla'
In most usage scenarios, the data displayed in a Microsoft Chart control comes from some dynamic source, such as from a database query. The appearance of the chart can be modified dynamically, as well; past installments in this article series showed how to programmatically customize the axes, labels… >>> More
Using Microsoft's Chart Controls In An ASP.NET Application: Serializing Chart Data

as seen on Internet.com - Search for 'Internet.com'
This article, by Scott Mitchell, shows how to store (and load) the data generated by the Microsoft Chart Controls to disk or some other store. >>> More