Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Excel 2003 SP3
3000+/- data points in a row-by-row listing (A2 through A3001) STDEV provides the 1st standard deviation. 1) Unless I'm missing something, how do I do 2nd and 3rd standard deviation calculations? 2) Some of my data is 'fringe' data. That is, by eyeballing the data I'm seeing some data that doesn't easily 'fit'. a) Can I eliminate the 'fringe' data somehow via a formula? b) Can I analyze ONLY the 'fringe' data? c) How do I quantify the 'fringe' data for exclusion or inclusion? 3) Some insight into 2nd/3rd standard deviations would be appreciated relative to Excel 2003. TIA! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 does not take more than 255 datapoints | Charts and Charting in Excel | |||
intergrate a curve of datapoints | Excel Discussion (Misc queries) | |||
Help with datapoints stack in XYScatter | Charts and Charting in Excel | |||
Datapoints | Charts and Charting in Excel | |||
Specific datapoints selection | Charts and Charting in Excel |