#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 563
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
error message "Some chart types cannot be combined with other char n_alexiou Charts and Charting in Excel 6 May 19th 23 03:42 AM
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" roadsidetree Charts and Charting in Excel 15 June 2nd 09 10:53 AM
What does ISERROR look at besides the 7 Error Types? Bob Excel Worksheet Functions 5 November 17th 06 06:27 PM
Counting the number of Error Types Bob Excel Worksheet Functions 3 November 16th 06 06:01 PM
Issue writing IF OR Error Formula Types lozzam New Users to Excel 1 October 26th 06 08:14 AM


All times are GMT +1. The time now is 10:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"