Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
error bar types
I need a simple explanation for the function of the following error bars types:
- Error Bars with Standard Error - Error Bars with Percentage - Error Bars with Standard Deviation Thanks in advance |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
error bar types
The first and last use error bars computed from statistical measures from
the data - you would need a course in elementary stats to understand this. The percentage on use a percentage for the error bars. Example you want to plot with 10% error bars. Say one value is 60 then the error bars will go from ( 60 minus 10% of 60 ) to (60 plus 10% of 60) 60 minus 10% of 60 = 60 - (10/100)*60 = 60 - 6 = 54 60 plus 10% of 60 = 60 + (10/100)*60 = 6 +6 =66 best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Office_user" wrote in message ... I need a simple explanation for the function of the following error bars types: - Error Bars with Standard Error - Error Bars with Percentage - Error Bars with Standard Deviation Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error message "Some chart types cannot be combined with other char | Charts and Charting in Excel | |||
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
What does ISERROR look at besides the 7 Error Types? | Excel Worksheet Functions | |||
Counting the number of Error Types | Excel Worksheet Functions | |||
Issue writing IF OR Error Formula Types | New Users to Excel |